Clearing Level-2 Partitions from a Level-2 Partitioned Table

For example, truncate the level-2 partition date_202005_channel1 in the level-2 partitioned table range_list_sales by specifying the partition name and update the global index.

ALTER TABLE range_list_sales TRUNCATE SUBPARTITION date_202005_channel1 UPDATE GLOBAL INDEX;

Alternatively, truncate a level-2 partition corresponding to the partition value ('2020-05-08', '0') in the level-2 partitioned table range_list_sales. Global indexes become invalid after this command is executed because the UPDATE GLOBAL INDEX clause is not used.

ALTER TABLE range_list_sales TRUNCATE SUBPARTITION FOR ('2020-05-08', '0');