Oracle/PLSQL: Enable a Trigger
The syntax for a enabling a Trigger is:
ALTER TRIGGER trigger_name ENABLE;
For example:
If you had a trigger called orders_before_insert, you could enable it with the following command:
ALTER TRIGGER orders_before_insert ENABLE;