Home » Server Options » Text & interMedia » end-of-file on communication channel while executing the query with CONTAINS
end-of-file on communication channel while executing the query with CONTAINS [message #133849] Mon, 22 August 2005 07:19
akshatha
Messages: 1
Registered: August 2005
Location: Bangalore
Junior Member
Hi,

I have a problem while executing the query.
it gives

-2147217900 : ORA-03113: end-of-file on communication channel
OraOLEDB


I am using 'Oracle9i Enterprise Edition Release 9.2.0.1.0 '

But here very strange thing is happening. I have 2 got UNIONs here.

select .,. from <table> where contains (..) or contains (..) or contains (..) or contains (..)
union
select .,. from <table> where contains (..) or contains (..) or contains (..) or contains (..)
union
select .,. from <table> where contains (..) or contains (..) or contains (..) or contains (..)

The above query willl work fine.

I thought i would move Contains outside and put common Contains to optimise the query .

it is like
select ...... from (
select .,. from <table>
union
select .,. from <table>
union
select .,. from <table>
) where contains (..) or contains (..) or contains (..) or contains (..) or contains (..)

This will the error 'end of communication channel' error.

One more strange thing I could see is

select ...... from (
select .,. from <table>
union
select .,. from <table>
union
select .,. from <table>
) where contains (..) or contains (..)

If I limit my search for 2 conditions with CONTAINS it works fine.

Can anyone help me on this. COrrect me if my approach is wrong.
How can optimise this query?
Does MULTI COLUMN INDEX will help me on this... I am using 3 tables here for my search.

Thanks in advance
Previous Topic: DetailDatastore
Next Topic: Oracle Text - creating index case [b]in[/b]sensitive
Goto Forum:
  


Current Time: Thu Mar 28 09:14:54 CDT 2024