ORA-22898: existing scope clause on "string" points to a table other than the one mentioned in the referential constraint

Cause : Table mentioned in the referential integrity constraint is different from the scope table of the REF column.

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

Specify the scope table of the REF column in the referential integrity constraint and then retry the operation.

update : 22-09-2017
ORA-22898

ORA-22898 - existing scope clause on "string" points to a table other than the one mentioned in the referential constraint
ORA-22898 - existing scope clause on "string" points to a table other than the one mentioned in the referential constraint

  • ora-09967 : unable to create or open lock file
  • ora-04930 : open sequence number failed or initial state is valid
  • ora-00163 : internal database name length string is greater than maximum (string)
  • ora-36986 : (XSRELGID05) Relation workspace object must be dimensioned by workspace object.
  • ora-13120 : invalid face_id [string]
  • ora-27144 : attempt to kill process failed
  • ora-10632 : Invalid rowid
  • ora-38422 : invalid datatype for the attribute: string
  • ora-08002 : sequence string.CURRVAL is not yet defined in this session
  • ora-00406 : COMPATIBLE parameter needs to be string or greater
  • ora-02275 : such a referential constraint already exists in the table
  • ora-14628 : specification of bounds is inconsistent with LIST method
  • ora-36968 : (XSRELTBL11) workspace object must be a relation.
  • ora-30931 : Element 'string' cannot contain mixed text
  • ora-27157 : OS post/wait facility removed
  • ora-13791 : cannot resume a tuning task created to tune a single statement
  • ora-27501 : IPC error creating a port
  • ora-15070 : maximum number of files string exceeded in diskgroup "string"
  • ora-32126 : Cannot perform operations on a null REF
  • ora-19765 : mount id string does not match mount id string in control file
  • ora-28652 : overflow segment attributes cannot be specified
  • ora-22892 : scoped table "string" does not exist in schema "string"
  • ora-02713 : osnprd: message receive failure
  • ora-29398 : invalid privilege name specified
  • ora-04062 : %s of string has been changed
  • ora-16023 : system string destination cannot be the same as session string destination
  • ora-15037 : disk 'string' is smaller than mimimum of string MBs
  • ora-12732 : invalid interval value in regular expression
  • ora-32509 : watchpoint was already deleted
  • ora-31517 : CDC change table string.string already exists
  • 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.