You can enable a trigger that is disabled or disable a trigger that is enabled. Triggers are enabled by default when they are created.
You can also disable all triggers for the duration of the application session.
To enable a trigger:
From Enterprise View or a custom view, select a database.
Right-click and select Edit, then Triggers.
In the Database Triggers window, select a disabled trigger, and click Enable.
To disable a trigger:
From Enterprise View or a custom view, select a database.
From the nodes below that database, double-click Triggers.
In the Database Triggers window, select an enabled trigger and click Disable.
Optional: To disable all triggers for the duration of the current database session, click Suspend All.
Note: | When the application is closed, triggers revert to the state (enabled or disabled) that they were in before you clicked Suspend All. |
“Monitoring Data Changes Using Triggers” in the Oracle Essbase Database Administrator's Guide
alter trigger (MaxL) in the Oracle Essbase Technical Reference