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-03131: an invalid buffer was provided for the next piece

1 Answers  


ORA-15071: ASM disk "string" is already being dropped

1 Answers  


ORA-07221: slspool: exec error, unable to start spooler program.

1 Answers  


ORA-14166: missing INTO keyword

1 Answers  


ORA-09706: slsget: get_process_stats error.

1 Answers  






ORA-01598: rollback segment 'string' is not online

1 Answers  


ORA-16035: missing required keyword string

1 Answers  


ORA-38476: abstract type used for an Attribute set may not be modified.

1 Answers  


ORA-07570: szrfc: $IDTOASC failure

1 Answers  


O2U-00204: Unable to convert from the database character set to the compiler character set

1 Answers  


ORA-25106: only one of PARALLEL or NOPARALLEL clause may be specified

1 Answers  


ORA-26102: relative file # in file header is string rather than string for file string

1 Answers  


Categories