Modifying Real Attributes for a Hash Partition

You also use the ALTER TABLE MODIFY PARTITION statement to modify attributes of a hash partition. However, because the physical attributes of individual hash partitions must all be the same (except for TABLESPACE), you are restricted to:

  • Allocating a new extent

  • Deallocating an unused extent

  • Marking a local index subpartition UNUSABLE

  • Rebuilding local index subpartitions that are marked UNUSABLE

The following example rebuilds any unusable local index partitions associated with hash partition p1 of the table:

ALTER TABLE departments_rebuild_index MODIFY PARTITION p1