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

ORA-24018: STOP_QUEUE on string failed, outstanding transactions found

1 Answers  


ORA-24006: cannot create QUEUE, string already exists

1 Answers  


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

1 Answers  


SQL*Loader-00952: Error calling once/data file initialization

1 Answers  


ORA-32630: multiple assignment in automatic order MODEL

1 Answers  






RMAN-06577: FROM TAG option may only be used with datafilecopies

1 Answers  


DRG-12016: The target document for this operation has moved - continue?

1 Answers  


KUP-04029: numeric field overflowed

1 Answers  


ORA-13004: the specified buffer size is invalid

1 Answers  


PROC-00030: Oracle Cluster Registry IDs do not match

1 Answers  


NZE-29036: This feature is not supported

1 Answers  


ORA-02482: Syntax error in event specification (string)

1 Answers  


Categories