物化视图可以参考

http://space.itpub.net/519536/viewspace-563084

每隔五分钟刷新一次数据（SYSDATE NEXT SYSDATE + 1/248 ）。

DROP MATERIALIZED VIEW LOG ON emp;

DROP MATERIALIZED VIEW mv_emp_pk;

CREATE MATERIALIZED VIEW LOG ON emp;

CREATE MATERIALIZED VIEW MV_EMP_PK
REFRESH FAST ON DEMAND
START WITH SYSDATE NEXT SYSDATE + 1/248
AS
SELECT "EMP"."EMPNO" "EMPNO","EMP"."ENAME" "ENAME","EMP"."JOB" "JOB","EMP"."MGR" "MGR","EMP"."HIREDATE" "HIREDATE","EMP"."SAL" "SAL","EMP"."COMM" "COMM","EMP"."DEPTNO" "DEPTNO" FROM "EMP" "EMP";

SQL> select * from mlog$_emp;

EMPNO SNAPTIME$$ DMLTYPE$$ OLD_NEW$$ CHANGE_VECTOR$$
----- ----------- --------- --------- --------------------------------------------------------------------------------
7124 4000-1-1 D O 0000
0 4000-1-1 I N FEFF
3333 4000-1-1 I N FEFF

SQL> exec dbms_refresh.refresh('"ORACLE"."MV_EMP_PK"');

PL/SQL procedure successfully completed

SQL> select * from mlog$_emp;

EMPNO SNAPTIME$$ DMLTYPE$$ OLD_NEW$$ CHANGE_VECTOR$$
----- ----------- --------- --------- --------------------------------------------------------------------------------

SQL>

[@more@]

ITPub博客

物化视图

最新文章