Chao, Connor, Sanjay, cary, mark, richard: Thanks for your input. I didn't think of creating a new table and then renaming it as many of you suggested this may take les time.
thank you all very much Gene --- chao_ping <[EMAIL PROTECTED]> wrote: > Gurelei, > I suggest your create your new table as select > other_columns,0 from your old table with nologging > and parallel. > > > > > > Regards > zhu chao > msn:[EMAIL PROTECTED] > www.happyit.net > www.cnoug.org(China Oracle User Group) > > ======= 2003-02-25 13:26:00 ,you wrote��======= > > >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: chao_ping > 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). > __________________________________________________ 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).
