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).
