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 : 28-06-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-02337 : not an object type column
  • ora-13348 : polygon boundary is not closed
  • ora-36275 : (XSCGMDLAGG13) string is not a valid workspace object.
  • ora-01697 : control file is for a clone database
  • ora-30190 : reserved for future use
  • ora-12353 : secondary stored object cannot reference remote object
  • ora-02227 : invalid cluster name
  • ora-24907 : invalid pair of callback and recepient protocol attributes
  • ora-01784 : RECOVERABLE cannot be specified with database media recovery disabled
  • ora-02832 : Segment deallocation failed - segment not on list
  • ora-25177 : UNRECOVERABLE option not permitted
  • ora-16704 : cannot modify a read-only property
  • ora-07221 : slspool: exec error, unable to start spooler program.
  • ora-36212 : (XSAGOP06) In AGGMAP workspace object, you can only specify the MIN, MAX, FLOOR, and CEILING arguments while using the PROPORTIONAL operator, not string.
  • ora-22319 : type attribute information altered in ALTER TYPE
  • ora-04003 : sequence parameter string exceeds maximum size allowed (string digits)
  • ora-01912 : ROW keyword expected
  • ora-30489 : Cannot have more than one rollup/cube expression list
  • ora-19813 : cannot have unavailable file string in DB_RECOVERY_FILE_DEST
  • ora-00266 : name of archived log file needed
  • ora-32614 : illegal MODEL SELECT expression
  • ora-25425 : connection lost during rollback
  • ora-22620 : buffer size too small to hold the value
  • ora-00394 : online log reused while attempting to archive it
  • ora-12033 : cannot use filter columns from materialized view log on "string"."string"
  • ora-25275 : Test support for buffered queues
  • ora-07402 : sprst: cannot restore user signal handler.
  • ora-15122 : ASM file name 'string' contains an invalid file number
  • ora-28179 : client user name not provided by proxy
  • ora-28004 : invalid argument for function specified in PASSWORD_VERIFY_FUNCTION string
  • 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.