ORACLE中的物化视图[3]

      sql> create materialized view mv_emp_rowid 

            refresh with rowid 

             as select * from emp@remote_db; 

            materialized view log created.

3.子查询物化视图

              下面的语法在远程数据库表emp上创建基于emp和dept表的子查询物化视图

            sql> create materialized view  mv_empdept

            as select * from emp@remote_db e

            where exists

             (select * from dept@remote_db d

             where e.dept_no = d.dept_no)

      materialized view log created.

       refresh 子句