Re: Disappearing Triggers!

Yes but ...

Arielle , to get help, may be you could tell us what platform and oracle version you use ?

If I'm the only one on the news not to know your platform, sorry about the post

H/P

Arielle Smith a écrit :

> I posted a message recently about ORA-03113 errors and got some
> excellant advice (many thanks), but continuing to track the problem
> has uncovered some very bizarre happenings. Following a suggestion, I
> ran a count of my triggers and found over half of the 60+ missing. I
> ran a script to recreate them and thought I was out of the woods.
> Well, irony slapped me back down. While talking on the phone a couple
> hours later with a DBA explaining how we'd located the problem and how
> I could finally catch a decent night's sleep, the support phone starts
> ringing off the hook and, d*** the luck, another trigger had vanished
> and people were dropping connections whenever they tried to change
> data in the associated table. At that point, the only thing I could
> do was reboot since I couldn't recreate the trigger nor even analyze
> the table or index and even just shutting down and restarting Oracle
> had problems. This AM I checked again and yet another one was
> missing. This time, however, I was able to recreate the trigger
> without jumping through hoops, I believe because weekend users aren't
> likely to touch the associated table.
>
> Has anyone seen this before?? How on earth can I trap it to find out
> what's causing it besides turning on tracing for the whole DB? It is
> so random that I don't even have a clue when it will surface next. As
> an interesting and probably completely useless side note, it appears
> to be dropping them in alphabetical order....
>
> Thanks for any insight you can give.
Received on Sat Sep 07 2002 - 16:06:02 CDT