Thanks John. If anyone can share some code used in their environment is
appreciated.
RegardsSanjay
On Saturday, March 16, 2019, 12:42:59 PM EDT, John Thomas
<jt2354@xxxxxxxxx> wrote:
Sanjay,
Google Flashback Data Archive and you should have your answer. Failing that,
you should be able to write PL/SQL to do the partition exchange you described
yourself.
Not sure how much trouble global indexes will give you though UPDATE GLOBAL
INDEXES is an option for partition exchange.
Regards,
John ThomasDatabase Designer and Administratorhttps://oracleexpert.net
On Fri, 15 Mar 2019 at 03:09, Sanjay Mishra <dmarc-noreply@xxxxxxxxxxxxx> wrote:
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.
TIASanjay