Re: Oracle Partition Maitenance automation

 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_at_gmail.com> 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_at_freelists.org> 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   

--
http://www.freelists.org/webpage/oracle-l