ORA-02297: cannot disable constraint (string.string) -
dependencies exist



ORA-02297: cannot disable constraint (string.string) - dependencies exist..

Answer / guest

Cause: an alter table disable constraint failed becuase the
table has foriegn keys that are dpendent on this constraint.

Action: Either disable the foreign key constraints or use
disable cascade

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCC-02303: cannot open include file

1 Answers  


ORA-02840: Open of log file by client failed

1 Answers  


ORA-02187: invalid quota specification

1 Answers  


RMAN-10010: error while checking for RPC completion

1 Answers  


ORA-25182: feature not currently available for index-organized tables

1 Answers  






AMD-00138: level names parameter not null or defaulted

1 Answers  


RMAN-20299: DBMS_RCVMAN package not compatible with the recovery catalog

1 Answers  


ORA-23480: Column string is not a top-level column of "string"."string".

1 Answers  


ORA-37072: (XSMCSESS00) Object workspace object has the wrong type.

1 Answers  


ORA-28651: Primary index on IOTs can not be marked unusable

1 Answers  


ORA-34177: (MXCHGDCL19) number cannot be deleted because one or more partitioned variables instantiate it.

1 Answers  


TNS-01164: No spawn alias sent to listener

1 Answers  


Categories