Re: Object refuses to drop

Two things to try...first prepend the object_name with its owner...second, issue the DROP command as someone who has the DROP ANY TYPE system privilege.

HTH,
Brian

Maximus wrote:
>
> database: Oracle9i Enterprise Edition Release 9.2.0.1.0
>
> I have been attempting to clean out a schema and there is an object that
> refuses to drop. If I issue "DROP TYPE ATTRIBUTE_TYP" the command fails
> with an ORA-04043, object does not exist. I've verified the object does
> indeed exist but any SQL to alter or drop it fails:
>
> SQL> CONNECT PROJECT/****@DB01.****.COM
> Connected.
> SQL> SELECT OWNER, OBJECT_NAME, OBJECT_TYPE
> 2 FROM ALL_OBJECTS WHERE OWNER='PROJECT';
>
> OWNER OBJECT_NAME OBJECT_TYPE
> ------------------------------ ------------------------------ --------------
> ----
> PROJECT ATTRIBUTE_TYP TYPE
>
> SQL> DROP TYPE ATTRIBUTE_TYP;
> DROP TYPE ATTRIBUTE_TYP
> *
> ERROR at line 1:
> ORA-04043: object ATTRIBUTE_TYP does not exist
>
> How the heck can I get rid of this object... go into sys.obj$ and delete it
> manually?

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"