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-25209: invalid value string, EXPIRATION should be non-negative or NEVER

1 Answers  


RMAN-06481: WARNING: backup piece 'string' cannot be found on the storage medium

1 Answers  


RMAN-06246: List of Database Incarnations

1 Answers  


DRG-50859: failed to allocate statement handle

1 Answers  


QSM-00797: the specified workload string does not exist for the current user

1 Answers  






NNL-00272: Removed name "string" from caches along the following path:

1 Answers  


ORA-32604: invalid REBUILD option

1 Answers  


ORA-08266: create_ora_addr: cannot register name in nameserver

1 Answers  


RMAN-06494: %s = string is out of range (string-string)

1 Answers  


RMAN-06454: duplexed backups require Enterprise Edition

1 Answers  


PLS-00733: RPCs to variable argument functions are not allowed

1 Answers  


ORA-25438: invalid variable name: string

1 Answers  


Categories