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');