Oracle Database Discussions

Hi,

I'm running Oracle Database 10g 10.2.0.1.0 standard edition one, on windows server 2003 R2 x64.

I have a table with a blob column which contains pdf document.

Then, I create an index using the following script so that I can do fulltext search using Oracle Text.

CREATE INDEX DMCS.T_DMCS_FILE_DF_FILE_IDX ON DMCS.T_DMCS_FILE
(DF_FILE)
INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS('DATASTORE CTXSYS.DEFAULT_DATASTORE');

However, the index is not searchable and I check the following tables created by database for my index and found them to be empty as well !!

DR$T_DMCS_FILE_DF_FILE_IDX$I
DR$T_DMCS_FILE_DF_FILE_IDX$K
DR$T_DMCS_FILE_DF_FILE_IDX$N
DR$T_DMCS_FILE_DF_FILE_IDX$R

I wonder what's wrong with it.

My user has been granted the ctx_app role and I have other tables that store plain text which I use Oracle Text are fine. I even output the blob column and save as pdf file and they are fine.

However the database seems like not indexing my blob column although the index can be created without error.

Please advise.

Really appreciate anyone who can help.
Thank you.