Re: Database naming conventions

This reminds me something that happened to me about seven years ago. We had a head honcho (read DBA manager) who just had a sweet slide from DB2 word to Oracle and as one of the first things he suggested was to rename all the tables to be prefixed by "USERTAB_" and all the views by "USERVIEW_", and you got the idea. Naturally he also wanted all the apps to be recoded to reflect the new tablenames (he had no idea what a synonym was or he just didn't care). What was the point behind "USERTAB_" prefix? It's user created tables, stupid, as opposed to system created ones!

"But you can't rename the system tables to prefix SYSTAB_.....", your truly suggested.

"Sure you can", came the reponse growled back.

Everyone in the room smiled sheepishly. Realizing that he may have made a blunder, Mr Name Prefixer roared at me:

"And you will make sure that it happens. that's your goal of this year - to change the app and change the table names."

Mercifully, he didn't stick around longer. Pressure from within forced him out to his familiar DB2 world. Perhaps he listened to his call from the wild, the sweet sweet world where he can prefix whatever names to tables he wants.

No, I didn't ask him what his cat's name was.

Arup

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, February 14, 2003 2:08 PM

> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: orarup_at_hotmail.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).