Re: Updating 100 M rows table
- From: Sanjay Mishra <smishra_97@xxxxxxxxx>
- To: jkstill@xxxxxxxxx
- Date: Fri, 22 Jan 2010 13:56:10 -0800 (PST)
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@xxxxxxxxx>
To: smishra_97@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> 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
>
Other related posts: