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,不能在刷新时候同步字段长度,必须删除物化视图,并重建才可以。
标签:DBMS,12899,column,value,SYS,line,06512,ORA From: https://www.cnblogs.com/dbahrz/p/17769514.html