title: Partial refresh on Materialized View
body: <p>We have a table <code>TB_1</code> which has monthly and weekly data partitioned by monthly and weekly columns. We also have materialized view <code>MV_1</code> inherited from the table <code>TB_1</code>.</p>
  
  <p>We would like to refresh the materialized view by certain weekly or monthly basis.</p>
  
  <p>Not sure how we can filter out weekly or monthly changes from all the changes captured in the materialized log for partial refresh.</p>
  
  <p>Right now we are thinking to have a flag column in <code>TB_1</code>. By clearing the materialized log and updating the flag, We think we can achieve this.</p>
  
  <p>Is there anyway efficient way than the process for partial refresh on specific criteria? </p>