Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 30 character limit for table/column names?

Re: 30 character limit for table/column names?

From: Timasmith <timasmith_at_hotmail.com>
Date: 19 Feb 2007 05:03:33 -0800
Message-ID: <1171890213.622696.199700@v33g2000cwv.googlegroups.com>


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'. Received on Mon Feb 19 2007 - 07:03:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US