Oracle DBA, How To, Error, Cause and Action

ORA-02297: cannot disable constraint (string.string) - dependenciesexist

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