Re: Updating 100 M rows table
From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Fri, 22 Jan 2010 13:49:14 -0800 (PST)
Message-ID: <277814.67452.qm_at_web51304.mail.re2.yahoo.com>
Date: Fri, 22 Jan 2010 13:49:14 -0800 (PST)
Message-ID: <277814.67452.qm_at_web51304.mail.re2.yahoo.com>
No table is curently not partitioned due to partitioning License.
________________________________
From: "troach_at_gmail.com" <troach_at_gmail.com>
To: smishra_97_at_yahoo.com; oracle-l_at_freelists.org
Sent: Thu, January 21, 2010 5:53:34 PM
Subject: Re: Updating 100 M rows table
Can you utilize any type of partitioning? Also look at parallel dml.
Sent from my Verizon Wireless BlackBerry
________________________________
From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Thu, 21 Jan 2010 13:33:04 -0800 (PST)
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-lReceived on Fri Jan 22 2010 - 15:49:14 CST