Updated on 2024-05-20 GMT+08:00

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;