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

2006/4/30, Tanel Põder <tanel.poder.003@xxxxxxx>: 
Which version are you on?

Intra-partition parallelism isn't available in earlier versions.

Also, if nothing else helps you could try to create table as select in
parallel from your partition to a table in new location and exchange the
partition with the new table.

Tanel. 


--
Best regards,
Alex Gorbachev
--
http://www.freelists.org/webpage/oracle-l


Other related posts: