Well,
yes there are. It is very likely that you will want to name subsequent database
objects which are closely associated with that table (indexes, constraints,
etc) with the table name as the prefix (or suffix). The longer your
original table name, the less flexibility you have before you have to start
amending or truncating your table name. Depending on your working practices,
this could be inconvenient if you want to retain the original table name as a
key component of other object names. We do just this (corporate standards),
and these standards enable us to by-pass many joins across the Oracle DD when
looking for dependencies etc.
just a
thought
peter
edinburgh
-----Original Message-----
From: Webber Valerie H [mailto:[EMAIL PROTECTED]]
Sent: 19 February 2003 17:49
To: Multiple recipients of list ORACLE-L
Subject: Lengthy Table and/or column namesAre there any issues to consider when naming tables and/or columns (length of column name)? I know the max length is 30 but some of the table names that my client wants to add (against my recommendation) look like Cobol and are pushing 30 characters.
Just wanted to know if there are any potential performance issues or anything else I should warn them about.
Thank in advance!
ValValerie H. Webber
Management Systems Designers, Inc
Database Administrator
[EMAIL PROTECTED]
704-566-5321
*********************************************************************
This e-mail message, and any files transmitted with it, are
confidential and intended solely for the use of the addressee. If
this message was not addressed to you, you have received it in error
and any copying, distribution or other use of any part of it is
strictly prohibited. Any views or opinions presented are solely those
of the sender and do not necessarily represent those of the British
Geological Survey. The security of e-mail communication cannot be
guaranteed and the BGS accepts no liability for claims arising as a
result of the use of this medium to transmit messages from or to the
BGS. The BGS cannot accept any responsibility for viruses, so please
scan all attachments. http://www.bgs.ac.uk
*********************************************************************
