Re: Move table partition in parallel

  • From: Tanel Põder <tanel.poder.003@xxxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 1 May 2006 00:18:47 +0900

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
--
//www.freelists.org/webpage/oracle-l



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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2006