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.

• 在上面的例子中，物化视图数据的第一个副本在创建时生成，以后每两天刷新一次.