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

I'm not Knut, but you can
export an Access table to Oracle using ODBC...Note the case issue however....

"Patrick Joyal" <please.reply_at_to.the.newsgroup> wrote:

>You can create tables using Access? How ?
>
>Knut Reimers wrote in message <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 - 14:48:14 CDT