-- 创建一个测试用的表T
USER@orcl>?create?table?t?(a?int,?b?varchar2(50),?constraint?pk_tprimary?key(a));
Table?created.
?
-- 创建对应的MV名为MVT
USER@orcl>?create?materialized?view?mvt?as?select?*?from?t;
Materialized?view?created.
?
-- 现在往表里面插入一些个数据
USER@orcl>?insert?into?t?select?rownum,?object_name?fromall_objects;
11449?rows?created.
?
USER@orcl>?commit;
Commit?complete.
?
-- 下面对mview做一次刷新看看
USER@orcl>?exec?dbms_mview.refresh('mvt');
PL/SQL?procedure?successfully?completed.
?
-- 创建MView Log
USER@orcl>?create?materialized?view?log?on?t;
Materialized?view?log?created.
?
-- 接下来就是进行快速刷新了
USER@orcl>?exec?dbms_mview.refresh('mvt',?'F');
PL/SQL?procedure?successfully?completed.

-- 含有PK的MView
USER@orcl>?desc?mlog$_t;
?Name? ? ? ? ? ? ? ? ?Null?? ??Type
?-------------------- -------- --------------
?A? ? ? ? ? ? ? ? ? ? ? ? ? ? ?NUMBER
?SNAPTIME$$? ? ? ? ? ? ? ? ? ??DATE
?DMLTYPE$$? ? ? ? ? ? ? ? ? ? ?VARCHAR2(1)
?OLD_NEW$$? ? ? ? ? ? ? ? ? ? ?VARCHAR2(1)
?CHANGE_VECTOR$$? ? ? ? ? ? ? ?RAW(255)

-- 在建立一个基于表T的MView MVT2
USER@orcl>?create?materialized?view?mvt2?as?select?*?from?t;
Materialized?view?created.
?
-- 先做一次刷新
USER@orcl>?exec?dbms_mview.refresh('mvt2');
PL/SQL?procedure?successfully?completed.
?
-- 现在对表T做一些修改
USER@orcl>?update?t?set?b=upper(b)?where?rownum<5;
?
4?rows?updated.
?
-- 现在看看MView Log的记录
USER@orcl>?select?*?from?mlog$_t;
?
?? ? ? ??A?SNAPTIME$$? ? ? ? ??D?O?CHANGE_VEC
---------- ------------------- - - ----------
?? ? ??936?4000-01-01?00:00:00?U?U?04
?? ? ??937?4000-01-01?00:00:00?U?U?04
?? ? ??938?4000-01-01?00:00:00?U?U?04
?? ? ??939?4000-01-01?00:00:00?U?U?04
?
-- 现在我们刷新MVT
USER@orcl>?exec?dbms_mview.refresh('mvt','f');
?
PL/SQL?procedure?successfully?completed.
?
-- 我们可以看到SNAPTIME$$时间变了
USER@orcl>?select?*?from?mlog$_t;
?
?? ? ? ??A?SNAPTIME$$? ? ?