RE: update 30mil rows - thanks

One of the segments will be chosen to be the final segment and all other segments will be trimmed (except the one chosen to be the final table) and merged into the final segment.

Regards,
Waleed

-----Original Message-----
Sent: Wednesday, February 26, 2003 11:09 AM To: Multiple recipients of list ORACLE-L

One thought to add to the "Create as select nologging" suggestion that you've had.

It is likely to be quick - and if you have enough spindles in play it may be even quicker it you make it execute as a parallel create.

If you do, be careful of your choice of extent size, as each separate PX slave will behave as if it is solely responsible for creating the table. A side effect of this is that if you run with degree N, then you could easily end up with about N extents that are half-empty. Pick an extent size which leaves you with a potential wastage that isn't going to irritate you.

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon one-day tutorials:
Cost Based Optimisation
Trouble-shooting and Tuning
Indexing Strategies
(see http://www.jlcomp.demon.co.uk/tutorial.html )

____UK_______March 19th
____USA_(FL)_May 2nd

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: 26 February 2003 13:58

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

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: Khedr, Waleed
  INET: Waleed.Khedr_at_FMR.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).