gouthami

• Aug 13th, 2006

 

Alter table tablename disable all triggers;

dineshchaini

 Profile Answers by dineshchaini 

• Aug 13th, 2006

 

ALTER TABLE<TABLE  NAME> DISABLE ALL TRIGGER

srinivas

• Aug 23rd, 2006

 

ALTER TABLE<TABLE  NAME> DISABLE ALL TRIGGER

Brijesh Mishra

• Oct 9th, 2006

 

SQL> Spool c:tempdisable_all_trigger

SQL> Select 'ALTER TRIGGER '|| trigger_name ||' disable;' from user_triggers;

SQL> spool off

after that open file disable_all_trigger.lst and remove header part and save file.

SQL>@c:tempdisable_all_trigger.lst

Raghavendra

• Nov 19th, 2006

 

Alter table <table name> disable all trigger;