Re: help needed: dropping tables with unusual names

The answers you are getting point to the right place - the use of " around the name....

This is a major problem when moving a table from Access to Oracle - It is strange, but the UpSizing wizard in VisualFoxPro 5.0 correctly changes the table name to upper case when moving to Oracle - since Microsoft writes them both, perhaps a future Access will do it as well....

schueren_at_mpi-fg-koeln.mpg.de (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 - 15:24:56 CDT