Sometimes you might find that you are required to disable all of the triggers on a table. In Oracle you can disable all the triggers on a table using ALTER TRIGGER statement.
Oracle Disable all Trigger Syntax
Syntax
Where:
table_name: The table name that all triggers should be disabled on.
Oracle Disable all Trigger Example
To show how to disable all the trigger using the DISABLE ALL TRIGGERS statement, use the following syntax: