This operation is essentially the same as described for "About Modifying List Partitions: Dropping Values", however, you use a
SUBPARTITION clause instead of the
PARTITION clause. For example, to remove a set of literal values in the value list for subpartition
q1_1999_southeast, use the following statement:
ALTER TABLE quarterly_regional_sales MODIFY SUBPARTITION q1_1999_southeast DROP VALUES ('KS');
For an interval-list composite partitioned table, you can only drop values from subpartitions of range partitions or interval partitions that have been created. To drop values from subpartitions of interval partitions that have not yet been created, you must modify the subpartition template.