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 01:08:52 +0900

You probably are aware of this article - but when planning to exchange partitions, one should read Jonathan Lewis'es article on it: http://www.jlcomp.demon.co.uk/17_partition_problems.doc

Cheers,
Tanel.

----- Original Message ----- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
To: <tanel.poder.003@xxxxxxx>
Cc: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, May 01, 2006 12:39 AM
Subject: Re: Move table partition in parallel


9.2.0.5.
CTAS + exchange partition is actually a good idea. In addition, it
increases SELECT availability as index is available all the time
(index is built on table before exchange).
Thanks,
Alex


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


Other related posts:

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