From 12c, you can truncate partitions from a referenced partition with cascade option.
The following is the test case.
Create table EMPLOYEE ( EMPLOYEE_ID number primary key, EMPLOYEE_NAME varchar(25), JOINING_DATE date) PARTITION BY RANGE (JOINING_DATE)( PARTITION P_2013_06 VALUES LESS THAN (to_date(’30-06-2013′,’dd-mm-yyyy’)) NOCOMPRESS, PARTITION P_2013_07 VALUES LESS THAN (to_date(’31-07-2013′,’dd-mm-yyyy’)) NOCOMPRESS, PARTITION P_2013_08 VALUES LESS THAN (to_date(’31-08-2013′,’dd-mm-yyyy’)) […]
Follow Me!!!