How to Disable Trigger in Oracle SQL Developer?

How to Disable Trigger in Oracle SQL Developer?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

In Oracle SQL Developer, you can disable a single trigger for a table or all the triggers for a table. Follow these steps.

Disable a Trigger in Oracle SQL Developer

  1. Open Oracle SQL Developer and connect to the database.
  2. On the left side, in connections panel expand the table node and select the table for which you want to disable the trigger.
  3. Do right click on that table and from the shortcut menu select Trigger > Disable Single.
  4. A window will open as shown in below image then select the trigger from the trigger drop-down menu and click on the Apply button.

Disable a trigger in Oracle SQL Developer

To Disable all the triggers for a table, in the third step select Trigger > Disable All option.

See also: