Enabling and Disabling Triggers

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:

  1. From Enterprise View or a custom view, select a database.

  2. Right-click and select Edit, then Triggers.

  3. In the Database Triggers window, select a disabled trigger, and click Enable.

  To disable a trigger:

  1. From Enterprise View or a custom view, select a database.

  2. From the nodes below that database, double-click Triggers.

  3. In the Database Triggers window, select an enabled trigger and click Disable.

  4. 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.

Related Information

Related Commands

alter trigger (MaxL) in the Oracle Essbase Technical Reference