|
A trigger has two states or modes: ENABLED
and DISABLED. When a trigger is first created, it is enabled by
default. The Oracle server checks integrity constraints for enabled triggers
and guarantees that triggers cannot compromise them.
ALTER TRIGGER trigger_name DISABLE |
ALTER TABLE table_name DISABLE ALL TRIGGERS |
ALTER TRIGGER trigger_name COMPILE |
|