Mixed Case table name

From: <eoin7_at_my-deja.com>
Date: Wed, 30 Aug 2000 14:35:00 GMT
Message-ID: <8oj62h$e75$1@nnrp1.deja.com>

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. Received on Wed Aug 30 2000 - 09:35:00 CDT