Re: Mixed Case table name

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Wed, 30 Aug 2000 15:01:23 -0700
Message-ID: <8ok03t$as$1@spiney.sierra.com>

SQL> create table "MyAccessTable" (test varchar2(10));

Table created.

SQL> rename "MyAccessTable" to myaccesstable;

Table renamed.

SQL> <eoin7_at_my-deja.com> wrote in message news:8oj62h$e75$1_at_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 - 17:01:23 CDT