RE: Row Movement in paritioned tables

  • From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
  • To: chaganti.suresh@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 15 Aug 2007 11:47:24 -0500

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Suresh Chaganti
Sent: Wednesday, August 15, 2007 11:14 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Row Movement in paritioned tables

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
--
//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.

==============================================================================

--
//www.freelists.org/webpage/oracle-l


Other related posts: