Re: help needed: dropping tables with unusual names

From: <romel_at_usa.net>
Date: Thu, 21 May 1998 14:59:47 +0800
Message-ID: <6k0jkg$ik03@news.skyinet.net>

Hi!

As Thomas Kyte and Naren Chintala said, use double quotes. As an additional option, you may want (if it is at all acceptable) to rename the table(s) to remove the quotes. For example:

    RENAME "Old Table Name" TO new_table_name;

You have to note, however, that some of the columns might also need to be referenced using the double quotes. If this is the case, you may also want to "rename" these columns using

    CREATE TABLE new_table_name
    AS
    SELECT

         "First Old Column Name" first_new_column_name
        ,"Second Old Column Name" second_new_column_name
         ...

    FROM "Old Table Name"
    ;

Having the users observe some standards in using table and column names (e.g., all caps, no spaces and other special characters except for the underscore) when exporting data from MS Access to Oracle might help prevent the same situation from happening again. Otherwise, you might have to periodically check Oracle's data dictionary for data with unusual table and column names.

I hope this helps.
Romel Tungol

Manuel Schueren wrote in message
<3562fda0.11032644_at_news.mpi-fg-koeln.mpg.de>...
>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 Thu May 21 1998 - 01:59:47 CDT