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:

  1. Use the ALTER INDEX ALTER PARTITION statement to alter the key range values of the partitioning index.
  2. Use the REORG utility with inline statistics on the partitions that are affected by the change in key range.
  3. Use the RUNSTATS utility on the nonpartitioned indexes.
  4. Rebind the dependent packages and plans.