Add Partitions to a Partitioned Table

You can add partitions to list- or range-partitioned tables, but you cannot add partitions to a hash- or round-robin–partitioned table.

This example adds a new partition to a range-partitioned table using the existing partition-key column:

alter table titles add partition 
(vbigsales values <= (40000) on seg4)

Note: You can add partitions only to the high end of existing range-based partitions. If you have defined values <= (MAX) on a partition, you cannot add new partitions.

Adding a partition to list- or range-partitioned tables does not involve a data copy. The newly created partition is empty.