Re: mystery table

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sat, 27 Nov 1999 03:45:06 GMT
Message-ID: <3856539c.70402287@netnews.worldnet.att.net>

On Wed, 24 Nov 1999 17:06:14 -0500, "John Wang" <wang_john_at_bah.com> wrote:

> One guy dumped 2 tables from access into an Oracle database. But for
>some reason, when I do select or desc in sql plus, it keeps saying the table
>or object does not exist. When I do analyze, the stats are updated. when I
>do a select from user_tables, the table does appear, but it has upper and
>lower cases. Usually, everything is in upper case. That is strange. I am
>wondering if anyone has seen the problem before. I am using 8i on NT.

If the table is mixed case, you sohuld be able to select and describe it by quoting the name. For example:

	select * from "MixEDCaseName";
	describe "MixEDCaseName"

regards,

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Fri Nov 26 1999 - 21:45:06 CST