Materialized view refresh fails

From: Ragnar Hark <rr.xx_at_mail.ee>
Date: Mon, 25 Nov 2002 18:46:15 +0200
Message-ID: <artk3d$sk0$1@kadri.ut.ee>

Hei all !

After upgrade from 9.0.1.0 to 9.2.0.2 fast refresh stop working on some tables, full refresh working fine. before upgrade everything works fine.

Master database Oracle 8.1.7.3
Operating system Tru64 UNIX 5.1A
Character set WE8ISO8859P1

Materialized view site
SuSe Linux 8.0, 2.4.18 kernel and
RDBMS 9.2.0.2
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

Thanks,
Ragnar Received on Mon Nov 25 2002 - 10:46:15 CST