Re: Can't drop Procedure

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sat, 29 Jun 2002 19:16:11 +0100
Message-ID: <3d1f46c6_1@mk-nntp-1.news.uk.worldonline.com>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:snahhustu7t9iap7fc4vp5na2jbhtnbvo6_at_4ax.com...
> Had a similar issue a few weeks ago.
> Was forced to rebuild the database because of corrupt datadictionary.
> I came to this decision because I got a 4043 on the table DUAL (Yuck!)
> and RMAN is fully relying on it.
> Verifying the datadictionary directly,
> (select * from obj$ where name = 'DUAL')
> I got three records back. The table, the public synonym, and a record
> of type 'UNDEFINED' owned by my user.

Sybrand,

That's pretty nasty. Out of interest, what version was that?

TIA,
Paul Received on Sat Jun 29 2002 - 13:16:11 CDT