ORA-22895: referenced table "string" in schema "string" is not an object table

Cause : Ther efeernce dtabel spceifide fo ra RFE coulmn si no tan bojec ttabel.

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

Ensrue taht teh reefrenecd tbale si ano bjetc talbe.Tehn rtery hte oepratoin.

update : 25-04-2017
ORA-22895

ORA-22895 - referenced table "string" in schema "string" is not an object table
ORA-22895 - referenced table "string" in schema "string" is not an object table

  • ora-26765 : invalid parameter "string" for downstream capture "string"
  • ora-30343 : level name is not unique within this dimension
  • ora-25198 : only range, list, and hash partitioning are supported for index-organized table
  • ora-31023 : Index size error
  • ora-27048 : skgfifi: file header information is invalid
  • ora-31495 : error in synchronous change table on "string"."string"
  • ora-14021 : MAXVALUE must be specified for all columns
  • ora-01165 : MAXDATAFILES may not exceed string
  • ora-06960 : Failed to access log file
  • ora-27086 : unable to lock file - already in use
  • ora-07671 : $IDTOASC failed translating an integrity category
  • ora-24327 : need explicit attach before authenticating a user
  • ora-24329 : invalid character set identifier
  • ora-29356 : These parameters can be specified only for directives that refer to consumer groups
  • ora-10584 : Can not invoke parallel recovery for test recovery
  • ora-27149 : assignment out of range
  • ora-16824 : Fast-Start Failover and other warnings detected for the database
  • ora-01577 : cannot add log file 'string' - file already part of database
  • ora-31199 : Warning in processing file string
  • ora-22999 : CLOB or NCLOB data may have been corrupted
  • ora-12637 : Packet receive failed
  • ora-27454 : argument name and position cannot be NULL
  • ora-29883 : cannot create a domain index on column expressions
  • ora-22633 : Error freeing AnyDataSet
  • ora-02073 : sequence numbers not supported in remote updates
  • ora-00356 : inconsistent lengths in change description
  • ora-29503 : SCHEMA keyword not valid with NAMED keyword
  • ora-07880 : sdopnf: internal error
  • ora-14314 : resulting List partition(s) must contain atleast 1 value
  • ora-12550 : TNS:syntax error
  • 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.