Help Center/ GaussDB/ Feature Guide(Centralized_8.x)/ Partitioned Table/ Partitioned Table O&M Management/ MOVE PARTITION/ Moving Partitions for a Partitioned Table
Updated on 2024-06-07 GMT+08:00
View PDF
Share

Moving Partitions for a Partitioned Table

You can run 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;
Parent topic: MOVE PARTITION