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

PLS-00598: comparison of object with NULL using "string" is not allowed

1 Answers  


SQL*Loader-00500: Unable to open file (string)

1 Answers  


ORA-19588: %s recid string stamp string is no longer valid

1 Answers  


RMAN-08041: partial resync skipped, controlfile is not current or backup

1 Answers  


EXP-00050: Cannot perform Partition Export "string" on non-partitioned table "string"

1 Answers  






ORA-22977: missing or invalid attribute

1 Answers  


ORA-32404: snapshot log uses Change Data Capture which is not enabled for this database

1 Answers  


RMAN-08046: channel string: starting compressed full datafile backupset

1 Answers  


ORA-12036: updatable materialized view log is not empty, refresh materialized view

1 Answers  


ORA-03128: connection is in blocking mode

1 Answers  


DRG-50852: failed to turn SQL trace on

1 Answers  


SQL*Loader-00109: Invalid number of logical records to skip

1 Answers  


Categories