CREATE MATERIALIZED VIEW "HR"."EMP_DEP_MV" REFRESH COMPLETE ON DEMAND ENABLE QUERY REWRITE AS select first_name, last_name, salary from hr.departments d, hr.employees e where e.department_id = d.department_id refresh: exec dbms_mview.refresh('emp_dep_mv', 'C');