SUBPARTITION subpartition_name VALUES LESS THAN (value[, value]...)[TABLESPACE tablespace_name] Description The ALTER TABLE...ADD SUBPARTITION command adds a subpartition to an existing subpartitioned partition.
7) Partition maintenance operations were reduced by: a) Not issuing a separate 'drop subpartition' statement for each subpartition in a partition, and instead mass dropping all of the subpartitions in a partition by issuing one 'drop partition' statement b) Not truncating a partition or subpartit...
A table group with theSHARDINGattribute set toADAPTIVErequires that the table to be added have the same partition definition and subpartition definition as existing tables in the table group, including the partitioning type, partition count, and partition value. The tables in the table group must b...
SUBPARTITION[subpartition_name ]VALUES LESS THAN (value[, value]...)[TABLESPACE tablespace_name] Description The ALTER TABLE...ADD PARTITION command adds a partition to an existing partitioned table. The number of defined partitions in a partitioned table is not limited. ...
RANGE-partitioned tables have the same number of referenced columns, the same number of partitions, and the same range definition. A table group with theSHARDINGattribute set toADAPTIVErequires that the table to be added have the same partition definition and subpartition definition as existing table...