RE: Updating 100 M rows table

From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Thu, 21 Jan 2010 13:35:43 -0800
Message-ID: <C5671700C5F4EA47B08AB9E6DAE9539B3816A2F65B_at_M1EXCHANGE01.mmi.local>

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-l

Received on Thu Jan 21 2010 - 15:35:43 CST

This message: [ Message body ]
Next message: Sanjay Mishra: "Raw Logical Partition on AIX for OCR"
Previous message: Sanjay Mishra: "Updating 100 M rows table"
In reply to: Sanjay Mishra: "Updating 100 M rows table"
Next in thread: Sanjay Mishra: "Re: Updating 100 M rows table"
Reply: Sanjay Mishra: "Re: Updating 100 M rows table"
Reply: Kellyn Pedersen: "RE: Updating 100 M rows table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message