Help Center/ GaussDB/ Distributed_3.x/ Partitioned Table/ Partitioned Table O&M Management/ ADD PARTITION/ Adding a Partition to a Range Partitioned Table
Updated on 2024-05-20 GMT+08:00
View PDF

Adding a Partition to a Range Partitioned Table

You can run ALTER TABLE ADD PARTITION to add a partition to the end of an existing partitioned table. The upper boundary of the new partition must be greater than that of the last partition.

For example, add a partition to the range partitioned table range_sales. 
ALTER TABLE range_sales ADD PARTITION date_202005 VALUES LESS THAN ('2020-06-01') TABLESPACE tb1;

If a range partitioned table has the MAXVALUE partition, partitions cannot be added. You can run the ALTER TABLE SPLIT PARTITION command to split partitions. Partition splitting is also applicable to the scenario where partitions need to be added before or in the middle of an existing partitioned table. For details, see Splitting a Partition for a Range Partitioned Table.

Parent topic: ADD PARTITION