| Query on Index does not return any results. [message #128351] |
Mon, 18 July 2005 02:35  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
