ALTER TRIGGER

Change the properties of a trigger.

Syntax:

   ALTER TRIGGER [schema.]trigger ENABLE 

   ALTER TRIGGER [schema.]trigger DISABLE

   ALTER TRIGGER [schema.]trigger RENAME TO new_name

   ALTER TRIGGER [schema.]trigger COMPILE [DEBUG] [REUSE SETTINGS]

An alternative to ALTER TRIGGER COMPILE is the built-in pl/sql package DBMS_UTILITY

Example

Alter trigger ss64.trig_staff_details DISABLE
/
UPDATE table ss64.staff_details SET zip_code =2468 where zip_code =2467
/
Alter trigger ss64.trig_staff_details ENABLE
/

"Good people do not need laws to tell them to act responsibly, while bad people will find a way around the laws." - Plato

Related Commands:

CREATE TRIGGER
DROP TRIGGER
ALTER TABLE

Related Views:

 DBA_SOURCE             ALL_SOURCE             USER_SOURCE 
 DBA_TRIGGERS           ALL_TRIGGERS           USER_TRIGGERS 
 DBA_TRIGGER_COLS       ALL_TRIGGER_COLS       USER_TRIGGER_COLS
 DBA_INTERNAL_TRIGGERS  ALL_INTERNAL_TRIGGERS  USER_INTERNAL_TRIGGERS