Updated on 2024-06-07 GMT+08:00

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;