Redefining a partition (index-based partitioning)
Sometimes each partition in a partitioned object is restricted to a single data set. If the data set reaches its maximum size, you need to redefine the partitions. Redefining a partition in an index-based partitioning environment is different than in a table-based partitioning environment.
Procedure
To redefine the partitions in an index-based partitioning environment:
- Use the ALTER INDEX ALTER PARTITION statement to alter the key range values of the partitioning index.
- Use the REORG utility with inline statistics on the partitions that are affected by the change in key range.
- Use the RUNSTATS utility on the nonpartitioned indexes.
- Rebind the dependent packages and plans.