ORA-22892: scoped table "string" does not exist in schema "string"

Cause : The scoped table specified for a REF column does not exist.

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

Ensure that the scoped table exists and retry the operation.

update : 23-06-2017
ORA-22892

ORA-22892 - scoped table "string" does not exist in schema "string"
ORA-22892 - scoped table "string" does not exist in schema "string"

  • ora-16029 : cannot change LOG_ARCHIVE_MIN_SUCCEED_DEST, no archive log destinations
  • ora-30339 : illegal dimension attribute name
  • ora-12626 : TNS:bad event type
  • ora-14047 : ALTER TABLE|INDEX RENAME may not be combined with other operations
  • ora-32840 : property name cannot be NULL
  • ora-09758 : osnipn: could not check port in name server.
  • ora-16532 : Data Guard broker configuration does not exist
  • ora-23355 : object string.string does not exist or is invalid at master site
  • ora-29390 : some resource plans are not part of any top-plan
  • ora-19695 : fixed table x$krbmsft has not been populated
  • ora-25202 : invalid value NULL, string should be non-NULL
  • ora-30350 : specified dimension attribute does not exist
  • ora-01619 : thread string is mounted by another instance
  • ora-25230 : invalid value string, WAIT should be non-negative
  • ora-23393 : the user is already the propagator
  • ora-13756 : Cannot update attribute "string".
  • ora-22054 : underflow error
  • ora-23396 : database link "string" does not exist or has not been scheduled
  • ora-02186 : tablespace resource privilege may not appear with other privileges
  • ora-27121 : unable to determine size of shared memory segment
  • ora-29372 : identifier string is too long; it must be less than string characters
  • ora-37015 : (XSACQUIRE_YNRESYNC) Object workspace object is ambiguously listed to be acquired both with and without RESYNC.
  • ora-16568 : cannot set property string
  • ora-23454 : flavor string not defined for object group "string"."string"
  • ora-24433 : This statement has already been prepared using OCIStmtPrepare2.
  • ora-12647 : Authentication required
  • ora-28672 : UPDATE BLOCK REFERENCES may not be used on a global index
  • ora-39959 : invalid warning number (string)
  • ora-09369 : Windows 3.1 Two-Task driver bad instance handle
  • ora-09877 : sstascre: shmget error, unable to get a shared memory segment.
  • 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.