ADD PARTITION

Adds one or more partitions to a partitioned table. If the specified table is not a partitioned table, an error is returned. The number of partitions must not exceed 256.

Changing the number of hash partitions in a partitioned table that contains data will require data movement between the data partitions.

partition-name
Names the partition. A partition-name must not identify a data partition that already exists in the table.

If the clause is not specified, a unique partition name is generated by the database manager.

boundary-spec
Specifies the boundaries of a range partition. If the specified table is not a range partitioned table, an error is returned. See CREATE TABLE for a description of the boundary-spec.

integer HASH PARTITIONS
Specifies the number of hash partitions to be added. If the specified table is not a hash partitioned table, an error is returned.