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: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Sun, 30 Apr 2006 11:56:00 +0800
Message-ID: <5e3048620604292056w33ac1d93v8da15f31bb397693@mail.gmail.com>


On 4/29/06, Alex Gorbachev <gorbyx_at_gmail.com> wrote:
>
> Hi listers,
>
> Is there any way to really parallelize partition move operation?
>
> Table is heap-organized and contains few BLOB columns if it maters.
> There is a local index partition of which, of course, gets invalidated
> after move.
>
> TIA!
>
> --
> Best regards,
> Alex Gorbachev
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> 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

--
Connor McDonald
===========================
email: connor_mcdonald_at_yahoo.com
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Apr 29 2006 - 22:56:00 CDT

Original text of this message

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