ORA-22884: object modification failed

Cause : The object could not be modified in the database.

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

Check to see if the object table exists and the object size is not too big. Then retry the operation.

update : 25-06-2017
ORA-22884

ORA-22884 - object modification failed
ORA-22884 - object modification failed

  • ora-16215 : history metadata inconsistency
  • ora-14117 : partition resides in offlined tablespace
  • ora-37111 : Unable to load the OLAP API sharable library: (string)
  • ora-30439 : refresh of 'string.string' failed because of string
  • ora-02188 : Cannot enable instance publicly
  • ora-31014 : Attempted to delete the root container
  • ora-12432 : LBAC error: string
  • ora-14520 : Tablespace string block size [string] does not match existing object block size [string]
  • ora-28045 : SSL authentication between database and OID failed
  • ora-02377 : invalid resource limit
  • ora-14294 : Number of partitions does not match number of subpartitions
  • ora-07643 : smsalo: SMSVAR is invalid
  • ora-39316 : call to DBMS_SCHEMA_COPY.CLEAN_UP is not legal
  • ora-30450 : refresh_after_errors was TRUE; The following MVs could not be refreshed: string
  • ora-30376 : prevent sharing of a parsed query of an explain rewrite session
  • ora-38787 : Creating the first guaranteed restore point requires mount mode when flashback database is off.
  • ora-13523 : unable to allocate required space for return type
  • ora-31664 : unable to construct unique job name when defaulted
  • ora-14173 : illegal subpartition-extended table name syntax
  • ora-29828 : invalid name for implementation type
  • ora-32333 : disable table scn update for Materialized view
  • ora-15043 : ASM disk "string" is not a diskgroup member
  • ora-25226 : dequeue failed, queue string.string is not enabled for dequeue
  • ora-34164 : (MXCGVAR01) A dimension used to define a local string variable cannot be located. Execution cannot continue.
  • ora-02790 : File name is too long
  • ora-25449 : invalid variable name: string
  • ora-37151 : MDX parser initialization error
  • ora-30574 : Cannot create rollback segment in tablespace with AUTO segment space management
  • ora-30118 : syntax error at 'string' at the end of input
  • ora-02463 : Duplicate HASH IS option specified
  • 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.