Help Center/ GaussDB/ Distributed_8.x/ Partitioned Table/ Partitioned Table O&M Management/ MOVE PARTITION
Updated on 2024-06-07 GMT+08:00
View PDF

MOVE PARTITION

You can run this command to move a partition to a new tablespace. You can move a partition by specifying the partition name or partition value.

You can use ALTER TABLE MOVE PARTITION to move partitions in a partitioned table.

For example, move the partition date_202001 from the range partitioned table range_sales to the tablespace tb1 by specifying the partition name. 
ALTER TABLE range_sales MOVE PARTITION date_202001 TABLESPACE tb1;
Alternatively, move the partition corresponding to '0' in the list partitioned table list_sales to the tablespace tb1 by specifying a partition value. 
ALTER TABLE list_sales MOVE PARTITION FOR ('0') TABLESPACE tb1;