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