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-12403: invalid internal label

1 Answers  


ORA-12641: Authentication service failed to initialize

2 Answers  


RMAN-06707: could not initialize for output file: "string"

1 Answers  


ORA-37031: (XSMLTMAINT02) You cannot MOVE, DELETE, or add SESSION values of dimension workspace object in MULTI mode.

1 Answers  


ORA-39311: illegal clone_recovery() call: it only applys to failed clones

1 Answers  






ORA-07577: no such user in authorization file

1 Answers  


IMP-00004: invalid username or password

1 Answers  


RMAN-06035: wrong version of recover.bsq, expecting string, found string

2 Answers  


RMAN-08509: destination for restore of datafile string: string

1 Answers  


ORA-00353: log corruption near block string change string time string

1 Answers  


ORA-08233: smsdes: cannot unmap SGA

2 Answers  


ORA-25959: join index must be of the bitmap type

1 Answers  


Categories