Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Trigger Trouble
"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