Updating 100 M rows table

From: Sanjay Mishra <smishra_97@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Thu, 21 Jan 2010 13:33:04 -0800 (PST)

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

Follow-Ups:
- RE: Updating 100 M rows table
  - From: Josh Collier
- Re: Updating 100 M rows table
  - From: troach
- Re: Updating 100 M rows table
  - From: Jared Still

Other related posts:

» Updating 100 M rows table - Sanjay Mishra
» RE: Updating 100 M rows table- Josh Collier
» Re: Updating 100 M rows table- Sanjay Mishra
» Re: Updating 100 M rows table- troach
» RE: Updating 100 M rows table- Kellyn Pedersen
» Re: Updating 100 M rows table- Jared Still
» Re: Updating 100 M rows table- Sanjay Mishra
» Re: Updating 100 M rows table- Sanjay Mishra
» Re: Updating 100 M rows table- Sanjay Mishra
» Re: Updating 100 M rows table- Kellyn Pedersen