Re: Move table partition in parallel

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.

----- Original Message ----- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
To: <tanel.poder.003@xxxxxxx>
Cc: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, May 01, 2006 12:39 AM
Subject: Re: Move table partition in parallel


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


Other related posts: