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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
