From shantanu_t@yahoo.com Fri, 16 Feb 2001 11:20:06 -0800 From: Shantanu Talukder Date: Fri, 16 Feb 2001 11:20:06 -0800 Subject: RE: Am I too hard on the developper ? Message-ID: MIME-Version: 1.0 Content-Type: text/plain I think his/her database is 7.x not 8.x. You can drop,move, all these good things in 8.x only. --- "Gogala, Mladen" wrote: > 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@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@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@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@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@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). __________________________________________________ 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: Shantanu Talukder INET: shantanu_t@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@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).