Re: Maximum length of table and column names

Jens Riedel wrote:

> Hello,
>
> I'm trying to port an application from a mySQL database to Oracle 9.
> I have problems to create some tables because the table or column names
> seem to be too long.
> I found the following:
>
> ----------------------
> ORA-00972: identifier is too long
>
> Cause: The name of a schema object exceeds 30 characters. Schema objects
> are tables, clusters, views, indexes, synonyms, tablespaces, and usernames.
>
> Action: Shorten the name to 30 characters or less.
> ------------------------
>
> My question: is a column name also limited to 30 characters and is there
> a possibility to change these settings instead of shortening the table
> and column names?
>
> Thanks and regards,
> Jens

If you have made it this far without knowing the most elementary of basics you are a danger to society. ;-)

Learn the Oracle catalog views such as DBA_TABLES, ALL_TABLES, USER_TABLES, ..._VIEW, ... _SEQUENCES, etc.

Do a describe on them:

SQL> desc all_tables

What you see is what you get. You can't stuff more than 30 characters into a 30 character column.

I strongly urge you to stop coding and start reading. There is a huge amount of material you need to master before you put fingers to keyboard again.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)