Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Move table partition in parallel

Re: Move table partition in parallel

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Mon, 1 May 2006 01:08:52 +0900
Message-ID: <1ca301c66c70$63ffc000$cd131eac@porgand>


You probably are aware of this article - but when planning to exchange partitions, one should read Jonathan Lewis'es article on it: http://www.jlcomp.demon.co.uk/17_partition_problems.doc

Cheers,
Tanel.

> 9.2.0.5.
> CTAS + exchange partition is actually a good idea. In addition, it
> increases SELECT availability as index is available all the time
> (index is built on table before exchange).
> Thanks,
> Alex

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Apr 30 2006 - 11:08:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US