You now have an excellent argument for disabling developer
access to production databases.
Jared
"chao_ping" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
11/14/2002 03:08 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: RE: How-To or Good Practices on Code Releases
Rajesh.Rao,
I have the same experience. Developers
directly connected to production database and added a column with default
table on a huge table. The whole table is locked for 1 hour and other
transaction failed.
Add a column with non default value and
then later add default value for it can be done in 1 second.
Developers do not Know how oracle do it
and just go on. New application going online without volume testing,
getting online and as a production dba,i search for the bad sql and trace
it out and send it back to developer!
That is why many project fail, the app is
designed and developed without the attendence of a guy who really knows
oracle.
Regards
zhu chao
Eachnet DBA
86-21-32174588-667
[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(Chinese Oracle User Group)
======= 2002-11-13 12:06:00 ,you wrote��=======
>I also have been burnt by an simple "alter table add column default
string"
>script. A pretty simple script. The developers tested it, the QA team too
>approved it. Was expected to run in a matter of minutes. The problem was
>the data in production was 100 times over. Missed out on volume testing.
>Took 2 cuppas and 3 smokes before it was done.
>
>Raj
>
>
>
>
>
> "Magaliff, Bill"
> <Bill.Magaliff@len To: Multiple recipients
of list ORACLE-L <ORACLE-L@fatcitS
= = = = = = = = = = = = = = = = = = = =
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: chao_ping
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
