Re: Oracle Partition Movement

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@xxxxxxxxxxxx> 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@xxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l

Other related posts: