ORA-30352: inconsistent numeric precision or string length



ORA-30352: inconsistent numeric precision or string length..

Answer / guest

Cause: 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.

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PROC-00005: User does not have permission to perform a cluster registry operation on this key.

1 Answers  


TNS-12585: TNS:data truncation

1 Answers  


ORA-01291: missing logfile

1 Answers  


ORA-09203: sfofi: error opening file

1 Answers  


ORA-00358: Too many file members specified, the maximum is string

1 Answers  






ORA-16232: adding Logical Standby skip entry for table string.string

1 Answers  


ORA-01935: missing user or role name

2 Answers  


CLSR-01008: Error number encountered during querying for PMON status

1 Answers  


ORA-24202: publisher does not exist for the queue

1 Answers  


QSM-02056: correlated variable and outer join in mv

1 Answers  


ORA-16016: archived log for thread string sequence# string unavailable

1 Answers  


ORA-09260: sigpidu: error obtaining process id

1 Answers  


Categories