ORA-10631: SHRINK clause should not be specified for this object

Cause : It i sincorrect ot isseu shrnik ont he ojbect

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Veriyf theo bjec tnamea nd tpye an dreisuse th ecommnad

update : 20-08-2017
ORA-10631

ORA-10631 - SHRINK clause should not be specified for this object
ORA-10631 - SHRINK clause should not be specified for this object

  • ora-01725 : USERENV('COMMITSCN') not allowed here
  • ora-16156 : LGWR archive log dependency not allowed if database is standby protected
  • ora-16583 : bad Data Guard Connection Process DRCX state
  • ora-31080 : type not specified for attribute or element "string"
  • ora-25331 : cannot downgrade because there are commit-time queue tables
  • ora-28008 : invalid old password
  • ora-13911 : Threshold not found
  • ora-06701 : TLI Driver: incorrect number of bytes written
  • ora-36700 : (XSRELTBL04) Dimension workspace object cannot be qualified more than once.
  • ora-26001 : Index string specified in SORTED INDEXES does not exist on table string
  • ora-38716 : Must supply an integer for the TYPE option.
  • ora-26718 : transaction limit reached
  • ora-29836 : failed to validate referenced operators
  • ora-12033 : cannot use filter columns from materialized view log on "string"."string"
  • ora-28157 : Proxy user 'string' forbidden to set role 'string' for client 'string'
  • ora-19042 : Enclosing tag string cannot be xml in any case combination
  • ora-19677 : RMAN configuration name exceeds maximum length of string
  • ora-13419 : cannot perform mosaick operation on the specified table column
  • ora-16779 : the destination parameter of a database is set incorrectly
  • ora-16206 : database already configured as Logical Standby database
  • ora-19267 : XQ0047 - module string not found
  • ora-02219 : invalid NEXT storage option value
  • ora-14268 : subpartition 'string' of the partition resides in offlined tablespace
  • ora-22888 : duplicate SCOPE clauses for a REF column
  • ora-01203 : wrong incarnation of this file - wrong creation SCN
  • ora-01879 : the hh25 field must be between 0 and 24
  • ora-26563 : renaming this table is not allowed
  • ora-06266 : NETNTT: bad write length
  • ora-26532 : replication parallel push simulated site failure
  • ora-16575 : request terminated at broker discretion
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.