Re: Table Name in Lower Case

Re: Table Name in Lower Case

 

  

try

select * from "MSAccessUsers";

Mir M. Mirhashimali
Oracle Systems Manager
Web Services, Rice University
(713) 348-6365



Ramakrishna Devaraju wrote:

>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.
>
>Thanks in advance.
>
>RD
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>.
>
>
>

Oracle LazyDBA home page