If you have used sensible partition names, then it would be easy.
for example if your partition for July 2003 is called "P2003_07" then you can perform ...
Code:begin execute immediate 'alter table my_table drop partition '|| to_char(add_months(sysdate,-4),'"P"YYYY"_"MM'); end; /




Reply With Quote