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

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 run the ALTER TABLE SPLIT PARTITION command to split partitions.