| 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: RE: How-To or Good Practices on Code Releases
You now have an excellent argument for disabling developer
access to production databases.
Jared
"chao_ping" <chao_ping_at_vip.163.com>
Sent by: root_at_fatcity.com
11/14/2002 03:08 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
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
chao_ping_at_vip.163.com
www.happyit.net
www.cnoug.org(Chinese Oracle User Group)
>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_at_len To: Multiple recipients
of list ORACLE-L <ORACLE-L_at_fatcitS
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: chao_ping_at_vip.163.com 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Jared.Still_at_radisys.com 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: 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 Thu Nov 14 2002 - 17:39:43 CST
 |
 |