RE: RE: How-To or Good Practices on Code Releases

what is the difference in the db between adding a column with a default value, and adding a column and then later modifying it to set a default value?

in neither case is the value actually set in the column itself.

thx
-b

-----Original Message-----
Sent: Thursday, November 14, 2002 6:09 AM To: Multiple recipients of list ORACLE-L

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)

• 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_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: Magaliff, Bill
  INET: Bill.Magaliff_at_lendware.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).