Re: Updating 100 M rows table
Date: Thu, 21 Jan 2010 16:42:59 -0800
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.
On Thu, Jan 21, 2010 at 1:33 PM, Sanjay Mishra <smishra_97_at_yahoo.com> 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.