Disabling Triggers

You can temporarily disable a trigger. You might want to do this if:

An object it references is not available.
You need to perform a large data load, and you want it to proceed quickly without firing triggers.
You are reloading data.

By default, triggers are enabled when first created. Disable a specific trigger using the ALTER TRIGGER statement with the DISABLE option as shown in Example: Disabling a Specific Trigger.

Disabling a Specific Trigger

ALTER TRIGGER log_emp_update DISABLE;

All triggers associated with a table can be disabled with one statement using the ALTER TABLE statement with the DISABLE clause and the ALL TRIGGERS option. Example: Disabling All Triggers on a Table shows how to disable all triggers defined for the departments table.

Disabling All Triggers on a Table

ALTER TABLE departments DISABLE ALL TRIGGERS;