ORA-7445(_kkdlavc)错误

客户10.2.0.1 for Windows出现ORA-7445错误。
没有打过补丁的数据库出现问题的几率果然很大:

Thu Mar 29 15:11:50 2012
Errors IN file c:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_880.trc:
ORA-07445: 出现异常错误: 核心转储 [ACCESS_VIOLATION] [_kkdlavc+233] [PC:0x7F6661] [ADDR:0x0] [UNABLE_TO_READ] []

这个问题是由于访问了一个不正常的视图所致,解决方法就是重建视图。关于这个bug的描述可以参考文档ORA-07445 [kkdlavc()+284] When Performing Query Against a View。

This entry was posted in BUG and tagged , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *