Re: update 30mil rows - thanks

From: Gurelei <gurelei_at_yahoo.com>
Date: Wed, 26 Feb 2003 05:58:53 -0800
Message-ID: <F001.00559EB4.20030226055853@fatcity.com>

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 <chao_ping_at_vip.163.com> 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:chao_ping_at_163.com
> 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: 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: chao_ping
> INET: chao_ping_at_vip.163.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).
>

---

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).

Received on Wed Feb 26 2003 - 07:58:53 CST