Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Row Movement in paritioned tables

Row Movement in paritioned tables

From: Suresh Chaganti <chaganti.suresh_at_gmail.com>
Date: Wed, 15 Aug 2007 11:14:02 -0500
Message-ID: <1828353c0708150914x771fc152k3e7acac03746df93@mail.gmail.com>


Hi

I admit I havent done enough research on this, so pardon me if I should have found this out myself.

I know Oracle does row movement on partitioned tables when the values on the key changes such that it warrants movement to a new partition.

My question is , can I some how use this mechanism to let Oracle automatically move data to a designated partition.

The underlying business requirement is to Identify and move inactive data to be purged at a later date.

So I ws thinking if I can move use Oracle's internal mechanism to move the data to a partition named "INACTIVE" , I have greater flexibillity in droppping partition when the data is up for purge etc..

Thanks
Suresh

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 15 2007 - 11:14:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US