Advanced Server Oracle Compatibility Developer's Guide
12.11 ALTER TABLE… MOVE PARTITION
Use the ALTER TABLE… MOVE PARTITION command to move a partition to a different tablespace. Two forms of the command are supported; the syntax is:
This command makes no distinctions between a partition and a subpartition:
● You can move a partition with the MOVE PARTITION or MOVE SUBPARTITION clause.
● You can move a subpartition with MOVE PARTITION or MOVE SUBPARTITION clause.
You must own a table to invoke ALTER TABLE… MOVE PARTITION or ALTER TABLE… MOVE SUBPARTITION against that table.
The name (optionally schema-qualified) of the table in which the partition resides.
The name of the partition or subpartition to be renamed.
The name of the tablespace to which the partition or subpartition will be moved.
The following command moves the 4th_quarter partition of the sales table into a tablespace named active_sales: