Re: Maximum length of table and column names

From: Hans Forbrich <news.hans_at_telus.net>
Date: Fri, 01 Oct 2004 14:10:05 GMT
Message-ID: <1zd7d.6456$223.4217@edtnps89>

Jens Riedel wrote:

>
> 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?
>

All Table, View and Clumn identifiers, as well as many others, are limited to 30 characters.

For all limitations, go to http://docs.oracle.com and search out the 'Oracle Reference Manual' (also known as 'Reference Manual', but not 'SQL Reference') and look in the limits chapter.

You are hitting the tip of the iceberg in the challenges of migrating from others to Oracle. SUggest you get yourself a copy of Thomas Kyte's "Effective Oracle By Design" and find out about some of the others before it's too late in the cycle.

/Hans Received on Fri Oct 01 2004 - 09:10:05 CDT