How to Drop/Truncate Partition
This thread is for discussion and questions about DROP and TRUNCATE Partition
General Advice:
Below documents will explain the steps required to DROP/TRUNCATE partition.
Tips for drop partition operation (Doc ID 1489462.1)
Common Questions About Dropping/Truncating Partition (Doc ID 1483661.1)
How To Drop The Interval Partitions? (Doc ID 1285036.1)
From 12c, You can remove multiple partitions or subpartitions. For more details, please refer
How to Drop/Truncate Multiple Partitions in Oracle 12C (Doc ID 1482264.1)
Reference:
Master Note for Partitioning (Doc ID 1312352.1)
Can a Single Partition be Truncated during Data Pump Import? (Doc ID 877792.1)
Common Questions on Indexes on Partitioned Table (Doc ID 1481609.1