Re: Mysterious "table or view does not exist" situation

Hi Michael,

Welcome to the world of case-sensitivity when exporting out of things like Access (and, so it would appear, SQL Server). Try 'select * from 'tablename' ' -in other words, enclose your table name within quotes, and it should get treated as a literal string and find an appropriate match.

This sort of behaviour is a standard one in Oracle when dealing with things created elsewhere (Oracle is not case sensitive with tables created within Oracle itself).

Last time I exported stuff out of Access, I went through the somewhat tedious process of uppercasing all my tables and columns before hitting the Export option. Worked a treat.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



"Michael Hughes" <mhughes_at_iquest.net> wrote in message
news:39B996A7.742B_at_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!

>

> -- Michael