About Modifying Real Attributes of Partitions

It is possible to modify attributes of an existing partition of a table or index.

You cannot change the TABLESPACE attribute. Use ALTER TABLE MOVE PARTITION/SUBPARTITION to move a partition or subpartition to a new tablespace.

This section contains the following topics:

• Modifying Real Attributes for a Range or List Partition

• Modifying Real Attributes for a Hash Partition

• Modifying Real Attributes of a Subpartition

• Modifying Real Attributes of Index Partitions