RE: Database naming conventions

From: Richard Ji <richard.ji_at_mobilespring.com>
Date: Fri, 14 Feb 2003 11:08:59 -0800
Message-ID: <F001.0054E0DC.20030214110859@fatcity.com>

Melissa,

Ask him if he name all his tables "TAB...", java class "Java...", his pet "CAT..." or "DOG..." etc?

Richard

-----Original Message-----
Sent: Friday, February 14, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L

there is no reason to call the database "ora....."

I understand the reasoning behind and the desire for naming conventions.

What happens when your shop decides to go with MySQL (as this list has been talking about)... will he want to rename the database to mysqlt24x7? will he even be allowed to have a database name that long?

• "Godlewski, Melissa" <Melissa.Godlewski_at_hq.doe.gov> 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
  >
  >
  >
  >
  >
  

  ---

Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: richard.ji_at_mobilespring.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 - 13:08:59 CST