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
/

"Oh judge! Your damn laws! The good people don’t need them, and the bad people don’t obey them” ~ Ammon Hennacy

Related Oracle 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