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

DRG-11733: more than one translation for the term in the specified language

1 Answers  


DRG-50907: score threshold string outside valid range 1 to 100

1 Answers  


PLS-00483: exception 'string' may appear in at most one exception handler in this block

1 Answers  


ORA-30490: Ambiguous expression in GROUP BY ROLLUP or CUBE list

1 Answers  


RMAN-06591: must specify TO PLATFORM

1 Answers  


ORA-09742: sppst: error during a post.

1 Answers  


ORA-02463: Duplicate HASH IS option specified

1 Answers  


LPX-00256: invalid element declaration

1 Answers  


LSX-00159: list content of multiple simple types is not allowed

1 Answers  


QSM-01126: query rewritten with set operator materialized view, string

1 Answers  


ORA-29826: keyword FOR is missing

1 Answers  


TNS-00105: Could not initialize tracing

1 Answers  


Categories