I am searching in google for a pl/sql script that will purge old partitions and insert a new partition based on the date. (ie. keep 24 months, each month insert a new partition and delete the old partition(24),
I have not found anything in google and thought maybe someone might have a similar script that I can use as a base.
Your help is greatly appreciated.