I hope someone must have encountered this problem and have a workaround solution.

I am storing docs/pdf as BLOB in the database. I use Oracle Intermedia to search for words in these documents. To facilate this, I would have to re-index the BLOB column.

Intially I would upload around 3000 docs indexed to the BLOB. Each subsequent upload (insert) by the user would require re-indexing , taking up time.Is there a work around solution apart from re-indexing after each insert to facilate the search? How could I enable searching prior to upload.

Any advice/best practices is greatly appreciated.Thanks in advance!