Yeah but it is so much work to add 10 new fields .
The latest one is 'Do we have a tool that can compare
the dev and the test environment so we know what we
have to put in test ?' .
Not only it is too hard to do 10 alter tables but also
it is too hard to make a list of what is changed (I'm
not even talking about planning stuff).
Here, the 2/3 of IT is from one of the biggest
consultant firm (Cap Gemini Ernst and Young, oups it
slips out ...) so 99.9% of the 2/3 are developpers
asking questions like " Can you tell me again the
difference between a primary key and a foreign key".
It's 18:20 , I'm going home and I'll send a less nasty
email on monday morning.
- jkstill_at_cybcon.com a écrit : >
> Stay on it. Dropping tables to add columns in
> development is just plain stupid.
>
> Jared
>
> On Fri, 16 Feb 2001, [iso-8859-1] paquette stephane
> wrote:
>
> > 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).
> >
>
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).
Received on Fri Feb 16 2001 - 13:13:26 CST
