Managing Triggers

A trigger has two states or modes: ENABLED and DISABLED. When a trigger is first created, it is enabled by default.

Syntax for disabling a database trigger

ALTER   TRIGGER trigger_name DISABLE

Syntax for disabling all triggers for a table

ALTER   TABLE table_name DISABLE ALL TRIGGERS

Syntax for recompiling a trigger for a table

ALTER  TRIGGER trigger_name COMPILE