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)
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.
