Re: Deactivating DB-Triggers

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1997/01/29
Message-ID: <32EF6640.1051@qrcsun.qrc.org>#1/1

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
ALTER TRIGGER xxx DISABLE;

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

Received on Wed Jan 29 1997 - 00:00:00 CST