ORACLE中的物化视图[2]

        sql> create materialized view mv_emp_pk

             refresh fast start with sysdate 

            next  sysdate + 1/48

            with primary key 

            as select * from emp@remote_db;

            materialized view created.

              注意：当用fast选项创建物化视图，必须创建基于主表的视图日志,如下:

            sql> create materialized view log on emp;

            materialized view log created.

2.rowid物化视图

              下面的语法在远程数据库表emp上创建rowid物化视图