Re: DB Object naming conventions ??

Hi Kevin,
Oracle does suggest some formal Naming Conventions for various Database Entities and can be found in the Installation Guides..

However We can use our own Naming convention Standards as long as they make sense..like..

Tablespace Names should indicate the nature of Segments they hold eg.

DATA01,RBS_BIG, TEMP_RPT etc
Here DATA01 indicates the 1st DATA Tablespace. RBS_BIG indicate Rollback Segment TS with huge Rollback Segments TEMP_RPT Tablespace holds the Temp Segments for Reporting User ...

Datafiles should indicate the Database,Tablespace,Datafile Number etc..eg

/oradata1/prod1/dbepp_temp_02.dbf
/oradata2/prod1/dbepp_rbs_01.dbf

Foreign Keys should preferably indicate the Detail_table,Master_table and the type of Key ..eg

emp_to_dept_fk
doc_id_to_master_id_fk ..etc

Primary and Unique Keys should preferably have the Table_name,Column_name and the type of Key..eg

DOC_ID_PK
EMP_ID_UNQ Hope this helps...

-Thiru

Kevin A Lewis wrote:

> I have a number of databases that conform to a number of naming conventions
> for different objects in the database
>
> e.g. Datafiles
> Tablespaces
> Foriegn Keys
> Unique Keys
> Primary Keys
> Rollback Segment etc
>
> Are there any industry wide naming conventions - even informally keep to
> ones. What I want to do is establish some best practice and gradually work
> over to it. If there are widely used ones we can make use of it will ease
> the understanding of any new staff or contractors.
>
> Regards
>
> --
> Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)
> <KevinALewis_at_HotMail.com>
>
> The views expressed herein by the author of this document
> are not necessarily those of BOCM PAULS Ltd.
Received on Fri Jul 23 1999 - 12:35:42 CDT