Put the table in double quotes.

desc "MSAccessUsers"
or
desc <owner>."MSAccessUsers"





"Ramakrishna Devaraju "
<oracledba-ezmlmshield-x37534377.[Email address protected]
09/30/04 01:55 PM


To: "LazyDBA Discussion" <[Email address protected]
cc:
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.

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