I've a table with Daily Partitions with few million rows. I would like to roll off the old partitions as the new one comes in (14 days window).
How do I drop the old partitions? I've created the partitions till year 2011. Currently my worry is to just write a script to drop the old partitions.
I've done oracle partitions and it seems SQL partitions looks complicated to me with partition functions and schemas.
Any help appreciated.