Alternatively you can run context server and have it automatically
update your index. But it, too, is done asynchronously. As far as
your text being indexed inappropriately, if I remembered correctly
Oracle indexes an entire word, not pieces of a word. In other words,
if you look for text containing "test" you will find "this is a test"
but not "thisisatest". Could this be your problem?
Peter Sylvester <peters_at_mitre.org> wrote in message news:<3CBC2621.A1D1E6CA_at_mitre.org>...
> The intermedia text index is not synchronized with updates. You have to
> periodically alter index rebuild. Also, see ctx_ddl.sync_index().
>
> -Peter
>
> acelestial wrote:
> >
> > 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
Received on Fri Apr 26 2002 - 13:30:06 CDT
