Question

oracle执行聚合函数的查询报ORA-03113:通信通道的文件结束

select count(t.paymentid) from tpayment t where cstaid in
('32500FF1','32500FF6','32500FF8',
'32500FF9','FDD_3006','FDD_3017',
'YCZ00008','YCZ00011','-1')
and t.datetime between to_date('2010-10-30','yyyy-MM-dd') and to_date('2010-10-31','yyyy-MM-dd') oracle 9i

Answer 1

我觉源睁得。。你应该查陪郑查你的表，看里面是不芦裂颂是有数据库坏块了，我遇到过类似的情况以你这个句子来说select * from tpayment where paymentid)<0可能就能发现