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

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sat, 9 Sep 2000 22:24:53 +1000
Message-ID: <39ba1dba@news.iprimus.com.au>

I'd just add that column names can also be a problem, and you'd be best off uppercasing them too.

Just a thought
HJR

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



"Guus van de Sande" <gs.dyntas_at_wxs.nl> wrote in message
news:8pd0v6$9fs00$1_at_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 - 07:24:53 CDT