Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table DNE.. but it does!
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/
Received on Fri Jan 05 2001 - 08:55:30 CST