首页新闻找找看学习计划

物化视图同步数据后,出现红叉

0
[已关闭问题] 关闭于 2017-11-19 16:54
复制代码
CREATE MATERIALIZED VIEW MV_SYS_OFFICE
REFRESH FORCE
ON DEMAND START
WITH SYSDATE NEXT TRUNC(SYSDATE,'MI')+1/24/60 AS SELECT "SYS_OFFICE"."ID" "ID","SYS_OFFICE"."PARENT_ID" "PARENT_ID","SYS_OFFICE"."PARENT_IDS" "PARENT_IDS","SYS_OFFICE"."NAME" "NAME","SYS_OFFICE"."SORT" "SORT","SYS_OFFICE"."AREA_ID" "AREA_ID","SYS_OFFICE"."CODE" "CODE","SYS_OFFICE"."TYPE" "TYPE","SYS_OFFICE"."GRADE" "GRADE","SYS_OFFICE"."ADDRESS" "ADDRESS","SYS_OFFICE"."ZIP_CODE" "ZIP_CODE","SYS_OFFICE"."MASTER" "MASTER","SYS_OFFICE"."PHONE" "PHONE","SYS_OFFICE"."FAX" "FAX","SYS_OFFICE"."EMAIL" "EMAIL","SYS_OFFICE"."USEABLE" "USEABLE","SYS_OFFICE"."PRIMARY_PERSON" "PRIMARY_PERSON","SYS_OFFICE"."DEPUTY_PERSON" "DEPUTY_PERSON","SYS_OFFICE"."CREATE_BY" "CREATE_BY","SYS_OFFICE"."CREATE_DATE" "CREATE_DATE","SYS_OFFICE"."UPDATE_BY" "UPDATE_BY","SYS_OFFICE"."UPDATE_DATE" "UPDATE_DATE","SYS_OFFICE"."REMARKS" "REMARKS","SYS_OFFICE"."DEL_FLAG" "DEL_FLAG" FROM "UAMS"."SYS_OFFICE" "SYS_OFFICE";
复制代码

第一次创建的时候是没有红叉的,但是过了1分钟,物化视图去同步数据,就出现红叉了

 

谁知道这是怎么回事?

RENC的主页 RENC | 小虾三级 | 园豆:515
提问于:2017-11-03 11:24
< >
分享
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册