Re: interMedia

select count(*) from ctx_user_pending

if this is > 0 then you need to synchronize your index. Either start ctxsrv (not recommended and not available as of 9i) or create a job which will do it regularly. The code for the job could be like this:

begin
  for idx in (select distinct pnd_index_name name from ctx_user_pending) loop    ctx_ddl.sync_index(idx.name);
 end loop;
end;

Your PDF files also can be of version newer than that supported by your version of the interMedia Text. And from your index DDL I see you didn't specify INSO_FILTER as document filter - if this is not your default filter, compressed PDF files will not be properly indexed.

--
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"acelestial" <acelestial_at_twp.cwellington.on.ca> wrote in message
news:trFu8.11538$EG2.65193067_at_radon.golden.net...


> Hi,

>

> I have a table with BLOB field.  I've created an index on the BLOB field

> using the ff.:

>

> create index tablename_idx on tablename(BLOBfield)

> indextype is ctxsys.context;

>

> I used the Oracle8i interMedia Text Query to display the result in an asp

> page.  The query is something like this:

>

> select id, blobfield, score(1)

> from tablename

> where contains ( BLOBfield, '%parameter%', 1) > 0;

>

> The problem is somehow some of the records/BLOB are not being index.  Is

> there any problem on the documents that I uploaded in the BLOB field or is

> it something else?  The documents that I'm uploading are usually PDF files.

>

> Thank you very much for the help.

>

> Regards,

> Arman

>

>

>