Re: Table DNE.. but it does!

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...
> <salmon321_at_my-deja.com> wrote in message
 news:9320ps$929$1_at_nnrp1.deja.com...
> > As a user, I ran a script that created a number of tables and packages.
> > There was a minor error on one of the packages (I didn't have the proper
> > Oracle packages installed), and it said table created for each of the
> > tables.
> >
> > Well, when I try to do a select * from {table}, I get a 'table or view
> > does not exist error'... but the tables are listed in all places I
> > looked in the data dictionary, with the user that created them as the
> > owner. But when I try to re-create them, I get 'table already exists'
> > errors. And I can't drop them, because I get the DNE message.
> >
> > Doing these queries with SYS results in the same behaviour. How can I
> > fix these up? What caused it in the first place?
> >
> > Thanks!
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 05 2001 - 06:01:59 CST