Re: Short_names vs long_names objects...
- From: Tim Gorman <tim@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 25 May 2004 07:26:09 -0600
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
-----------------------------------------------------------------
Other related posts:
