Home     Documentation     Sliding window scenario

Sliding Window Scenario

4. Switch data into an archive table. Step 2.

Forward » « Back

Specify TransactionHistoryArchive as the target table. As we can see, the partition is switched into the extreme right partition of the TransactionHistoryArchive table.

Since in the "sliding window" scenario the extreme right section of the archive table must remain empty to receive new data, make sure to check the option Split right-most range before switching partition in. As a result, a partition with boundary values September 1, 2003 and October 1, 2003 is created, and the September 2003 data from the TransactionHistory table is switched into it.

The situation