Re: HELP! Invalid Table name...

From: Rob Spies <rspies_at_minn.net>
Date: 1997/08/23
Message-ID: <33fef5ea.0@steggy.minn.net>#1/1

Try putting double quotes around the table name.

drop table "__FRATE";

Chin Chieh Tan <tan_at_sess10.tatung.com.tw> wrote:

>Hi,
> I used MS Access to export a table into Oracle database. This table
>named
>1_FRATE. But Oracle automatically created a table named __FRATE.
>Now I can not select data from this table, but I can look it in data
>dictionary.
>How can I drop this table?
>Could anybody help me? Thanks!

>--
>**********************************************************************
>Jerry Tan
>Systems Engineer Voice: (02) 598-4502
>Information Systems Business Division
>Tatung Co. Fax: (02) 598-4467
>22 ChungShan N. Rd., Sec 3
>Taipei Taiwan 104 ROC Email: tan_at_sess10.tatung.com.tw
>**********************************************************************
Received on Sat Aug 23 1997 - 00:00:00 CDT