SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how do you disable a constraint that has a dependancies existence

user13328581Dec 15 2010 — edited Dec 15 2010

Good Morning Experts,

I am trying to disable a constraint on a table using the following statement below

alter table tbl_one
disable constraint t_ID

but I keep getting the error message

ora-02297: cannot disable constraint(finance.t_ID) - dependencies exist

Edited by: user13328581 on Dec 15, 2010 6:54 AM

Edited by: user13328581 on Dec 15, 2010 7:03 AM

This post has been answered by Hoek on Dec 15 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 12 2011

Added on Dec 15 2010

5 comments

11,164 views