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_at_gmail.com> To: <mcdonald.connor_at_gmail.com> Cc: "Oracle-L Freelists" <oracle-l_at_freelists.org> 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_at_gmail.com>:
>
>> 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