Re: unvisible tables

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
Received on Thu Apr 20 2000 - 00:00:00 CDT