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..

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-19007: Schema string does not match expected string.

1 Answers  


ORA-14288: index is not partitioned by Composite Range method

1 Answers  


ORA-12433: create trigger failed, policy not applied

1 Answers  


ORA-19732: incorrect number of datafiles for tablespace string

1 Answers  


PLS-00517: Type mismatch between a select list element 'string' and corresponding table column in INSERT statement with a subquery

1 Answers  






ORA-16725: the phase supplied to resource manager is invalid

1 Answers  


DRG-11500: column name expected, found string on line string

1 Answers  


TNS-12552: TNS:operation was interrupted

1 Answers  


DRG-11851: Cache Related Warning

1 Answers  


ORA-30765: cannot modify scope for an unscoped REF column

1 Answers  


EXP-00006: internal inconsistency error

1 Answers  


ORA-07239: slemrd: invalid file handle, seals do not match.

1 Answers  


Categories