Re: Oracle Partition Movement

From: Adam Musch <>
Date: Wed, 3 Nov 2010 06:50:23 -0500
Message-ID: <>

Well, you could exchange the partition of TABLEA with an empty table, then exchange that now populated table with an empty partition of TABLEA_ARCH. You do, however, have to have then the exact same (local) indexes in place between TABLEA and TABLEA_ARCH.

On Wed, Nov 3, 2010 at 6:40 AM, Mercadante, Thomas F (LABOR) <> wrote:
> All,
> Running Oracle on Aix.
> Lets say I have a partitioned table (TABLEA) partitioned by quarter. I also
> have an archive version of this table (TABLEA_ARCH) that I would like to
> partition by quarter also.
> On a regular interval, I want to move all the records from the oldest
> partition of TABLEA into TABLEA_ARCH.
> Is this possible? According to the docs, PARTITION EXCHANGE does not
> support this when I try and Exchange a partition, it looks like I need to
> do this to a fresh table.
> Im trying to support this data movement within the database and do it as
> quickly as possible.
> Any suggestions?
> Thanks
> Tom

Adam Musch
Received on Wed Nov 03 2010 - 06:50:23 CDT

Original text of this message