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