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;
Sunday, November 30, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment