Updated on 2024-05-20 GMT+08:00

Clearing Partitions from a Level-2 Partitioned Table

You can run ALTER TABLE TRUNCATE PARTITION to clear a partition in a level-2 partitioned table. The database clears all level-2 partitions under the partition.

For example, truncate the partition date_202005 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 PARTITION date_202005 UPDATE GLOBAL INDEX;
Alternatively, truncate a partition corresponding to the partition value ('2020-05-08') 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 PARTITION FOR ('2020-05-08');