Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Mysterious "table or view does not exist" situation

Mysterious "table or view does not exist" situation

From: Michael Hughes <mhughes_at_iquest.net>
Date: Fri, 08 Sep 2000 20:47:19 +0000
Message-ID: <39B996A7.742B@iquest.net>

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!

Received on Fri Sep 08 2000 - 15:47:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US