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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Short_names vs long_names objects...

Re: Short_names vs long_names objects...

From: Tim Gorman <tim_at_sagelogix.com>
Date: Tue, 25 May 2004 07:26:09 -0600
Message-ID: <BCD8A591.15769%tim@sagelogix.com>


Ask them to prove it. Having "heard it somewhere" or "read about it somewhere" is insufficient.

30 chars is the limit in the data dictionary columns for most names; doing a describe on the data dictionary view or underlying table proves this. As with all limits, there are many good reasons not to push up close against them. Frequently other objects (i.e. indexes, triggers, constraints, etc) benefit from having the table name as a component of their name, so naming objects to accommodate these habits as well as the 30-char limit makes sense.

on 5/20/04 9:06 AM, Jose Luis Delgado at joseluis_delgado_at_yahoo.com wrote:

> Hi to all...
>
> I'd like to know if any of you have docs for naming
> objects, pros and cons...
>
> Some guys are saying that Oracle recommend the use of
> objects with less than 30 chars (24 to be accurates)
> because of performance reasons.
>
> That objects names should be in singular, and not much
> longers.
>
> Any points or docs?
>
> TIA
> JL
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Domains ? Claim yours for only $14.70/year
> http://smallbusiness.promotions.yahoo.com/offer
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Tue May 25 2004 - 11:25:09 CDT

Original text of this message

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