Re: Move table partition in parallel

  • From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
  • To: tanel.poder.003@xxxxxxx
  • Date: Sun, 30 Apr 2006 17:39:21 +0200

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


Other related posts: