ODBC-exported table missing in SQL*Plus query

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 Fri Sep 08 2000 - 18:17:55 CDT