Oracle / PLSQL: Enable all Triggers on a table

This Oracle tutorial explains how to enable all triggers on a table in Oracle with syntax and examples.

Description

You may have found that you have disabled all triggers on a table and you wish to enable the triggers again. You can do this with the ALTER TABLE statement.

Syntax

The syntax to enable all triggers on a table in Oracle/PLSQL is:

ALTER TABLE <strong>table_name</strong> ENABLE ALL TRIGGERS;

Parameters or Arguments

table_name

The name of the table that all triggers should be enabled on.

Note

• See also how to enable a trigger.
• See also how to disable a trigger on a table or disable all triggers on a table.

Example

Let's look at an example that shows how to enable all triggers on a table in Oracle.

For example:

ALTER TABLE orders ENABLE ALL TRIGGERS;

This example uses the ALTER TABLE statement to enable all triggers on the table called orders.