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;

 

 

The Author

Narayanaswamy

Hello! I am Narayanaswamy founder and admin of narayanatutorial.com. I have been working in IT industry more than 7 years. NarayanaTutorial is my web technologies blog. My specialties are Java / J2EE, Spring, Hibernate, Struts, Webservices, PHP, Oracle, MySQL, SQLServer, Web Hosting and Website Development. I am a self learner and passionate about training and writing. I am always trying my best to share my knowledge through my blog.

Leave a Reply