Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table DNE.. but it does!
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