Re: mystery table

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Wed, 24 Nov 1999 23:13:27 +0100
Message-ID: <943481682.6988.0.pluto.d4ee154e@news.demon.nl>

select * from "Mystery_Table"

should resolve your mystery.
Always convert your Access table names to uppercase, ODBC doesn't do that for you. Of course the Oracle provided Access migration wizard knows how to deal with it.

Hth,

--
Sybrand Bakker, Oracle DBA
John Wang <wang_john_at_bah.com> wrote in message news: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:13:27 CST