Home » Server Options » Text & interMedia » Query on Index does not return any results.
Query on Index does not return any results. [message #128351] Mon, 18 July 2005 02:35 Go to next message
abhijeets
Messages: 1
Registered: July 2005
Location: Pune
Junior Member
Dear All

I am facing one problem related to oracle index.
We have oracle 9.2.0.1.0 database running on linux(Red Hat Enterprise Linux ES release 2.1 ) at client side
and running on windows 2000 at our end.

We have column Data(data type is BLOB) in Table pmc_largedata
where we are storing all types of files(pdfs,docs,xls etc.) in binary format.

For searching in this column I have created index

create index file_search_cindx on PMC_LARGEDATA(Data)
indextype is ctxsys.context
parameters ('filter ctxsys.inso_filter')

I am able to create index successfully on our database as well as client's database.

SELECT itemid, score(1) FROM PMC_LARGEDATA WHERE CONTAINS(DATA, 'UPS', 1) > 0 ORDER BY 2 DESC;

The above query does not give me any results for client's database.
but for our database which is same as the client's returns results.

Please guide me in resolving this problem.

With Regards

Abhijeet S

Re: Query on Index does not return any results. [message #133661 is a reply to message #128351] Sat, 20 August 2005 23:41 Go to previous message
rhardman
Messages: 25
Registered: April 2005
Junior Member
Check the DR$..$I table (token_text column) to see if any tokens were generated at all.
Previous Topic: Faster creation of Context index
Next Topic: DetailDatastore
Goto Forum:
  


Current Time: Thu Mar 28 03:15:10 CDT 2024