Newsgroups: comp.databases.oracle
Subject: Re: Help!! Object does not exist
References: <31F8EA23.763F@worldnet.att.net> <4tam8a$12g0@watnews1.watson.ibm.com>
mlanda@vnet.ibm.com writes:
>In <31F8EA23.763F@worldnet.att.net>, Joe Brouillette writes:
>>I am stumped.
>>
>>A developer used a MS/Access internal procedure to generate a temporary
>>table and now we cannot remove the table from the database.
>>
>>when logged on as the user and query user_tables The table is listed, but
>>when we try to drop the table Oracle states that the object does not
>>exist.
>>
>>I have logged on as sys and the owner & table is present in the
>>dba_tables view, but I cannot drop the table as sys either, I also
>>receive the same message of the Object does not exist.
>>
>>Thanks for your assistance.
>Does the table's name have mixed or lower case letters? If so, you will have
>to reference it by surrounding it with quotes. For example:
> drop table Temp_Table; -- will not work
> drop table "Temp_Table"; -- will work
>M.Landa
M.Landa and Joe,
There is a good chance that specifying the table in quotes for lower-case
will work. If, however, it doesn't, there are two things to check:
1) Make sure that you are logged in as the user. When you were logged in as
SYS and tried to drop another user's table, it failed. Try:
DROP TABLE username.TABLENAME;
2) The object might be a view and not a table. Try:
DROP VIEW username.VIEWNAME;
Hope this helps!
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> Visit my Web Page: www.arikaplan.com <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page