RE: Database naming conventions

[Godlewski, Melissa]

Title: RE: Database naming conventions

Thanks everyone for your opinions.  I believe I have some good examples of why not to use ora.

 

This list is great!

-----Original Message-----
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 14, 2003 3:59 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Database naming conventions

We use following syntax ...

* FAM     -- ABC Family Production DB
* OLDFAM  -- essentially FAM but as of 2AM today (refreshed daily or on demand)
* FAMQA   -- FAM QA
* FAMTEST -- FAM User Acceptance
* FAMDEV  -- Fam development

This works good for us ...

Raj
______________________________________________________
Rajendra Jamadagni              MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!

--- "Godlewski, Melissa" <[EMAIL PROTECTED]> wrote:
> List,
> 
> I'm use to using a standard D=development T=test P=production.  So
> for a
> database newly created on development it would be called something
> like
> D24X7.  Then when it was created on Production it would be called
> P24X7.  Or
> along similar lines.
> 
> I'm working with an other DBA who wants everything to start with ora.
> Therefore it would be called orad24x7 and orap24x7.  I've argued the
> ora is
> rather redundant since everyone will know it's an Oracle database
> they are
> connecting to.  He is adamant it should have the ora identification
> so it is
> easily identified.  I feel it will cause more confusion having ora at
> the
> beging of every dbname. 
> 
> Any thoughts for against either position?
> 
> TIA
> M.Godlewski
>