Re: RAC partitioning question

From: Yechiel Adar <>
Date: Wed, 01 Feb 2012 13:34:00 +0200
Message-id: <>

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

On 31/01/2012 17:04, Walker, Jed S wrote:
> As such, the Primary Key has to be a global index.

Received on Wed Feb 01 2012 - 05:34:00 CST

Original text of this message