Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

QSM-01047: complex join back on non-MAV rewrite not allowed (string)

1 Answers  


ORA-14510: can specify VALIDATE INTO clause only for partitioned tables

1 Answers  


RMAN-06181: multiple channels require Enterprise Edition

1 Answers  


SQL*Loader-00626: Character set conversion buffer overflow.

1 Answers  


ORA-28239: no key provided

1 Answers  






ORA-23387: replication parallel push dequeue error

1 Answers  


SQL*Loader-00256: SORTED INDEXES option allowed only for direct path

1 Answers  


RMAN-06512: copy will be obsolete on date string

1 Answers  


ORA-39121: Table string can't be replaced, data will be skipped. Failing error is: string

1 Answers  


ORA-26017: global indexes not allowed for direct path load of table partition string

1 Answers  


DGM-16943: You must connect to instance "string" and issue the command again.

1 Answers  


NZE-29014: Maximum fragment length extension is incorrect.

1 Answers  






Categories