Database Software

Hello,

I am trying to index a column in one of my tables that contains a BLOB object that is a PDF for each record. I want to create an index on that column so I can search through the contents of these PDFs.

I have tried several times to create the index using this sql command:

create index rep_index on report(report_binary)
indextype is ctxsys.context;

I have also tried it with severa other variations using the parameter list, but I believe that this way is sufficient because all the default options, as I understand them, are good enough for a search through PDFs.

The command did succeed in creating the index (or so it claims), but when I query using the contains method no pdfs are ever returned. Here is an example query after the index is created:

select score(1), report_id from report where contains(report_binary, 'the', 1) > 0 order by score(1) desc;

That and other similar queries never return anything!!

Is there some piece of the index creation specific to BLOBs that I am missing?

thanks for the help!

-- Joseph

Edited by: user12036946 on Oct 9, 2009 10:40 AM