How to manage old table partitions
Hi all,
I would want to get some input on what's the best strategy in handling databases which have a lot of table partitions.
I have a database which uses range partitioning by date, so now I have tablespaces which dated back in 2010.
What is the good approach to housekeep these so I could reuse back all the spaces allocated to the old tablespaces instead of assigning new storage to the server.
One idea which I could think of is to export dump the DB and drop the old partitions.