Oracle Solution for Error ora-30352

ORA-30352: inconsistent numeric precision or string length

What triggered the Error:

The SELECT expression was 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 the un-rewritten query.

What should we do to fix it:

Correct the precision or string length difference, specify the WITH REDUCED PRECISION option, or disable the REWRITE option on the materialized view.