Re: Updating 100 M rows table
- From: Jared Still <jkstill@xxxxxxxxx>
- To: smishra_97@xxxxxxxxx
- Date: Thu, 21 Jan 2010 16:42:59 -0800
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:
