Materialized view refresh fails
Hei all !
After upgrade from 126.96.36.199 to 188.8.131.52 fast refresh stop
working on some tables, full refresh working fine.
before upgrade everything works fine.
Master database Oracle 184.108.40.206
Operating system Tru64 UNIX 5.1A
Character set WE8ISO8859P1
Materialized view site
SuSe Linux 8.0, 2.4.18 kernel and
Character set UTF8
It produce error:
ORA-12012: error on auto execute of job 102
ORA-12008: error in materialized view refresh path
ORA-01438: value larger than specified precision allows for this column
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 851
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
Click Here to Expand Forum to Full Width