You simply need to enclose the tablename in double quotes, such as:

SELECT * from "MSAccessUsers"

-----Original Message-----
From: Ramakrishna Devaraju
Sent: Thursday, September 30, 2004 1:55 PM
To: LazyDBA Discussion
Subject: Table Name in Lower Case

Hello Everyone,

I came across with a very peculiar situation where there is a table called
'MSAccessUsers'. When get this name from dba_tables, I see the table and
any operation on this table telles me that the table or view does not
exist. I know in oracle all object names show in upper case. I can not
even use Create Table AS... When I try to use EOM to create like, it does
create but is not getting any rows from the original table, I guess.

How can I fix this? I am using 8.0.4.4.

Oracle LazyDBA home page