Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Mysterious "table or view does not exist" situation

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

From: Guus van de Sande <gs.dyntas_at_wxs.nl>
Date: Sat, 9 Sep 2000 11:46:55 +0200
Message-ID: <8pd0v6$9fs00$1@reader4.wxs.nl>

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 Received on Sat Sep 09 2000 - 04:46:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US