Hello members,

We have created Materialized views in our project. For these MVs full refresh takes more than 8 hrs. So I searched internet for incremental refresh and found the details in this link


I am using Oracle 10g

As per the above link, we can refresh MV for updates in master table. My question is whether we can refresh with the updates in detail tables.

If there is any update in detail tables, will it get reflected for already loaded master records in MV?