Re: Disappearing Triggers!

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 9 Sep 2002 16:59:22 +0100
Message-ID: <alighr$ib1$1$8300dec7@news.demon.co.uk>

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$."

>

Received on Mon Sep 09 2002 - 10:59:22 CDT