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, no new partitions can be added.
Adding a partition to list- or range partitioned tables does not involve a data copy. The newly created partition is empty.
