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

Probably a Case-sensitive issue.

Try
Drop Table "TableName";

get the EXACT name from USER_TABLES.

"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 Wed Aug 16 2000 - 11:37:42 CDT