-
Materialized view refresh fails
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
-
I would bet this is your problem:
ORA-01438: value larger than specified precision allows for this column
Check that the local definition matches the remote definition.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|