From: "Howard J. Rogers" Newsgroups: comp.databases.oracle.server References: <39B996A7.742B@iquest.net> Subject: Re: Mysterious "table or view does not exist" situation Lines: 59 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Original-NNTP-Posting-Host: 203.134.37.51 Message-ID: <39b9d594@news.iprimus.com.au> X-Original-Trace: 9 Sep 2000 17:15:48 +1100, 203.134.37.51 Date: Sat, 9 Sep 2000 17:17:03 +1000 NNTP-Posting-Host: 203.134.64.67 X-Trace: news0.optus.net.au 968480149 203.134.64.67 (Sat, 09 Sep 2000 17:15:49 EST) NNTP-Posting-Date: Sat, 09 Sep 2000 17:15:49 EST Organization: Another Optus Customer 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" wrote in message news: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! > > -- Michael