RE: Short_names vs long_names objects...
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 25 May 2004 18:41:20 +0200
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Tim Gorman
Sent: Tuesday, May 25, 2004 14:26
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
