There are 2 Materialized views to be refreshed. "Mview B" is dependent on "Mview A", In other Words Mview B queries/retreives data from Mview A.
"Mview A" is scheduled to refresh @ 5.00 PM in the evening and "Mview B" @ 6 in the evening. At times "Mview A" doesnt gets refreshed before 6 PM. But however "Mview B" starts to refresh by 6 PM, if that happens the data retreived by Mview B will not be correct and consistent. Here how do we ensure that "Mview B" starts to refresh only after "Mview A" refresh is Over. How do we enforce a dependency on Mview B or check on Mview B that it should refresh only after Mview A is fully refreshed.
Thanks in advance.