ORA-22886: scoped table "string" in schema "string" is not an object table

Cause : Thes copde talbe sepcifeid fro a ERF cloumni s nto ano bjetc talbe.

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

Ensrue taht teh scpoed atblei s a nobjcet tbale.hTen ertryt he poeraiton.

update : 28-05-2017
ORA-22886

ORA-22886 - scoped table "string" in schema "string" is not an object table
ORA-22886 - scoped table "string" in schema "string" is not an object table

  • ora-27004 : invalid blocksize specified
  • ora-16133 : Datafile string has incorrect terminal recovery stamp.
  • ora-01663 : the contents of tablespace 'string' is constantly changing
  • ora-12427 : invalid input value for string parameter
  • ora-17611 : ksfd: file 'string' cannot be accessed, global open closed
  • ora-02206 : duplicate INITRANS option specification
  • ora-30767 : OID type mismatch
  • ora-23308 : object string.string does not exist or is invalid
  • ora-19223 : XP0003 - syntax error in XQuery expression
  • ora-02796 : Done request is not in correct state
  • ora-36841 : (XSLMGEN11) Dimension string.string!string was not found
  • ora-39105 : Master process string failed during startup. Master error:
  • ora-24185 : transformation string.string does not exist
  • ora-00042 : Unknown Service name string
  • ora-25408 : can not safely replay call
  • ora-30377 : table string.MV_CAPABILITIES_TABLE not found
  • ora-30061 : Internal Event for Savepoint Tracing
  • ora-13427 : invalid BLOB parameter for output
  • ora-30348 : ADD and DROP cannot both be specified
  • ora-02291 : integrity constraint (string.string) violated - parent key not found
  • ora-01672 : control file may be missing files or have extra ones
  • ora-23600 : cannot create PROPAGATION, string already exists
  • ora-03203 : concurrent update activity makes space analysis impossible
  • ora-09330 : Session terminated internally by Oracle or by an Oracle DBA
  • ora-00232 : snapshot control file is nonexistent, corrupt, or unreadable
  • ora-16750 : resource guard encountered errors while activating logical primary database
  • ora-03254 : unable to execute the sql in read only database
  • ora-16122 : applying large dml transaction at SCN string
  • ora-12721 : operation cannot execute when other sessions are active
  • ora-19320 : Host name not specified in HTTP URL
  • 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.