物化视图 materialized views

admin

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;