本文介绍了创建每5分钟刷新一次的实例化视图的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我创建了一个实例化视图,该视图每5分钟刷新一次,但是当我在实例化视图上插入并执行选择时,是否得到了相同的旧数据?我需要手动刷新吗?
I created a materialized view that refreshed every 5 min but when I do insert and perform select on materialized view I get same old data? Do I need to refresh manually?
CREATE MATERIALIZED VIEW MVW_TEST
REFRESH FORCE ON DEMAND
START WITH TO_DATE('01-01-2009 00:01:00', 'DD-MM-YYYY HH24:MI:SS') NEXT SYSDATE + 1/1152
As select * from TEST12
推荐答案
我已经演示了在每个one minute
之后,物化视图都会刷新的步骤,在5分钟后使用next(sysdate+5/1440)
I have demonstrated in steps where a materialized view refresh after every one minute
,for havinga mv which refresh after 5 minute use next(sysdate+5/1440)
第一步:
Create table temp (A int);
第二步:
Create Materialized view temp_mv
refresh complete start with (sysdate) next (sysdate+1/1440) with rowid
as select * from temp;
第3步:
select count(*) from temp;
COUNT(*)
----------
0
第四步:
select count(*) from temp_mv;
COUNT(*)
----------
0
第5步:
begin
for i in 1..10 loop
insert into temp values (i+1);
end loop;
end;
/
Step6:
commit;
Step7:
select count(*) from temp;
COUNT(*)
----------
10
Step8:
select count(*) from temp_mv;
COUNT(*)
----------
0
Step9:
select to_char(sysdate,'hh:mi') from dual;
TO_CH
-----
04:28
步骤10:
select to_char(sysdate,'hh:mi') from dual;
TO_CH
-----
04:29
Step11:
select count(*) from temp;
COUNT(*)
----------
10
Step12:
select count(*) from temp_mv;
COUNT(*)
----------
10
这篇关于创建每5分钟刷新一次的实例化视图的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!