Re: Tablenames in lower case letters

whoaaa! so sorry for the repeated messages - my ISP is in a mess right now...

Romel

Romel M. Tungol wrote in message <6kdpc7$rmm34_at_news.skyinet.net>...
>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 - 22:39:20 CDT