Re: ORA 3113 : Weird Problem

Are all tables that comprise the view indexed and analyzed? I have experienced this error in the past when performing a join across a database link. The remote tables where not indexed/analyzed properly. Taking care of that solved the problem

In article <7j451e$t12$1_at_nnrp1.deja.com>,   nilendu_at_my-deja.com wrote:
> 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.
>

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