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:
- Use the SQL statement ALTER TABLE ALTER PARTITION to alter the partition boundaries.
- Use the REORG utility with inline statistics on the partitions that are affected by the change in partition boundaries.
- Use the RUNSTATS utility on the indexes.
- Rebind the dependent packages and plans.