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

Yong wrote:

> 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... :))

Hi Yong,

thank you for your answer.
The key was the double quotation mark. I tested it and now I'm happy and have a very good day. :-))

    Knut

Hi Patrick,

the answer to your question (How to create tables for Oracle by MS-Access.) is given by TurkBear.

    Knut

> > 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 - 03:11:37 CDT