Re: Cannot drop table (table created by MS-Access)

In article <399AC618.F2402AF9_at_faw.uni-ulm.de>,   Knut Reimers <reimers_at_faw.uni-ulm.de> wrote:

> I cannot drop a table which I created by MS-Access :-( (I know, I
> shouldn't have tried it, but I wanted to test it nevertheless.).
> I think the problem is, that the table has large and small characters
 in
> his name.

I asked a similar question here a few weeks and the answer I got worked for me. Put the table name in double quotes, e.g. DROP TABLE "Mixed Case Name";

If that doesn't work, make sure you're the owner. Just because you have permission to see it (which I believe is what all_tables shows you) you may not have permission to drop it - it might belong to someone else. Does it show up in user_tables, i.e. SELECT TABLE_NAME FROM USER_TABLES;

--
Jim Lyons                     |  Network Systems Analyst
Entertech - The IC2 Institute |  512-482-0273, ext. 269
University of Texas at Austin |  jlyons_at_weblyons.com
http://www.weblyons.com


Sent via Deja.com http://www.deja.com/
Before you buy.