Disable Foreign Key Constraints
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