RE: Short_names vs long_names objects...

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Tue, 25 May 2004 18:41:20 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNIEKFCDAA.lex.de.haan@naturaljoin.nl>

see enhancement request 3281156, to support ANSI/ISO long identifiers (128 characters)
I entered in november 2003 ... (current status: internal review) Kind regards,
Lex.

visit my website at http://www.naturaljoin.nl

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Tim Gorman Sent: Tuesday, May 25, 2004 14:26
To: oracle-l_at_freelists.org
Subject: Re: Short_names vs long_names objects...

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
-----------------------------------------------------------------


-- Binary/unsupported file stripped by Ecartis --
-- Type: text/x-vcard
-- File: Lex de Haan.vcf


----------------------------------------------------------------
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:38:19 CDT