Instead of using DBMS_MVIEW, you can automatically refresh the MVIEW (Snapshot) using Oracle DBMS_JOB Management. 3. Create the optimizer statistics and refresh the materialized view.

Let's remember: Oracle is in the database and tools business.Any business relationship that encourages a fast-growing vendor to use Oracle's tools and technology is a good thing for Oracle.