Oracle Error ORA-30766: cannot modify scope for a REF column with a REFERENCES constraint

Oracle Error Message

ORA-30766: cannot modify scope for a REF column with a REFERENCES constraint

Reason for the Error

An attempt was made to modify the scope for a REF column with a REFERENCES constraint.

Solution

Drop the REFERENCES constraint, and retry the operation.