Oracle Database Errors or Warnings from Error ORA-22887 to ORA-22896

SQLServerF1

ORA-22887: type of REF column is not the same as that of its scoped table
Cause: The type specified for the REF column and the type specified for the scope table are different.
Action: Ensure that the types of a REF column and its scoped table are the same.
ORA-22888: duplicate SCOPE clauses for a REF column
Cause: Multiple SCOPE clauses were specified for a single REF column.
Action: Remove the duplicate SCOPE clauses and retry the operation.
ORA-22889: REF value does not point to scoped table
Cause: An attempt was made to insert a REF value that does not point to the scoped table.
Action: Ensure that the REF values point to the scoped table.
ORA-22890: cannot specify name for REF column constraint
Cause: An attempt was made to specify a constraint name for a constraint on a REF column.
Action: Remove the constraint name and retry the operation.

ORA-22891: cannot have multiple columns in REF constraint
Cause: An attempt was made to specify multiple columns in a single REF constraint.
Action: Specify separate constraints for each column and retry the operation.
ORA-22892: scoped table “string” does not exist in schema “string”
Cause: The scoped table specified for a REF column does not exist.
Action: Ensure that the scoped table exists and retry the operation.
ORA-22893: constraint can be specified only for REF columns
Cause: The constraint specified does not apply to non-REF columns.
Action: Remove the constraint and retry the operation.

ORA-22894: cannot add constraint on existing unscoped REF columns of non-empty tables
Cause: An attempt was made to add a constraint to existing unscoped REF columns of a table which contains one or more rows.
Action: Remove the constraint specification or add the constraint after emptying the table.
ORA-22895: referenced table “string” in schema “string” is not an object table
Cause: The referenced table specified for a REF column is not an object table.
Action: Ensure that the referenced table is an object table.Then retry the operation.
ORA-22896: cannot have both scope and referential constraint on REF column “string”
Cause: REF column has both a referential and a scope constraint. A referential constraint implies a scope constraint.
Action: Remove either the referential or scope constraint and then retry the operation.

Above are list of Oracle Database Errors or Warnings from Error ORA-22887 to ORA-22896 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *