RE: Interval Range Partitioning

From: Ravi Teja Bellamkonda <>
Date: Fri, 9 Mar 2018 10:29:02 -0800
Message-ID: <>

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 Oracle Database.

Any help is really appreciated.


Thanks & Regards,
Ravi Teja Bellamkonda
Ph: (816)-905-7577.

-- Received on Fri Mar 09 2018 - 19:29:02 CET

Original text of this message