This Oracle tutorial explains how to disable all triggers on a table in Oracle with syntax and examples.
Once you have created Triggers in Oracle, you might find that you are required to disable all of the triggers on a table.. You can do this with the ALTER TRIGGER statement.
The syntax for a disabling all Triggers on a table in Oracle/PLSQL is:
ALTER TABLE table_name DISABLE ALL TRIGGERS;
Parameters or Arguments
- The name of the table that all triggers should be disabled on.
Let's look at an example that shows how to disable all triggers on a table in Oracle.
ALTER TABLE orders DISABLE ALL TRIGGERS;
This example uses the ALTER TRIGGER statement to disable all triggers on the table called orders.