Help Center/ GaussDB/ Feature Guide(Centralized_3.x)/ Partitioned Table/ Partitioned Table O&M Management/ ADD PARTITION/ Adding a Partition to a List Partitioned Table
Updated on 2024-05-20 GMT+08:00
View PDF
Share

Adding a Partition to a List Partitioned Table

You can run ALTER TABLE ADD PARTITION to add a partition to a list partitioned table. The enumerated values of the new partition cannot be the same as those of any existing partition.

For example, add a partition to the list partitioned table list_sales. 
ALTER TABLE list_sales ADD PARTITION channel5 VALUES ('X') TABLESPACE tb1;

If a list partitioned table has the DEFAULT partition, partitions cannot be added. You can use the ALTER TABLE SPLIT PARTITION statement to split partitions.

Parent topic: ADD PARTITION