Re:RE: Am I too hard on the developper ?

From: <dgoulet_at_vicr.com>
Date: Fri, 16 Feb 2001 10:38:57 -0800
Message-ID: <F001.002B6B05.20010216100723@fatcity.com>

Mladen,

    Can I interest you in a change of location??? :-)

Dick Goulet

____________________Reply Separator____________________
Author: "Gogala; Mladen" <MGogala_at_oxhp.com>
Date:       2/16/2001 9:02 AM

Stephane, the idea of dropping and re-creating tables is simply preposterous. If the tables involved are bigger then 50M, then such procedure is not practical. Anyway, I don't see why would the table need to be dropped/re-created now when we can drop columns and move/rebuild tables. Fortunately for me, I am 6'4", 250 LBS, former greko-roman wrestler, so not many people do come up with such ideas on Friday afternoon.

-----Original Message-----
Sent: Friday, February 16, 2001 11:06 AM To: Multiple recipients of list ORACLE-L

Hi,

I do not know if it's friday afternoon or what ? The developpers want me to regenerate the grants in the development environment because they're running a script that drops and recreates a new version of the tables.
I asked them : Could you do an alter table instead ?

The developpers : What ! they'are at least 10 new fields !

I used to be a developper, I do not remember myself dropping and recreating everything each time I add a new field . Anyway in production, only the new stuff goes in.

Any comments ?

---

Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com

---

Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/
--

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

Author: =?iso-8859-1?q?paquette=20stephane?=   INET: stephane_paquette_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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

Author: Gogala, Mladen
  INET: MGogala_at_oxhp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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

Author:
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 16 2001 - 12:38:57 CST