You can add a new partition to an existing partition design using the ALTER TABLE command. If the original partition design included subpartitions defined by a subpartition template, then the newly added partition will also be subpartitioned according to that template. For example:

ALTER TABLE sales ADD PARTITION

START (date '2009-02-01') INCLUSIVE

END (date '2009-03-01') EXCLUSIVE;

If a subpartition template was not used when you created the table, you would then define subpartitions when adding a new partition:

ALTER TABLE sales ADD PARTITION

START (date '2009-02-01') INCLUSIVE

END (date '2009-03-01') EXCLUSIVE

( SUBPARTITION usa VALUES ('usa'),

SUBPARTITION asia VALUES ('asia'),

SUBPARTITION europe VALUES ('europe') );

If you want to add a new subpartition to an existing partition, you can specify a particular partition to alter. For example:

ALTER TABLE sales ALTER PARTITION FOR (RANK(12))

ADD PARTITION africa VALUES ('africa');

Note: You cannot add a new partition to a partition design that has a default partition. You must split the default partition in order to add a new partition.