On NT I have seen that when the screen saver comes on, some triggers fall
off the database.
... or if it is too hot in the server room :)))))
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:tralvd62jt8q68_at_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 Sat Sep 29 2001 - 02:10:19 CDT
