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

RMAN-06140: cannot specify TAG option with LIST INCARNATION

1 Answers  


ORA-09857: smprset: vm_protect error while protecting pga.

1 Answers  


ORA-22858: invalid alteration of datatype

1 Answers  


IMG-00842: image index allocation failed

1 Answers  


NZE-28782: data source is not allocated

1 Answers  






RMAN-03036: Debugging set to level=number, types=string

1 Answers  


ORA-31040: Property string: XML type (string) not compatible with internal memory type (string)

1 Answers  


TNS-02519: no appropriate key-negotiation parameters

1 Answers  


ORA-32013: failure in verifying parameters from the restored SPFILE

1 Answers  


ORA-33449: (ESDREAD17) Discarding compiled code for workspace object because the partition method or partition dimension of number has changed since it was compiled.

1 Answers  


ORA-16089: archive log has already been registered

1 Answers  


NNL-00525: Shows or sets the server's default-forwarding status

1 Answers  


Categories