Re: Table DNE.. but it does!

Thanks. That got it. I didn't realize Oracle converted everything to upper case like that... *sigh*

In article <aunb5ts9ndacpt61ivphcfp3m59etcjlhe_at_4ax.com>,   See Message body for real address wrote:
>
> Not to re-state the obvious but are you sure you are referencing the
 table by
> its complete, formal name; and as a quoted string since it is in lower
 case..
>
> Like this:
>
> drop table 'schemaname.tablename';
>
> ( BTW, how did you get a lower-case table name from SqlPlus - did you
 use quoted
> strings for the table_name---why? )
>
> 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...
> >> <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/
>
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 05 2001 - 12:53:21 CST