Skip to Main Content

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!

Disable Foreign Key Constraints

Christine1111Apr 12 2007 — edited Apr 13 2007
Hi -

I need to disable all constraints on a table before I can truncate it and I'm using a PL/SQL script to do it. I was able to successfully disable all active constraints on the table in question by selecting from user_constraints. However, there is still a foreign key constraint coming from another table and I'm not sure how to include that in my original select, because I don't see anything linking it back to my source table in user_constraints.

Any ideas???

Thanks,
Christine
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2007
Added on Apr 12 2007
6 comments
8,574 views