From: "Nascar" <nascar@flash.net>
Newsgroups: comp.databases.oracle.misc
References: <8pbs2j$uhj$1@nnrp1.deja.com>
Subject: Re: ODBC-exported table missing in SQL*Plus query
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.3018.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300
Message-ID: <xPsu5.802$oc3.77445@news.flash.net>
Date: Sat, 09 Sep 2000 15:38:05 GMT
NNTP-Posting-Host: 63.254.25.93
X-Complaints-To: abuse@flash.net
X-Trace: news.flash.net 968513885 63.254.25.93 (Sat, 09 Sep 2000 10:38:05 CDT)
NNTP-Posting-Date: Sat, 09 Sep 2000 10:38:05 CDT
Organization: FlashNet Communications, http://www.flash.net


when you query the table, put quotes (") around then name:
ie.  select * from "thatdaggonaccesstable"
To avoid this problem, create the table before hand in Oracle, then
import/insert the data into it.

<mvonhughes2@my-deja.com> wrote in message
news:8pbs2j$uhj$1@nnrp1.deja.com...
> 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.