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.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.