Re: 30 character limit for table/column names?

On Feb 20, 6:37 pm, Niall Litchfield <niall.litchfi..._at_dial.pipex.com> wrote:
> Timasmithwrote:
> > 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_sel­f_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 DBAhttp://www.orawin.info/services- Hide quoted text -
>
> - Show quoted text -

I guess thats why PostgreSQL will overtake Oracle, they have a broader perspective of the world... To Serges point, 3 words in german easily breaks the 30 characters.

Even in English it is unfortunate that I cant have anything longer than this:

specimen_collection_containers

but I guess thats why oracle DBAs are hired - to keep track of obscure table names. Received on Wed Feb 21 2007 - 08:00:37 CST