Thursday 12 April 2012

ORA-22894: cannot add constraint on existing unscoped REF columns of non-empty tables

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.

No comments:

Post a Comment