SQL> CREATE MATERIALIZED VIEW mv_ emp_ pk REFRESH FAST START WITH SYSDATE NEXT SYSDATE+2 WITH PRIMARY KEY AS SELECT* FROM emp@ remote_ db; Materialized view created.

 
  • 在上面的例子中,物化视图数据的第一个副本在创建时生成,以后每两天刷新一次.
今日热词
目录 附录 查词历史