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,

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.