Re: Updating 100 M rows table

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 21 Jan 2010 16:42:59 -0800
Message-ID: <bf46381001211642x5ab8fe1tf26e11dd40d44364_at_mail.gmail.com>

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

Received on Thu Jan 21 2010 - 18:42:59 CST