How to Disable All Triggers in Oracle
Oracle triggers execute after you insert a table record, edit data or delete a table row. Triggers are linked to tables, and you must disable all triggers to troubleshoot programming and software issues on the database. Oracle includes a statement that lets you disable all triggers on the table without the need to delete or edit the triggers' code. This lets you troubleshoot issues and re-enable the triggers when you want to return the table to its previous status.
Other People Are Reading
Instructions
-
-
1
Open the Oracle Enterprise Manager software on your database server. Log in to the database using your username and password.
-
2
Open the PL/SQL editor. Copy and paste the following code to the editor:
ALTER TABLE table_name DISABLE ALL TRIGGERS;
Replace "table_name" with the name of the table to you want to edit.
-
-
3
Click the "Execute" button to run the code. Oracle returns a message to let you know that the command was successful.
-
1
