Redefining a partition (table-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 a table-based partitioning environment is different than in an index-based partitioning environment.

Procedure

To redefine the partitions in a table-based partitioning environment:

  1. Use the SQL statement ALTER TABLE ALTER PARTITION to alter the partition boundaries.
  2. Use the REORG utility with inline statistics on the partitions that are affected by the change in partition boundaries.
  3. Use the RUNSTATS utility on the indexes.
  4. Rebind the dependent packages and plans.