Errors in file /lbc/lionrdb/app/product/diag/rdbms/cnlionrdb/lionrdb02/trace/lionrdb02_j000_242326.trc:
ORA-12012: error on auto execute of job 3964
ORA-12008: error in materialized view refresh path
ORA-12899: value too large for column "FLUSR"."OVERDUE_COLLECT_VIEW"."MCR_CST_TYPE_CD" (actual: 2, maximum: 1)
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2809
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3025
ORA-06512: at "SYS.DBMS_IREFRESH", line 689
ORA-06512: at "SYS.DBMS_REFRESH", line 195
在alert中报出以上报错，主要是由于物化视图的基表变更字段长度造成的，我的数据库版本是11g，不能在刷新时候同步字段长度，必须删除物化视图，并重建才可以。