Re: Tablenames in lower case letters

From: Romel M. Tungol <romeltungol_at_usa.net>
Date: 1998/05/26
Message-ID: <6kdrb9$rmm37@news.skyinet.net>#1/1

Hi!

Here's my reply to a similar question recently posted in comp.databases.oracle server...

Romel Tungol

---

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

---

buecken wrote in message <3569F970.26E6_at_kepler.fal.de>...
>Hallo,
>
>does somebody know a way to drop tables written in lower case letters
>from an oracle database! We copied data tables written in lower case
>letters via ODBC from a Access database to an older oracle server. This
>works fine but now is not possible to select data from this "lower case"
>tables.
>
>Thank you in advance
>
>Stefan
Received on Tue May 26 1998 - 00:00:00 CDT