Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Maximum length of table and column names
On Fri, 01 Oct 2004 14:10:05 GMT, Hans Forbrich <news.hans_at_telus.net> wrote:
>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.
A picky proviso to this - that's 30 bytes, not characters, regardless of NLS_LENGTH_SEMANTICS which doesn't apply to the dictionary. Developers in countries with non-English alphabets may well use characters requiring more than one byte in their database's character set encoding.
-- Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk> <http://www.andyhsoftware.co.uk/space> Space: disk usage analysis toolReceived on Fri Oct 01 2004 - 13:26:30 CDT