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-02458: HASHKEYS must be specified for a HASH CLUSTER

1 Answers  


ORA-33270: (DBERR05) Analytic workspace string already exists.

1 Answers  


NZE-29027: Error in entropy collection

1 Answers  


TNS-01026: Start Date string

1 Answers  


ORA-14183: TABLESPACE DEFAULT can be specified only for Composite LOCAL index

1 Answers  


PCC-00023: Unable to log off from ORACLE

1 Answers  


ORA-06401: NETCMN: invalid driver designator

1 Answers  


ORA-02464: Cluster definition can not be both HASH and INDEX

1 Answers  


ORA-31085: schema "string" already registered

1 Answers  


ORA-10637: The segment does not exist

1 Answers  


TNS-00509: Buffer overflow

1 Answers  


SQL*Loader-00133: Can't specify both direct path and external tables

1 Answers  


Categories