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

NNL-00243: Processing of modification requests is now enabled

1 Answers  


ORA-14006: invalid partition name

1 Answers  


NNL-00020: warning: no TNSNAMES.ORA file and no preferred name servers in SQLNET.ORA

1 Answers  


TNS-01097: TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

1 Answers  


ORA-02478: merge into base segment would overflow MAXEXTENTS limit

1 Answers  






ORA-01261: Parameter string destination string cannot be translated

1 Answers  


IMG-00804: Syntax error in attribute string

1 Answers  


ORA-02826: Illegal block size

1 Answers  


ORA-01520: number of data files to add (string) exceeds limit of string

1 Answers  


ORA-30460: 'string.string' cannot be refreshed because it is marked UNUSABLE

1 Answers  


ORA-22805: cannot insert NULL object into object tables or nested tables

1 Answers  


PLS-00236: Invalid external type specification for string.

1 Answers  


Categories