Oracle-L: RE: Database naming conventions

From: Tony Johnson <Tony_Johnson_at_Trimble.com>
Date: Fri, 14 Feb 2003 09:24:07 -0800
Message-ID: <F001.0054DE02.20030214092407@fatcity.com>

I had the same arguments with a consultant we had in at one time I compromised with him. The database files are in a directory called 'oradata' and we use a designator of D development, T for Testing, B for Beta, P for Production and S for Stress Test.

-----Original Message-----
Sent: Friday, February 14, 2003 9:24 AM
To: Multiple recipients of list ORACLE-L

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Tony Johnson
INET: Tony_Johnson_at_Trimble.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Feb 14 2003 - 11:24:07 CST