How to Disable and Enable triggers in oracle

In this post, we are discussing on how to enable, disable and drop triggers in oracle.

 

Enable ONE Trigger in a table

Syntax

ALTER TRIGGER <trigger-name> ENABLE;

Example

ALTER TRIGGER NarayanaTutorial_Trigger ENABLE;

 

Enable ALL Triggers in a table

Syntax

ALTER TABLE <table-name> ENABLE ALL TRIGGERS;

Example

ALTER TABLE NarayanaTutorial_TABLE ENABLE ALL TRIGGERS;

 

 

Disable Trigger in a table

Syntax

ALTER TRIGGER <trigger-name> DISABLE;

Example

ALTER TRIGGER NarayanaTutorialTrigger DISABLE;

 

Disable ALL Triggers in a table

Syntax

ALTER TABLE <table-name> DISABLE ALL TRIGGERS;

Example

ALTER TABLE NarayanaTutorial_TABLE DISABLE ALL TRIGGERS;

DROP Trigger

Syntax

DROP TRIGGER <trigger-name>;

Example

DROP TRIGGER NarayanaTutorial_Trigger;