Re: 30 character limit for table/column names?

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 20 Feb 2007 23:37:59 +0000
Message-ID: <45DB8657.7090809@dial.pipex.com>

Timasmith wrote:
> On Feb 19, 5:57 am, "William Robertson" <williamr2..._at_googlemail.com>
> wrote:

>> On Feb 18, 5:25 pm, "Timasmith" <timasm..._at_hotmail.com> wrote:
>>
>>> In 10g is Oracle past the 30 character limit for table names and
>>> columns?
>> No, thank goodness. Let's hope it stays that way.

>
> Well I think one day they should increase, I liken it to DOS and 8
> character filenames. When you build large information systems with
> 100's, even thousands of tables it becomes rather annoying for users
> to have to guess the spelling. It also forces an ugly naming
> convention as the logical domain prefixes are forced from 'words' to
> '3 character prefixes that suck'.
>

I wonder what limit you would increase it to? I personally would object to a table called

tbl_object_identifiers_of_irrational_personifications_of_usenet_posters_self_identifying_as_timothy_smith_in_2007_version_1.2.a_beta

but I could use such a table myself- and of course the agile enhancements for column names that logically follow.

In fact now I think about it maybe there's a case for all business logic to be encoded in navaho (sp?) indian.

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info/services

Received on Tue Feb 20 2007 - 17:37:59 CST