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?= <[EMAIL PROTECTED]>
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 ?
=====
Stephane Paquette
DBA Oracle
[EMAIL PROTECTED]
__________________________________________________
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
