Oracle Context Search

4295804

    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?