Re: Object refuses to drop

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?

Anyone that would even suggest going into sys.<anything> and making a change should
have their keyboard taken away. I am staggered by the implications.

When you attempt to drop it are you logged on as project?

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)