Object refuses to drop

From: Maximus <qweqwe_at_qwqwewq.com>
Date: Wed, 13 Aug 2003 19:02:34 GMT
Message-ID: <eXv_a.718069$3C2.16827675@news3.calgary.shaw.ca>

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? Received on Wed Aug 13 2003 - 14:02:34 CDT