Oracle-L: RE: Database naming conventions

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 14 Feb 2003 09:24:06 -0800
Message-ID: <F001.0054DDE7.20030214092406@fatcity.com>

Melissa - You didn't mention which system you are on. My comments apply more to Unix.

Oracle warns not to make the instance name too long. Formerly they recommended you keep it to 4 characters. Not sure how that would apply today. It does make your processes long.

My #1 objective is to make sure nothing gets bollixed up in production, most particularly by me. Many DBA tasks are quite capable of creating a production disaster. I like the idea of putting "T" for test or whatever at the FRONT so that is just one small thing that might possibly save my bacon. Burying it in the middle obscures that.

The only reason I can think of putting the "ora" at the front is for the convenience of the sys admins, but Oracle puts that on the front anyway, at least on my Unix systems.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, February 14, 2003 10: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: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.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:06 CST