Clearing Partitions from a Partitioned Table

For example, truncate the partition date_202005 in the range partitioned table range_sales by specifying the partition name and update the global index.

ALTER TABLE range_sales TRUNCATE PARTITION date_202005 UPDATE GLOBAL INDEX;

Alternatively, truncate the partition corresponding to the partition value '2020-05-08' in the range partitioned table range_sales. Global indexes become invalid after this command is executed because the UPDATE GLOBAL INDEX clause is not used.

ALTER TABLE range_sales TRUNCATE PARTITION FOR ('2020-05-08');