I had multiple tables with all Interval Partitioned on Date with weekly
partition. I need to keep 1yr of data and archive after a year. Do we have a
method to archive old partition by exchanging the partition with another table
or an equivalent approach? Each table has both Local and Global Mixed indexes.