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;

Narayanaswamy

Hello! I am Narayanaswamy founder and admin of narayanatutorial.com. I have been working in the IT industry for more than 12 years. NarayanaTutorial is my web technologies blog. My specialties are Java / J2EE, Spring, Hibernate, Struts, Webservices, PHP, Oracle, MySQL, SQLServer, Web Hosting, Website Development, and IAM(ForgeRock) Specialist

I am a self-learner and passionate about training and writing. I am always trying my best to share my knowledge through my blog.