假如物化视图名称:MV_T_HR_BMXX_NIRC
1.sql窗口里执行(没用过)
ALTER MATERIALIZED VIEW MV_T_HR_BMXX_NIRC REFRESH FAST
2.在plsql的命令窗口执行(不想用)
exec dbms_mview.refresh('MV_T_HR_BMXX_NIRC');
3.推荐
BEGIN
DBMS_MVIEW.REFRESH (
list => 'MV_T_HR_BMXX_NIRC',
Method =>'COMPLETE',
refresh_after_errors => True);
end;
参考: