A user has a table with 132 partitions, each of which represents a month of data. The first partition has a limit of '2004-01-31' and the last one has a limit of '2014-12-31'. The user wants to logically drop off the first 60 partitions and
add 60 new ones to the end, and physically delete the data in the first 60 partitions and initialize the 60 new ones.
Release: R20
Component: RCM
Using RC/Migrator create an ALTER strategy for the table. Once on the Table Alter screen, issue the LIMITS command first and then the limit keys will be displayed.
Then issue the ROTATE command and input the limitkey for the last partition. This should be repeated for each partition that is to be ROTATEed to include the new last partition.