Re: Oracle Partition Movement

From: Adam Musch <ahmusch_at_gmail.com>
Date: Wed, 3 Nov 2010 06:50:23 -0500
Message-ID: <AANLkTin2v9i5Hi3BRfVh7SWNc+RL20urqcfLvyACMi3v_at_mail.gmail.com>

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) <Thomas.Mercadante_at_labor.ny.gov> wrote:
> All,
>
> Running Oracle 10.2.0.4 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.
>
> I’m trying to support this data movement within the database and do it as
> quickly as possible.
>
> Any suggestions?
> Thanks
> Tom
>
>

-- 
Adam Musch
ahmusch_at_gmail.com
--
http://www.freelists.org/webpage/oracle-l

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