From: ilaletin@usa.net (Igor Laletin) Newsgroups: comp.databases.oracle.server Subject: Re: Disappearing Triggers! Date: 9 Sep 2002 02:38:14 -0700 Organization: http://groups.google.com/ Lines: 32 Message-ID: References: <677227cc.0209071142.14576b10@posting.google.com> NNTP-Posting-Host: 210.50.30.4 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1031564294 11187 127.0.0.1 (9 Sep 2002 09:38:14 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 9 Sep 2002 09:38:14 GMT [...] > I contend that triggers (or other objects) do NOT spontaneously go "poof" > and disappear from an Oracle database. Not that we (TINW) doubt you, > please post your evidence that the triggers were present & are now gone. It's such an inperfect world :) Have a look at one of my favourite Oracle bugs - #1803203 "DROP USER REMOVES WRONG TRIGGER FROM DICTIONARY" " 1. Clear description of the problem encountered: . When you drop a user who's user# from user$ is the same as another user's table with an obj# that matches the user#, triggers on the table are removed from obj$ and trigger$." > FWIW - I AUDIT all DDL statements so I can at least identfy after the > fact who did what to whom & when. This level of AUDITing should not > significantly burden your DB or system. Sure. > > HTH & YMMV > > > > HAND! Cheers, Igor