Oracle Context Search


    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


    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?