修改物化視圖刷新方式
從完全刷新變為快速
ALTER MATERIALIZED VIEW WISON.ROWIDREADONLY1
REFRESH FAST
ON DEMAND
START WITH TO_DATE('26-10-2010 07:13:32','dd-mm-yyyy hh24:mi:ss')
NEXT SYSDATE + 10/1440
WITH ROWID;
從快速刷新變為Force刷新
ALTER MATERIALIZED VIEW WISON.ROWIDREADONLY1
REFRESH FORCE
ON DEMAND
START WITH TO_DATE('26-10-2010 07:13:32','dd-mm-yyyy hh24:mi:ss')
NEXT SYSDATE + 10/1440
WITH ROWID;
變為完全刷新方式類似
ALTER MATERIALIZED VIEW WISON.ROWIDREADONLY1
REFRESH COMPLETE
ON DEMAND
START WITH TO_DATE('26-10-2010 07:13:32','dd-mm-yyyy hh24:mi:ss')
NEXT SYSDATE + 10/1440
WITH ROWID;
完全刷新應該是將物化視圖truncate之後,再將數據同步.
ALTER MATERIALIZED VIEW WISON.ROWIDREADONLY1
REFRESH FAST
ON DEMAND
START WITH TO_DATE('26-10-2010 07:13:32','dd-mm-yyyy hh24:mi:ss')
NEXT SYSDATE + 10/1440
WITH ROWID;
從快速刷新變為Force刷新
ALTER MATERIALIZED VIEW WISON.ROWIDREADONLY1
REFRESH FORCE
ON DEMAND
START WITH TO_DATE('26-10-2010 07:13:32','dd-mm-yyyy hh24:mi:ss')
NEXT SYSDATE + 10/1440
WITH ROWID;
變為完全刷新方式類似
ALTER MATERIALIZED VIEW WISON.ROWIDREADONLY1
REFRESH COMPLETE
ON DEMAND
START WITH TO_DATE('26-10-2010 07:13:32','dd-mm-yyyy hh24:mi:ss')
NEXT SYSDATE + 10/1440
WITH ROWID;
完全刷新應該是將物化視圖truncate之後,再將數據同步.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25198367/viewspace-704225/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
取消物化視圖的註冊信息
下一篇：
創建預建物化視圖(源表包含PK)
请登录后发表评论
登录
全部评论
