Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can't drop Procedure
On Sat, 29 Jun 2002 19:16:11 +0100, "Paul Brewer"
<paul_at_paul.brewers.org.uk> wrote:
>
>"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
>
>
8.1.5.0.0 (Yes, I know. Remote DBA-ing, my firm will maintain almost
whatever version customer have, though we are coercing them)
Regards
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Sun Jun 30 2002 - 15:35:23 CDT