RE: Interval Range Partitioning
Date: Fri, 9 Mar 2018 10:29:02 -0800
Message-ID: <CANRhLpBOU7c+aGpKRkANnMD7c-Ca1gKAwexn8PYJWH8PLzS3Yw_at_mail.gmail.com>
Hi List,
Probably this is a newbie question on Partitioning. I am planning on performing a Range - Interval Partitioning using a date column for archival purposes. One thing I observed is to enable row movement because the partitioning key can be updated and needs movement between partitions. Looking for any further *recommendations *on changes needed (similar to enabling row movement which I might have missed as this is the first time we are implementing Interval Range Partitioning) for supporting interval range partitioning.
Also can you please suggest on a better way to archive and purge tables which have parent child relationships between them. In my case, the above table is a child table and exchange partition is pretty straight forward which is not the case if the table is a parent.
We are using a 11.2.0.4 Oracle Database.
Any help is really appreciated.
--
Thanks & Regards,
Ravi Teja Bellamkonda
Ph: (816)-905-7577.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 09 2018 - 19:29:02 CET