设为首页 加入收藏

TOP

ORA-07445[mdagun_iter+957]WhenUsingSDO_AGGR_UNION问题处理(三)
2015-07-24 12:15:14 来源: 作者: 【 】 浏览:114
Tags:ORA-07445 mdagun_iter 957 WhenUsingSDO_AGGR_UNION 问题 处理
ent applies to any platform.
SYMPTOMS

Calling sdo_aggr_union(SDOAGGRTYPE(geoloc,0.05)) fails with following error-

ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [mdagun_iter+957] [PC:0x34BF5B3] [ADDR:0x4] [UNABLE_TO_READ] []

----CAUSE

The ORA-7445 error is most likely caused due to the invalid data in the table. To check this run -

SQL> select rowid, sdo_geom.validate_geometry_with_context(a.geoloc, .05) from test_case a;

All valid geometries should return "TRUE".

-----SOLUTION

If there are any invalid geometries in the table then manually fix them and make sure they are valid. If the invalid geometry is not needed anymore then it can be manually removed, e.g.-

SQL> delete from test_case where rowid='AAAXYgAAFAAAFzsAAA';
SQL> commit;

Now sdo_aggr_union query should work fine -

SQL> select sdo_aggr_union(SDOAGGRTYPE(geoloc,0.05)) geoloc from test_case;

首页 上一页 1 2 3 4 下一页 尾页 3/4/4
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇Oracle11g对依赖的判断达到字段级 下一篇【Oracle】使用bbed恢复update的..

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: