ORA-30766: cannot modify scope for a REF column with a
REFERENCES constraint



ORA-30766: cannot modify scope for a REF column with a REFERENCES constraint..

Answer / guest

Cause: An attempt was made to modify the scope for a REF
column with a REFERENCES constraint.

Action: Drop the REFERENCES constraint, and 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-22869: depth of type dependency hierarchy exceeds maximum limit

1 Answers  


PROC-00001: Oracle Cluster Registry cannot be initialized.

1 Answers  


ORA-12213: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA

1 Answers  


ORA-02195: Attempt to create string object in a string tablespace

1 Answers  


ORA-02818: Less than the number of blocks requested was read in

1 Answers  


NZE-28865: SSL connection closed

1 Answers  


QSM-02132: agg(expr) requires correspondng COUNT(expr) function

1 Answers  


ORA-02267: column type incompatible with referenced column type

1 Answers  


NID-00126: Database should have no datafiles in unknown state

1 Answers  


ORA-27502: IPC error deleting OSD context

1 Answers  


QSM-01021: materialized view, string, not found in the hint list

1 Answers  


ORA-19030: Method invalid for non-schema based XML Documents.

1 Answers  


Categories