Re: Updating 100 M rows table

From: Sanjay Mishra <>
Date: Fri, 22 Jan 2010 13:56:10 -0800 (PST)
Message-ID: <>


There are some new rules added due to communication changes which were same from Last 10+ years. Earlier it was never subjected to this big DML operation and so nothing was planned accordingly. Company was purchased by other big company  and they had the different rules which has affected the data and so we have to plan the changes.


From: Jared Still <>
Sent: Thu, January 21, 2010 7:42:59 PM
Subject: Re: Updating 100 M rows table

Can you tell us why 20 million rows of this table need to be updated? 

I'm always curious about the root cause of problems like this, and there
are likely others that would like to know as well.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog:
Home Page:

On Thu, Jan 21, 2010 at 1:33 PM, Sanjay Mishra <> wrote:

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. 

Received on Fri Jan 22 2010 - 15:56:10 CST

Original text of this message