From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.server Subject: Re: Disappearing Triggers! Date: Mon, 9 Sep 2002 16:59:22 +0100 Lines: 47 Message-ID: References: <677227cc.0209071142.14576b10@posting.google.com> NNTP-Posting-Host: jlcomp.demon.co.uk X-Trace: news.demon.co.uk 1031587195 18785 158.152.75.41 (9 Sep 2002 15:59:55 GMT) X-Complaints-To: abuse@demon.net NNTP-Posting-Date: Mon, 9 Sep 2002 15:59:55 +0000 (UTC) X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 X-Newsreader: Microsoft Outlook Express 4.72.3110.5 Thank you for that - it's going into my hall of fame (infamy) too. I see that it's fixed in 9.(0.)2 -- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) ____England______September 24/26, November 12/14 ____USA__________November 7/9 (MI), 19/21 (TX) The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Igor Laletin wrote in message ... >[...] > > >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$." >