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

IMP-00001: respond with either string, string, RETURN or '.' to quit

1 Answers  


ORA-08321: scnmin: NOT IMPLEMENTED YET

1 Answers  


ORA-15027: open files in diskgroup "string" preclude its dismount

1 Answers  


ORA-01199: file string is not in online backup mode

1 Answers  


PLS-01412: Use of 'EXP' token

1 Answers  






ORA-39149: cannot link privileged user to non-privileged user

1 Answers  


PLS-00702: second argument to PRAGMA EXCEPTION_INIT must be a numeric literal

1 Answers  


PCC-01013: Invalid use of PIC N array variable "string" at line number in file string

1 Answers  


ORA-06745: TLI Driver: listener already running

1 Answers  


ORA-09717: osnsui: maximum number of user interrupt handlers exceeded.

1 Answers  


ORA-08177: can't serialize access for this transaction

1 Answers  


ORA-38487: FUNCTION/PACKAGE/TYPE "string" not allowed in the expression

1 Answers  


Categories