Re: Can't drop Procedure

"Md Irfan" <irfan_pk_at_hotmail.com> wrote in message news:c42168e7.0206282157.27c4a1cd_at_posting.google.com...
> Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message > >user is
"SCOTT"
>
> > Export/import didn't resolve it, so
> > I had to scratch the database. It was a mess anyway,
>
> No other way than this, do I have to do the same, and but all other
> things related to data dictionary works normally --

Think you have to find out whether you have an object of an unknown type in the affected schema.
If that's the case, AFAIK, there is no way to drop it using ordinary sql. The only other suggestion I can think of is to delete from obj$ directly, but I don't want to procedures like this. I didn't check on Metalink yet, and the issue didn't surface again.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address