Example - Moving a Partition to a Different Tablespace v13
The following example moves a partition of the sales
table from one tablespace to another. First, 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.