RE: Updating 100 M rows table
- From: Josh Collier <Josh.Collier@xxxxxxxxxxxx>
- To: "smishra_97@xxxxxxxxx" <smishra_97@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 21 Jan 2010 13:35:43 -0800
Asktom
http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:6407993912330
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Sanjay Mishra
Sent: Thursday, January 21, 2010 1:33 PM
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts: