This Oracle tutorial explains how to enable all triggers on a table in Oracle with syntax and examples.
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.
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.
See also how to enable a trigger. See additionally how to disable a trigger on a table or disable all triggers on a table.
Let’s appear at an example that indicates how to enable all triggers on a desk in Oracle.
ALTER TABLE orders ENABLE ALL TRIGGERS;
This example uses the ALTER TABLE assertion to enable all triggers on the table called orders.