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
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 -- //www.freelists.org/webpage/oracle-l