"Sliding window" with table partition
Hi,
I have a partitioned table with one partition containing history data and the other contains current (on-line) data. The table is range partitioned with date as the key and I have enabled row movements.
I would like to have the on-line partition to store data for the last 24 months. When data (inserted earlier) gets out of date, I would like the rows to be moved to the history partition.
My question is: what is the best implementation for such a "sliding window" technique?
Do I have to update the partition key (date) for all rows to trigger the row movements?
/johan