Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Trigger Trouble

Re: Trigger Trouble

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 29 Sep 2001 05:56:16 +0200
Message-ID: <tralvd62jt8q68@news.demon.nl>

"James Chappell" <james_at_rees-chappell.demon.co.uk> wrote in message news:pGKlwJATnPt7Ewpx_at_rees-chappell.demon.co.uk...
> I had a trigger running no probs for three or four weeks. Last night, it
> was reported as not working. When I checked, it had "disappeared"!!
> Fortunately, I was able to recreate the trigger.
>
> Does anyone know of any circumstances where a database trigger, under
> Oracle 8.0.6 on an NT box, would just vanish?
>
> --
> James Chappell

By deliberating dropping it, or by restoring data. Any other methods, like you seem to imply, are just superstition.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Fri Sep 28 2001 - 22:56:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US