Oracle SQL: the Essential Reference

ALTER TRIGGER

ALTER TRIGGER [schema.]triggername {ENABLE | DISABLE}

Enables or disables a database trigger.

Keywords

schema

The name of the schema containing the trigger. If omitted, the current schema is assumed.

triggername

Specifies the name of the trigger to alter.

ENABLE

Specifies that this trigger is to be fired when a triggering statement is issued.

DISABLE

Specifies that this trigger is not to be fired when a triggering statement is issued.

Unlike other ALTER commands, the ALTER TRIGGER statement does not change the definition or structure of a trigger; this change must be done with a CREATE OR REPLACE TRIGGER statement. A trigger is automatically enabled when it is created. The ENABLE ALL TRIGGERS and DISABLE ALL TRIGGERS clauses of the ALTER TABLE statement may also perform this function.

Example

The following statement disables the scott user's empaud trigger:

ALTER TRIGGER scott.empaud DISABLE