DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

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

  1. 07-23-2003, 02:22 AM #1
    balajiyes
    balajiyes is offline Advisor
    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.
    Reply With Quote Reply With Quote
  2. 07-23-2003, 07:16 AM #2
    rotem_fo
    rotem_fo is offline Hangin Around,,,
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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