Re: Oracle Partition Maitenance automation

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 Thomas
Database Designer and Administrator
https://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.
>
> TIA
> Sanjay
>

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