Postgres Plus 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:
ALTER TABLE table_name
MOVE PARTITION partition_name
TABLESPACE tablespace_name;
and
ALTER TABLE table_name
MOVE SUBPARTITION partition_name
TABLESPACE tablespace_name;
Description
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.
Parameters
table_name
The name (optionally schema-qualified) of the table in which the partition resides.
partition_name
The name of the partition or subpartition to be renamed.
tablespace_name
The name of the tablespace to which the partition or subpartition will be moved.
Example
The following command moves the 4th_quarter partition of the sales table into a tablespace named active_sales:
ALTER TABLE sales
MOVE PARTITION 4th_quarter
TABLESPACE active_sales;
