Re: RAC partitioning question
From: Yechiel Adar <adar666_at_inter.net.il>
Date: Wed, 01 Feb 2012 13:34:00 +0200
Message-id: <4F292328.8090009_at_inter.net.il>
I beg to differ with your basic assumption: The primary key needs to be global.
Date: Wed, 01 Feb 2012 13:34:00 +0200
Message-id: <4F292328.8090009_at_inter.net.il>
I beg to differ with your basic assumption: The primary key needs to be global.
Use oracle 11 with range partition and use the sequence as the value to the range.
Since you use a sequence the dates go up with the sequence.
When it is time to delete just do:
Select min(pk) from tables where date > sysdate - nn.
Then calculate the partition this pk is in, and drop all the partitions below this.
No global key, no changes to the current structure or programs.
Yechiel Adar
Mehish
On 31/01/2012 17:04, Walker, Jed S wrote:
> As such, the Primary Key has to be a global index.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 01 2012 - 05:34:00 CST