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.