修改物化视图刷新时间:
ALTER MATERIALIZED VIEW sales_by_month_by_state REFRESH NEXT SYSDATE+7;
修改刷新模式:
ALTER MATERIALIZED VIEW sales_by_month_by_state
REFRESH FAST;
修改物化视图刷新多个属性:
ALTER MATERIALIZED VIEW emp_data
REFRESH COMPLETE
START WITH TRUNC(SYSDATE+1) + 9/24
NEXT SYSDATE+7;
开启查询重写:
ALTER MATERIALIZED VIEW emp_data
ENABLE QUERY REWRITE;