Re: ODBC-exported table missing in SQL*Plus query

when you query the table, put quotes (") around then name: ie. select * from "thatdaggonaccesstable" To avoid this problem, create the table before hand in Oracle, then import/insert the data into it.

<mvonhughes2_at_my-deja.com> wrote in message news:8pbs2j$uhj$1_at_nnrp1.deja.com...
> I exported a table from MS-Access 97 on my laptop
> (Win98) to an Oracle 8 server on Solaris via the
> Oracle ODBC driver, which seemed to work fine,
> but when I perform a query in SQL*Plus on that
> table, Oracle returns the "ORA-00942: table or
> view does not exist" error.
>
> The irritating part is that I can do a:
>
> select table_name from user_tables;
>
> from SQL*Plus on the Solaris box and the table
> name is in the result set! (albeit in lower case
> letters, while the tables I've created via a
> CREATE TABLE statement directly on the Solaris
> machine appear in CAPS)
>
> I've also done a:
>
> SELECT object_name, object_type FROM user_objects;
>
> which returns the proper table name and
> object_type as TABLE.
>
> Anyone ever seen this before?
>
> Many thanks in advance!
>
> -- Michael
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Sep 09 2000 - 10:38:05 CDT