ORA-30352: inconsistent numeric precision or string length

ORA-30352: inconsistent numeric precision or string length
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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-30352：不一致的数字精度或字符串长度,
.原因： SELECT表达式具有与对应的容器列不同的数字精度或字符串长度。因此，查询重写不能保证与使用未重写查询获得的结果相同的结果。,
.操作：更正精度或字符串长度差异，指定WITH REDUCED PRECISION选项，或禁用物化视图上的REWRITE选项。,
.

aiaiDBA

13718043309

010-86462881

ORA-30352: inconsistent numeric precision or string length

1 个回答

相似问题