Iam getting this error when i create Materialized View.
ORA-01438: value larger than specified precision allows
Which version of Oracle are you using ?
Oracle announced that this is bug 2642891/2547290 it was supposed to be fixed in 126.96.36.199
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 (...)
It is better to ask and appear ignorant, than to remain silent and remain ignorant.
Oracle OCP DBA 9i,
C++, Java developer