Yesterday, we discussed merging and splitting multiple partitions. The same feature is extended in 12c to add, drop or truncate multiple partitions in a single SQL statement.
Add multiple partitions example:
ALTER TABLE SALESDATA ADD
PARTITION S2015Q1 VALUES LESS THAN (TO_DATE('01-APR-15','DD-MON-YY')),
PARTITION S2015Q2 VALUES LESS THAN (TO_DATE('01-JUL-15','DD-MON-YY')),
PARTITION S2015Q3 VALUES LESS THAN (TO_DATE('01-OCT-15','DD-MON-YY')),
PARTITION S2015Q4 VALUES LESS THAN (TO_DATE('01-JAN-16','DD-MON-YY'));
Read more in Oracle Documentation
Truncate multiple partitions example:
ALTER TABLE SALESDATA TRUNCATE PARTITIONS S2001Q1, S2001Q2, S2001Q3, S2001Q4;
Read more in Oracle Documentation
Drop multiple partitions example:
ALTER TABLE SALESDATA DROP PARTITIONS S2001Q1, S2001Q2, S2001Q3, S2001Q4;
Read more in Oracle Documentation