PARTITION statement to modify existing attributes of a range partition or list partition. You can modify segment attributes (except
TABLESPACE), or you can allocate and deallocate extents, mark local index partitions
UNUSABLE, or rebuild local indexes that have been marked
If this is a range partition of a *-hash partitioned table, then note the following:
If you allocate or deallocate an extent, this action is performed for every subpartition of the specified partition.
Likewise, changing any other attributes results in corresponding changes to those attributes of all the subpartitions for that partition. The partition level default attributes are changed as well. To avoid changing attributes of existing subpartitions, use the
PARTITION clause of the
The following are some examples of modifying the real attributes of a partition.
This example modifies the
MAXEXTENTS storage attribute for the range partition
sales_q1 of table
ALTER TABLE sales MODIFY PARTITION sales_q1 STORAGE (MAXEXTENTS 10);
All of the local index subpartitions of partition
ts1 in range-hash partitioned table
scubagear are marked
UNUSABLE in the following example:
ALTER TABLE scubagear MODIFY PARTITION ts1 UNUSABLE LOCAL INDEXES;
For an interval-partitioned table you can only modify real attributes of range partitions or interval partitions that have been created.