Re: Updating 100 M rows table
From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Thu, 21 Jan 2010 14:07:38 -0800 (PST)
Message-ID: <628057.85366.qm_at_web51308.mail.re2.yahoo.com>
Date: Thu, 21 Jan 2010 14:07:38 -0800 (PST)
Message-ID: <628057.85366.qm_at_web51308.mail.re2.yahoo.com>
Thanks Josh. Will check the details ________________________________ From: Josh Collier <Josh.Collier_at_banfield.net> To: "smishra_97_at_yahoo.com" <smishra_97_at_yahoo.com>; "oracle-l_at_freelists.org" <oracle-l@freelists.org> Sent: Thu, January 21, 2010 4:35:43 PM Subject: RE: Updating 100 M rows table Asktom http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:6407993912330 From:oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra Sent: Thursday, January 21, 2010 1:33 PM To: oracle-l_at_freelists.org Subject: Updating 100 M rows table Can anyone suggest some experience with big updates. I had at table with 30 column (non-Lob or LONG) in 10g and has few indexes. I need to update 20 million Records of 100Million, what is the best appproach. We can use nologging as it is not having any DR associated with it and Database is not in FORCE Logging. TIA Sanjay
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 21 2010 - 16:07:38 CST