Re: Updating 100 M rows table
From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Fri, 22 Jan 2010 13:56:10 -0800 (PST)
Message-ID: <558197.36478.qm_at_web51307.mail.re2.yahoo.com>
Date: Fri, 22 Jan 2010 13:56:10 -0800 (PST)
Message-ID: <558197.36478.qm_at_web51307.mail.re2.yahoo.com>
Jared There are some new rules added due to communication changes which were same from Last 10+ years. Earlier it was never subjected to this big DML operation and so nothing was planned accordingly. Company was purchased by other big company and they had the different rules which has affected the data and so we have to plan the changes. Sanjay ________________________________ From: Jared Still <jkstill_at_gmail.com> To: smishra_97_at_yahoo.com Cc: oracle-l_at_freelists.org Sent: Thu, January 21, 2010 7:42:59 PM Subject: Re: Updating 100 M rows table 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. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com 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. > >TIA >Sanjay >
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 22 2010 - 15:56:10 CST