Re: Oracle naming convention...

From: Howard J. Rogers <howardjr_at_www.com>
Date: Thu, 22 Mar 2001 22:18:17 +1100
Message-ID: <3ab9df84@news.iprimus.com.au>

There *is* a standard, it's called Optimal Flexible Architechture (OFA for short), and it was published way back in 1991.

A copy of the original whitepaper can be downloaded at http://www.geocities.com/hjroz2000/ofa.pdf

It deals with the physical database structure only, though, so doesn't cover table names and the like. File layouts and names are, however, convered exhaustively and authoritatively.

Regards
HJR "Giorgio Sorbara" <NoSp_at_m> wrote in message news:3ab9da18$0$9722$73bec57d_at_news.be.uu.net...
> Hi there...
>
> just asekd to file a document in which is written
> a standard naming convention for the objects in
> an Oracle database...
> I already have my "standard"... but does anybody
> know if there is an actual standard convention
> for naming either the logical objects (sequences,
> indexes, functions... and so on) and the physical
> one such as datafiles, control file... etc etc...
>
> Perhaps if you want share yours if you have any...
>
> /Giorgio
>
>
Received on Thu Mar 22 2001 - 05:18:17 CST