Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Cannot drop table (table created by MS-Access)

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

From: Patrick Joyal <please.reply_at_to.the.newsgroup>
Date: Wed, 16 Aug 2000 17:53:17 GMT
Message-ID: <399ae05f@news>

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 - 12:53:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US