RE: Interval Range Partitioning

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