Oracle 10g ora-07445 ora-600
警告日志如下:
我来答
添加附件
收藏
复制链接
微信扫码分享

在小程序上查看
分享
添加附件
问题补充
4条回答
默认
最新
Bug 10052141 - ORA-7445 / ORA-600 for columns with invalid number content (Doc ID 10052141.8)
Description
Various dumps or ORA-600 errors can occur if a source table for a DML operation contains invalid number data, especially if the data is converted to a different datatype for the destination. This fix tries to prevent invalid numbers from causing various dumps / ORA-600 errors and instead cause user errors such as ORA-12899 (value too large for column) type errors. Workaround The real problem is the bad data in the NUMBER column/s so correct the data in the source column. Often problem number data can be found using a select of the form: select rowid, dump(num_col) from suspect_table where num_col!=num_col/1;复制


打赏 0
回答交流
Markdown
一级标题
二级标题
三级标题
四级标题
五级标题
六级标题
添加图片链接
上传图片
导航目录
Markdown语法参考
请输入正文
提示
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
