Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Materialized view refresh fails
On Mon, 25 Nov 2002 18:46:15 +0200, "Ragnar Hark" <rr.xx_at_mail.ee>
wrote:
>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
>
>
Obvious solution would be to drop and recreate the associated snapshot log.
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Mon Nov 25 2002 - 12:02:07 CST