Oracle DBA, How To, Error, Cause and Action

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

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


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

No comments:

Post a Comment

Thanks for your comment.