Table Name in Lower Case

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


Oracle LazyDBA home page