ORA-30352: inconsistent numeric precision

admin

ORA-30352: inconsistent numeric precision or string length
Cause: The SELECT expressionwas of a different numeric precision or string
length than the corresponding container column. Therefore, query rewrite cannot
guarantee results that are identical to the results obtained with theun-rewritten
query.
Action: Correct the precisionor string length difference, specify the WITH
REDUCED PRECISION option, or disable the REWRITE option on the
materialized view.