Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Object refuses to drop

Re: Object refuses to drop

From: Joel Garry <joel-garry_at_home.com>
Date: 13 Aug 2003 15:17:33 -0700
Message-ID: <91884734.0308131417.6cab55c0@posting.google.com>


"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 Gitlin
Received on Wed Aug 13 2003 - 17:17:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US