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(+)
and jg.jgbm = t22.FINERDEPARTMENT(+)
and jg.mjjh = t23.mjbm(+)
and jg.jgbm = t23.mjbm_bm(+)
and jg.mjjh = t24.mjbm(+)
and jg.jgbm = t24.FINERDEPARTMENT(+)
and jg.mjjh = t25.mjbm(+)
and jg.jgbm = t25.FINERDEPARTMENT(+)
and jg.mjjh = t26.mjbm(+)
and jg.mjjh = t27.mjbm(+)
and jg.mjjh = t28.mjbm(+)
and jg.mjjh = t29.mjbm(+)
and jg.mjjh = t30.mjbm(+)
and jg.mjjh = t31.mjbm(+)
and jg.mjjh = t32.mjbm(+)
and jg.mjjh = t33.mjbm(+)
and jg.mjjh = t34.mjbm(+)
and jg.mjjh = t35.mjbm(+)
and jg.mjjh = t36.mjbm(+)
and jg.mjjh = t37.mjbm(+)
and jg.mjjh = t38.mjbm(+)
and jg.mjjh = t39.mjbm(+)
and jg.mjjh = t40.mjbm(+)
and jg.mjjh = t41.mjbm(+);
Oracle sql
[解决办法]
1）先看看有没有刷新：user_mview_refresh_times或user_mviews
2) 再尝试手动刷新试试
3）如果不行、贴上物化视图日志 
[解决办法]
检查下DBA_JOBS，看是否刷新失败。