Problem with dropping materialized views and mv logs taking a long time (or never) to complete
You can do:

truncate table STAGING_OWNER.CONTRACT_SUMMARY_MV_FR ;


This simply will flush the MV. Then:

dbms_mview.refresh('STAGING_OWNER.CONTRACT_SUMMARY_MV_FR',method=&gt;'C',atomic_refresh=&gt;FALSE);


this will speed up mview rebuild. If you still experience any troubles you must trace event 10053 to understand why refresh is taking so much time.