Re: Replication for datawarehouse

Posted by ErmanArslansOracleBlog on Sep 11, 2018; 8:02am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Replication-for-datawarehouse-tp6664p6687.html

Didn't you configured your partitions to be monthly?
How are they configured?

if they are already configured your partitions monthly, then you don't need to do anything. You will export your last 2 partitions and you are ok.

If you don't have that partitioning configuration, then you can use expdp's "QUERY" parameter.