Using Enable all Triggers on a table in Oracle

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

Description

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

Syntax

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

ALTER TABLE table_name ENABLE ALL TRIGGERS;

Parameters or Arguments

table_name The title of the desk that all triggers must be enabled on.

Note

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

Example

Let’s appear at an example that indicates how to enable all triggers on a desk in Oracle.

For example:

ALTER TABLE orders ENABLE ALL TRIGGERS;

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