Example: Moving a partition to a different tablespace v16
This following example moves a partition of the sales
table from one tablespace to another.
Create the sales
table with the command:
Querying the ALL_TAB_PARTITIONS
view confirms that the partitions reside on the expected servers and tablespaces:
After preparing the target tablespace, invoke the ALTER TABLE… MOVE PARTITION
command to move the q1_2013
partition from a tablespace named ts_2
to a tablespace named ts_3
:
Querying the ALL_TAB_PARTITIONS
view shows that the move was successful: