Refreshing Materialized Views (mv_refresh)

To upgrade from Oracle 11gR2 to Oracle 18c/19c, we need to refresh materialized views.

Oracle recommends that all materialized views (MV’s) are refreshed before upgrading the database because this will clear the MV logs and the sumdelta$ table, and make the UPGRADE process faster.

SQL> declare num_failures integer(3) :=0;
begin
DBMS_MVIEW.REFRESH_ALL_MVIEWS(num_failures,'C','', TRUE, FALSE);
end;
/


PL/SQL procedure successfully completed.

SQL> SQL> select count(1) from sumdelta$;

  COUNT(1)
----------
         0

Stay tuned for more articles on Oracle 19c 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp