Oracle Partition Movement

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


Other related posts: