ORA-22896: cannot have both scope and referential constraint
on REF column "string"



ORA-22896: cannot have both scope and referential constraint on REF column "string"..

Answer / guest

Cause: REF column has both a referential and a scope
constraint. A referential constraint implies a scope constraint.

Action: Remove either the referential or scope constraint
and then retry the operation.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07801: slbtpd: invalid exponent

1 Answers  


ORA-01338: Other process is attached to LogMiner session

1 Answers  


ORA-16704: Cannot set the property because it is read-only

1 Answers  


ORA-25225: invalid value string, DEQUEUE_MODE should be REMOVE or BROWSE or LOCKED

1 Answers  


ORA-29360: retry operation. Too much concurrent activity

1 Answers  






PLS-01425: Connect-by clause

1 Answers  


ORA-01510: error in deleting log files

1 Answers  


TNS-04064: The number of CMCTL sessions exceeds MAX_CMCTL_SESSIONS.

1 Answers  


ORA-18002: the specified outline does not exist

1 Answers  


ORA-24402: error occured while creating connections in the pool

1 Answers  


ORA-30162: The OCIFile context is not initialzed

1 Answers  


ORA-00123: idle public server terminating

1 Answers  


Categories