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_at_mail.ee>:
> 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
Received on Sun Apr 30 2006 - 10:39:21 CDT
