Re: Constraint Enable/Disable

[Nikunj Gupta]

Hi,   Hope these script will help you..   Disable Constraints..   select 'alter table &tab disable constraint '||constraint_name||' cascade;'   from dba_constraints   where owner = upper('&owner') and   table_name = upper('&tab')   /   Enable Constraints   select 'alter table &tab enable constraint '||constraint_name||';'   from dba_constraints   where owner = upper('&owner') and   table_name = upper('&tab')   /   Try these in your test environment.. and have fun   Nikunj   ------------------------------------ Make a FREE long distance call from your PC! http://www.eboom.com/free/ ----- Original Message ----- From: Sujatha Madan To: Multiple recipients of list ORACLE-L Sent: Thursday, November 01, 2001 08:15 PM Subject: Constraint Enable/Disable Hi, Is there a way to disable all constraints, and then enable them all again? Thanx Sujatha