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: Table DNE.. but it does!

Re: Table DNE.. but it does!

From: Jining Han <hanj_at_mailcity.com>
Date: Fri, 05 Jan 2001 14:33:35 GMT
Message-ID: <934lvv$hbn$1@nnrp1.deja.com>

In article <934d3l$ad8$1_at_nnrp1.deja.com>,   salmon321_at_my-deja.com wrote:
> No, I used SQL*Plus to run the script, not ODBC. The table names are
> lower case, but that's the way they were written, and been used
> successfully in the same environment elsewhere.
>
> In article <Aqc56.124320$x6.57049959_at_news2.rdc2.tx.home.com>,
> "Greg Kainz" <gregkainz_at_home.com> wrote:
> > You didn't create these tables using ODBC by chance? ODBC can force
> > a table name to be entered in the data dictionary as lower case...

So you did try to put quotes around the table names when you tried to reference them? (e.g. drop table "nasty_table")

--
Jining Han
Sallie Mae


Sent via Deja.com
http://www.deja.com/
Received on Fri Jan 05 2001 - 08:33:35 CST

Original text of this message

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