Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Move table partition in parallel
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-lReceived on Sat Apr 29 2006 - 22:56:00 CDT
![]() |
![]() |