ALTER PARTITION

Alters the boundaries of a partition of a range partitioned table. If the specified table is not a range partitioned table, an error is returned.

Changing the boundaries of one or more partitions of a table that contains data may require data movement between the data partitions. All existing data in the table must be assignable to the specified range partitions.

partition-name
Specifies the name of the partition to alter. The partition-name must identify a data partition that exists in the table.
boundary-spec
Specifies the new boundaries of a range partition. See CREATE TABLE for a description of the boundary-spec.