Re: Materialized view refresh fails

From: Frank <fvanbortel_at_netscape.net>
Date: Mon, 25 Nov 2002 20:56:34 +0100
Message-ID: <3DE28072.9010805@netscape.net>

Sybrand Bakker wrote:

> 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

Hmmm, could be an UTF8 vs ISO Latin-1 issue. If there's a "special"latin-1 character in a varchar2(20 column (e.g.), and that column has 20 characters, UTF8 might need 21, or 22, or... More than the column allows anyway, hence the ORA-01438.

Bad idea UTF8, when your design is perfect. If design allows for slack, UTF8 might be a solution. See above.

Grtz, Frank Received on Mon Nov 25 2002 - 13:56:34 CST