ORA 3113 : Weird Problem

From: <nilendu_at_my-deja.com>
Date: Wed, 02 Jun 1999 20:43:28 GMT
Message-ID: <7j451e$t12$1@nnrp1.deja.com>

Hi All,
I have a view which SELECTs on six tables based on some complex user requirements.
Now the problem is whenever I say:
'SELECT * FROM VIEW'
or,
"SELECT COUNT(*) FROM VIEW"
My query fails giving me

"ORA-03113: end-of-file on communication channel" error.

But say, time is a field on that view,
if I give "SELECT COUNT(TIME) FROM VIEW" or "SELECT TIME FROM THAT VIEW"

-it works,though it is much slow.

And this happens in my production database. But on my development database
with exactly the same set of objects I don't get any error on this. THis is kind of weird,and I contacted Oracle Support also.They are yet to
offer anything.Could anyone among us drop a possible hint behind this thing?
I am using Oracle 8i on WIn NT 4 (SP 4) ~Nilendu

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 02 1999 - 15:43:28 CDT