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

LSX-00150: attributeGroup reference shouldn't have children

1 Answers  


IMG-00553: invalid rotate value

1 Answers  


ORA-31426: cannot modify active subscriptions

1 Answers  


ORA-01195: online backup of file string needs more recovery to be consistent

1 Answers  


LSX-00342: value of attribute "base" must be a complex type definition

1 Answers  






RMAN-06230: List of Stored Scripts in Recovery Catalog

1 Answers  


ORA-38442: The ADT "string" is not in a valid state.

1 Answers  


ORA-26680: object type not supported

1 Answers  


ORA-13616: The current user string has not been granted the ADVISOR privilege.

1 Answers  


NPL-00308: requested ASN.1 class string does not match received class string

1 Answers  


ORA-31029: Cannot bind to unsaved resource

1 Answers  


RMAN-10037: RPC anomaly detected on channel string, upinblt=number

1 Answers  


Categories