Re: Deactivating DB-Triggers

From: Andreas Polke <APolke_at_compuserve.com>
Date: 1997/01/28
Message-ID: <01bc0ceb$311e52d0$a0ec1fc2@pc520>#1/1

Jocke <jocke_at_abb.se> wrote in article <5chiug$ock_at_sdaw04.seinf.abb.se>...
> 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

To disable a Trigger:	ALTER TRIGGER schema.triggername DISABLE
To enable a Trigger:	ALTER TRIGGER schema.triggername ENABLE

Andreas Polke
eMail: APolke_at_compuserve.com
ADtranz Signal GmbH
Germany Received on Tue Jan 28 1997 - 00:00:00 CST