Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Mysterious "table or view does not exist" situation
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!
![]() |
![]() |