Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Move table partition in parallel

Re: Move table partition in parallel

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Mon, 1 May 2006 00:18:47 +0900
Message-ID: <002001c66c69$612f3f10$cd131eac@porgand>


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.

> 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
Received on Sun Apr 30 2006 - 10:18:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US