Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Mixed Case table name
I had the same problem, usimng MS access
You can also try
drop table "TableName";
In article <8oj62h$e75$1_at_nnrp1.deja.com>,
eoin7_at_my-deja.com wrote:
> Using Oracle 8.1.6 on NT:
>
> I created a table in Oracle from a table in MS Access using an ODBC
> connection. The table name is mixed case.
> When I log on to Oracle through SQL Plus, I cannot see the table.
> DESCRIBE does not work, DROP does not work (table does not exist), yet
> it's listed in the user_tables dictionary table.
>
> Luckily, I have DBA Studio, the new graphical DBA tool, and using this
> I was able to delete the table.
>
> What's the deal?
> Why does Oracle allow a mixed case table name yet can't let you do
> anything with it?
>
> Thanks
> Eoin
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Aug 30 2000 - 11:43:19 CDT