Re: Cannot drop table (table created by MS-Access)

From: Mike Dwyer <dwyermj_at_co>
Date: Thu, 17 Aug 2000 09:58:44 -0600
Message-ID: <X1Um5.11$0z3.150@wdc-read-01.qwest.net>

Try select owner, table_name from all_tab_columns (or all_tables). You may need to name the table's owner in the drop table statement.

"Knut Reimers" <reimers_at_faw.uni-ulm.de> wrote in message news:399AC618.F2402AF9_at_faw.uni-ulm.de...
> Hi,
>
> I have a little problem.
> I cannot drop a table which I created by MS-Access :-( (I know, I
> shouldn't have tried it, but I wanted to test it nevertheless.).
> I think the problem is, that the table has large and small characters in
> his name. (I see it in the 'all_tab_columns'-table_name-row.)
> But if I type _drop table XxX_ in the SQLPlus-Window. I get the error
> message 'Cannot find table or view'.
> I also tested to type the tablename in single quotation mark, but then
> the message is 'illegal tablename'.
>
> Can anyone help me?
>
> Thanks for the answers
> Knut R.
>
>
>
>
Received on Thu Aug 17 2000 - 10:58:44 CDT