Managing Triggers












The interactions in this eCourse require Javascript to be enabled.



 

Managing Triggers



previous|next







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.
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