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-12608: TNS: Send timeout occurred

1 Answers  


ORA-26501: RepAPI operation failure

1 Answers  


NNL-00916: Modification requests enabled: string

1 Answers  


ORA-01032: no such userid

1 Answers  


SQL-02122: Invalid OPEN or PREPARE for this database connection

1 Answers  






ORA-06301: IPA: Cannot allocate driver context

1 Answers  


ORA-14522: Partition-level default tablespace string block size [string] for string string does not match existing string block size [string]

1 Answers  


ORA-00094: %s requires an integer value

1 Answers  


ORA-06134: NETTCP: file access privilege violation

1 Answers  


QSM-00511: invalid fact-tables specified in fact-filter

1 Answers  


ORA-25195: invalid option for index on an index-organized table

1 Answers  


ORA-27487: invalid object privilege for a string

1 Answers  


Categories