Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Object refuses to drop
"Maximus" <qweqwe_at_qwqwewq.com> wrote in message news:<eXv_a.718069$3C2.16827675_at_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?
I'm wondering if there is some hidden character in the object name. Try adding the same name - if you can, you should see two entries in all_objects. If your system file is on unix, run it through od -c and grep for the name, compare the two entries. Then you will know what strange thing to put in quotes to drop.
jg
-- @home.com is bogus. "When your consciousness has been invaded, you can repel the invader, but it takes effort on your part." - Todd GitlinReceived on Wed Aug 13 2003 - 17:17:33 CDT
![]() |
![]() |