| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:Am I too hard on the developper ?
Stephane,
It's Friday, thank God & Rachel.
Anyway, should one use the "alter table" or drop & rebuild method? Good question. Certainly "alter table" is easier, but then there is the possibility of fragmentation and chained blocks, but in development who really cares? Also, how many column(s) are they adding, what data types are they & how large are they? Most of the time I see developers wanting to do the drop/rebuild method so that the order of the fields when doing a describe matches the applications use of the columns. Big deal. I remember some time ago doing a PeopleSoft patch where they wanted to rebuild a many many rows table just to add a single character flag field. Again big deal, I just ran an alter table instead. Saved a ton of time and the application did not care one bit. Still running as we speak.
In your case though, I'd push the PAIN back on the developers. If they want to rebuild the table they can redo the grants as well. Suprising how often they'll prefer the alter vs. rebuild.
Dick Goulet
____________________Reply Separator____________________ Author: =?iso-8859-1?q?paquette=20stephane?= <stephane_paquette_at_yahoo.com> Date: 2/16/2001 8:05 AM
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 ?
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).
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:29:19 CST
 |
 |