oracle物化视图不会自动更新是怎么回事
如题:
为什么不会自动更新,我另一个就可以。
create materialized view GZLTJ_CT_WF_SYBB_MJ
refresh force on demand
start with to_date('28-06-2013 10:00:00', 'dd-mm-yyyy hh24:mi:ss') next sysdate+1/24
as
select XXXXXXXXXXXXXXXXXX from XXXXXXXXXXXXXX
where jg.mjjh = t1.mjbm(+)
and jg.mjjh = t2.mjbm(+)
and jg.mjjh = t3.mjbm(+)
and jg.mjjh = t4.mjbm(+)
and jg.mjjh = t5.mjbm(+)
and jg.mjjh = t6.mjbm(+)
and jg.mjjh = t7.mjbm(+)
and jg.mjjh = t8.mjbm(+)
and jg.mjjh = t9.mjbm(+)
and jg.mjjh = t10.mjbm(+)
and jg.mjjh = t11.mjbm(+)
and jg.mjjh = t12.mjbm(+)
and jg.mjjh = t13.mjbm(+)
and jg.mjjh = t14.mjbm(+)
and jg.mjjh = t15.mjbm(+)
and jg.mjjh = t16.mjbm(+)
and jg.mjjh = t17.mjbm(+)
and jg.jgbm =t17.FINERDEPARTMENT(+)
and jg.mjjh = t18.mjbm(+)
and jg.jgbm = t18.mjbm_bm(+)
and jg.mjjh = t19.mjbm(+)
and jg.jgbm = t19.mjbm_bm(+)
and jg.mjjh = t20.mjbm(+)
and jg.jgbm = t20.FINERDEPARTMENT(+)
and jg.mjjh = t21.mjbm(+)
and jg.jgbm = t21.mjbm_bm(+)
and jg.mjjh = t22.mjbm(+)