Re: Short_names vs long_names objects...

  • From: Lisa Spory <lspory@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 20 May 2004 10:44:59 -0700 (PDT)

Jose,
 
I like to keep table names less than 15 characters (20 max) so that objects you 
name related to that table (e.g. indexes / constraints) can easily inherit the 
table name.
 
Regards,
 
Lisa
Jose Luis Delgado <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
-----------------------------------------------------------------
                
---------------------------------
Do you Yahoo!?
Yahoo! Domains - Claim yours for only $14.70/year

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