Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-22896 – cannot have both scope and referential constraint on REF column “string”

Oracle Database Error Code ORA-22896 Description :

cannot have both scope and referential constraint on REF column “string”

Error Cause:

REF column has both a referential and a scope constraint. A referential constraint implies a scope constraint.

How to Solve :

Remove either the referential or scope constraint and then retry the operation.