Sunday, November 30, 2008

ORACLE DATABASE- ENABLE/DISABLE ALL TRIGGERS

ENABLE:
begin
for i in (select table_name from user_triggers
) LOOP
execute immediate 'alter table '||i.table_name||' enable all triggers '||'';
end loop;
end;


DISABLE:
begin
for i in (select table_name from user_triggers
) LOOP
execute immediate 'alter table '||i.table_name||' disable all triggers '||'';
end loop;
end;