Tue Jul 02 19:09:11 2019
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x0] [PC:0x77ABC73, qcsfclscm()+113]
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_3492.trc (incident=299431):
ORA-07445: 出现异常错误: 核心转储 [qcsfclscm()+113] [ACCESS_VIOLATION] [ADDR:0x0] [PC:0x77ABC73] [UNABLE_TO_READ] []
Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_299431\orcl_ora_3492_i299431.trc
Tue Jul 02 19:09:12 2019
Trace dumping is performing id=[cdmp_20190702190912]
Tue Jul 02 19:09:14 2019
Sweep Incident[299431]: completed
别的都非常正常,只是在查一个语句的时候会报错
select
(id_stuf_id||'='||to_char(id_date,'yyyy-mm-dd'))id
,sum(id_amount) as dd_amount
from indent_detail d
left join indent_main m on id_im_id=im_id
left join stuff c on id_stuf_id=stuf_id
left join supplier c on stuf_comp_id=comp_id
where 1=1
and id_date between to_date('2019-07-01 00:00:00','YYYY-MM-DD HH24:MI:SS') and to_date('2019-07-01 23:59:59','YYYY-MM-DD HH24:MI:SS')group by id_stuf_id,to_char(id_date,'yyyy-mm-dd')
<p>数据库文件损坏。。。</p>
我在用11g的时候window下极易出现这样的情况。
建议用linux系统。
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。