Disable/enable all triggers of schema - Oracle Database Script. ----- Connect to the user and run this. BEGIN FOR i IN (SELECT trigger_name FROM user_triggers) LOOP EXECUTE IMMEDIATE 'ALTER TRIGGER ' || i.trigger_name || ' DISABLE'; END LOOP; END; /
----- Connect to the user and run this. BEGIN FOR i IN (SELECT trigger_name FROM user_triggers) LOOP EXECUTE IMMEDIATE 'ALTER TRIGGER ' || i.trigger_name || ' DISABLE'; END LOOP; END; /