ORA-01438: value larger than specified precision allows
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01438: value larger than specified precision allows

  1. #1
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598

    ORA-01438: value larger than specified precision allows

    Hi all,
    Iam getting this error when i create Materialized View.

    ORA-01438: value larger than specified precision allows

    Thnx
    Rgds,
    Cheers!
    OraKid.

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    Which version of Oracle are you using ?

    Oracle announced that this is bug 2642891/2547290 it was supposed to be fixed in 9.2.0.2

    A simple workaround is simply do a storage re-org of that snapshot log at the master site.

    alter table mlog$_troublesome_table move tablespace storage (...)

    cheers.
    It is better to ask and appear ignorant, than to remain silent and remain ignorant.

    Oracle OCP DBA 9i,
    C++, Java developer

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