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

Oracle Error Message

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

Reason for the Error

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

Solution

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