begin for c in (select * from user_triggers a where a.trigger_name not like '%$xd' ) loop execute immediate('alter trigger '||c.trigger_name||' DISABLE'); end loop; end;
various observations, solutions and frustrations on programming java and .net.
Friday, November 25, 2011
SQL Plus script to disable/enable all triggers an Oracle database
Below is an SQL Plus script to disable/enable all triggers for the current user in an Oracle database. This is useful when importing data in an oracle database and you do not want triggers firing. Substitute "DISABLE" below with "ENABLE" to enable back triggers after data import.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment