Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Materialized view refresh fails

Re: Materialized view refresh fails

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Mon, 25 Nov 2002 19:02:07 +0100
Message-ID: <ubp4uuo08cel6553srghcj95vlejq7vprt@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US