RE: Row Movement in paritioned tables

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Wed, 15 Aug 2007 11:47:24 -0500
Message-ID: <D40740337A3B524FA81DB598D2D7EBB3097A88C7@x6009a.umb.corp.umb.com>

Alter table table_name enable row movement; Update table_name set partition_key='INACTIVE' where partition_key='ACTIVE' and whatever....

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Suresh Chaganti Sent: Wednesday, August 15, 2007 11:14 AM To: oracle-l_at_freelists.org
Subject: Row Movement in paritioned tables

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

NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

--

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