Materialized view refresh fails
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Materialized view refresh fails

  1. #1
    Join Date
    Nov 2002
    Location
    Tallinn, Estonia
    Posts
    1

    Angry 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

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width