Re: mystery table

From: Terry Dykstra <tdykstra_at_cfol.ab.ca>
Date: Wed, 24 Nov 1999 15:14:07 -0700
Message-ID: <383c6354_4@news.cadvision.com>

Have you tried enclosing the tablename in quotes, using the exact upper/lowercase spelling?

--
Terry Dykstra
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

John Wang wrote in message <81hnh4$am$1_at_autumn.news.rcn.net>...
>Hi, All:
>
> One guy dumped 2 tables from access into an Oracle database. But for
>some reason, when I do select or desc in sql plus, it keeps saying the
table
>or object does not exist. When I do analyze, the stats are updated. when
I
>do a select from user_tables, the table does appear, but it has upper and
>lower cases. Usually, everything is in upper case. That is strange. I am
>wondering if anyone has seen the problem before. I am using 8i on NT.
>
>Thanks
>
>jw
>
>
Received on Wed Nov 24 1999 - 16:14:07 CST