Re: help needed: dropping tables with unusual names

Double quote the table name.

ex. drop table "Table_for_important_Information_concerning_Whatever";

HTH Manuel Schueren wrote:
>
> Hi!
> I have a problem. Some users exported tables fom MS Access to ORACLE7.
> They used tablenames they've given to the tables in Access, "Table for
> important Information concerning Whatever" for example.
> Now when they select the table_names from the user_catalog, they see
> the table like this:
> "Table_for_important_Information_concerning_Whatever".
> But trying to use any kind of statement on the table, ORACLE answers
> with "table or view does not exist".
> It is also impossible to drop this crap! Is there a wy to handle this
> problem?
> Thanks in advance,
>
> Manuel Schueren
>
> Max-Planck-Institut fuer Gesellschaftsforschung
> Cologne, Germany
>
> ms_at_mpi-fg-koeln.mpg.de
Received on Wed May 20 1998 - 13:58:49 CDT