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.
[EMAIL PROTECTED]
-----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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
