Oracle Partition Maitenance automation

From: Sanjay Mishra <"Sanjay>
Date: Fri, 15 Mar 2019 03:08:38 +0000 (UTC)
Message-ID: <863982933.4803640.1552619318841_at_mail.yahoo.com>

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

Received on Fri Mar 15 2019 - 04:08:38 CET

This message: [ Message body ]
Next message: Sanjay Mishra: "Oracle and Infomatica connection"
Previous message: Chinar Aliyev: "Re: Keep buffer cache question"
Next in thread: John Thomas: "Re: Oracle Partition Maitenance automation"
Reply: John Thomas: "Re: Oracle Partition Maitenance automation"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message