New answers tagged indexed-view
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=>'C',atomic_refresh=>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.
Top 50 recent answers are included