hi, I have started to explore the use of the Oracle context search,
I have the following table which has a blob field,
I did the following search and was able to search out the documents required
(the table name is contextsearchdms)
1) select * from contextsearchdms where DBMS_LOB.INSTR(FILE_DATA, UTL_RAW.CAST_TO_RAW('Court'), 1, 1) > 0;
This is pretty much brute force search where I did a cast_to_raw of the search key,
I got 25 records found.
2) I followed the literature and created the following index for the Oracle Context Search
CREATE INDEX pdm_pdf_inx on contextsearchdms(FILE_DATA) INDEXTYPE IS CTXSYS.CONTEXT;
EXEC DBMS_STATS.GATHER_TABLE_STATS(USER, 'contextsearchdms', cascade=>TRUE);
3) But the following SQL
SELECT * FROM CONTEXTSEARCHDMS WHERE CONTAINS (FILE_DATA, 'COURT') > 0;
would yield 0 records found.
Would anyone has done similar implementation of the Context Search be wiling to share experience?
Anything else would I need to try to get the context search working?