Re: unvisible tables

Sybrand Bakker wrote:
>
> try
> select * from "T_TEST"
>
> Are you sure the underscore is an underscore and no other character.
> The ODBC driver will not uppercase the table name, which also forces you to
> use "" at the Oracle side.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Reinhard Schlager <reinhard.schlager_at_jk.uni-linz.ac.at> schreef in
> berichtnieuws 38FF3DEB.77FA7B09_at_jk.uni-linz.ac.at...
> > Hello !
> >
> > I tried to export a MS-ACCESS table via ODBC to a ORACLE 8i DB (on
> > windows nt 4.0 SP5)
> > say T_TEST, with about 1000 Records.
> >
> > Everthing looked fine, with
> >
> > select * from user_tables there is a entry
> > T_TEST ....
> >
> > but if i try :
> >
> > Select * from T_TEST;
> >
> > i am told that there is no table T_TEST !!?
> >
> > I used the same user for exporting via ODBC and SQLPlus
> >
> > So - can anybody imagine whats going on here ?
> >
> > Thank you very much for your help !
> >
> > \Reinhard

Thank you very much !

It works fine now with

Select * from "T_Test"

Thank you Sybrand !!

\Reinhard Received on Sat Apr 22 2000 - 00:00:00 CDT