Re: Move table partition in parallel

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.

----- Original Message ----- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
To: <mcdonald.connor@xxxxxxxxx>
Cc: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
Sent: Sunday, April 30, 2006 3:34 PM
Subject: Re: Move table partition in parallel



Nop - no subpartitions. IMHO I can't even move the whole partition if
table is subpartitioned but had to move rather each subpartition. Just
like cannot move the whole partitioned table with one command.
Thanks, Alex

2006/4/30, Connor McDonald <mcdonald.connor@xxxxxxxxx>:

Purely hypothesizing here [subtext: I'm too lazy to start my db on the
weekend...], but perhaps parallel move of a partition is limited to the the
subpartition level, ie, if you've got subpartitions that you they'll get a
slave each ?


 Cheers
 Connor

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



-- http://www.freelists.org/webpage/oracle-l


Other related posts: