From: "Guus van de Sande" <gs.dyntas@wxs.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: Mysterious "table or view does not exist" situation
Date: Sat, 9 Sep 2000 11:46:55 +0200
Organization: Planet Internet
Lines: 11
Message-ID: <8pd0v6$9fs00$1@reader4.wxs.nl>
References: <39B996A7.742B@iquest.net>
NNTP-Posting-Host: ipc37970e5.dial.wxs.nl
X-Trace: reader4.wxs.nl 968492838 9957376 195.121.112.229 (9 Sep 2000 09:47:18 GMT)
X-Complaints-To: abuse@wxs.nl
NNTP-Posting-Date: 9 Sep 2000 09:47:18 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600


Yes I have. The problem is the caused by the lower-case definition of the
table-name. You can select rows from it by using the exact table name
between 'quotes'. When you export a table from Access to Oracle, rename your
table first to uppercase. Then you would not experience the problem.

regards,
Guus van de Sande
NL