📋Steps in this guide1/1

Disable/enable all triggers of schema

----- Connect to the user and run this.

oracle configurationintermediate

by OracleDba

15 views

Disable/enable all triggers of schema

Code/Command (click line numbers to comment):

-----  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;
/

Comments (0)

Please to add comments

No comments yet. Be the first to comment!