Re: Deactivating DB-Triggers

From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1997/01/27
Message-ID: <5ci8um$4om@newton.pacific.net.sg>#1/1

jocke_at_abb.se (Jocke) wrote:
>Is it possible to deactivate
>triggers in the database ?
>
>Or do you have to delete the trigger and
>then create it again ?
>
>I'm runnig Oracle 7.1.6 and
>PL/SQL 2.1.6
>
>Thanks
>
>/Jocke
>
>
>

Hi there,

You can disable a database trigger by

alter trigger <triggername> disable;

This will not cause the trigger to fire. To enable the trigger, change disable to enable in the previous line.

Regards

N.Prabhakar Received on Mon Jan 27 1997 - 00:00:00 CST