Re: Could I change the max length of an object name?

From: Mark D Powell <>
Date: Tue, 24 Jun 2008 07:22:46 -0700 (PDT)
Message-ID: <>

On Jun 24, 5:48 am, gazzag <> wrote:
> On 24 Jun, 08:44, wrote:
> > Could I change the max length limit(30 characters) of an object name?
> > If I could, how?
> > Thank you very much!
> > Jack.Lee
> No.  Why would you want to?
> -g

My experience tells me it is best if table names are kept to around 20 characters.

Oracle does support some objects with names greater then 30 characters such as database links, but not table names, index names, column names, or view_names.

One thing you should do in development is to adopt a common set of abbreviations that you use all the time even if the length of the object name is well under 30 characters. Consistency in naming standard provides significant long-term maintenance benefit.

HTH -- Mark D Powell -- Received on Tue Jun 24 2008 - 09:22:46 CDT

Original text of this message