Oracle-L: RE: update 30mil rows

From: Richard Ji <richard.ji_at_mobilespring.com>
Date: Tue, 25 Feb 2003 13:54:28 -0800
Message-ID: <F001.005593F6.20030225135428@fatcity.com>

You can:

create table new_tab as select ....

and perform the update there. You can use nologging here.

Then you could index the new table, put back grants, constraints etc. drop old table and rename the new table to old table.

Richard

-----Original Message-----
Sent: Tuesday, February 25, 2003 1:27 PM To: Multiple recipients of list ORACLE-L

Hi all:

I need to update every row 30mil-rows table. I have dropped the indices and running the update in parallel:

update /*+ parallel (degree 8) */ table_name set field1=0;

Is there anything else I could to to speed up this process. I don't think I can do an update in nologging mode. I'm running 8.1.7.4

thanks for any advice.

Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Gurelei
INET: gurelei_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Richard Ji
INET: richard.ji_at_mobilespring.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------