Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB Object naming conventions ??
Thanks for your input
I have tried looking in my Installation Guide for DEc Unix and not found much. Where should I look. Do you have specifiic references you could quote.
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.
tmgn <tmgn_at_excite.com> wrote in message news:3798A7EE.418AFEC3_at_excite.com...
> 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 Tue Jul 27 1999 - 04:20:10 CDT