Truncating Multiple Partitions

You can truncate multiple partitions from a range or list partitioned table with the TRUNCATE PARTITION clause of the ALTER TABLE statement. The corresponding partitions of local indexes are truncated in the operation. Global indexes must be rebuilt unless UPDATE INDEXES is specified.For example, the following SQL statement truncates multiple partitions in the range-partitioned sales table.

ALTER TABLE sales TRUNCATE PARTITIONS sales_q1_2008, sales_q2_2008, 
     sales_q3_2008, sales_q4_2008;