Re: RAC partitioning question
Date: Wed, 01 Feb 2012 13:34:00 +0200
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.
On 31/01/2012 17:04, Walker, Jed S wrote:
> As such, the Primary Key has to be a global index.