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

yeee, you have got the answer alredy.
when you make a table using Access,
that sends a query to DBMS with double quoation marked table name and column name.
actually, the used words by oracle ( reserved words) can't be used for table name and column name.
but we can use those words and small character by using double quoation mark.

when you made that table, it was created with small character. but when you queryed data dictionary, it showed up with Capital. so you have to find the exact table's name.

Have a good day... :))

Knut Reimers <reimers_at_faw.uni-ulm.de>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦ 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 - 19:43:05 CDT