Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Intermedia indexing

Re: Intermedia indexing

From: S P Arif Sahari Wibowo <arifsaha_at_yahoo.com>
Date: Fri, 19 Oct 2001 10:38:45 -0500
Message-ID: <Pine.LNX.4.33.0110191025410.15948-100000@macbeth.tirone.com>


On Fri, 19 Oct 2001, Vladimir M. Zakharychev wrote:

>Here are the answers to your questions (hope they are complete and
>helpful):

Thanks! Your explanations are helpful.

>1) This in normal behavior when a changed record drops out of the
>index - interMedia needs to reindex it because extent of changes are
>not known: it may be one word change or a different document put
>in place of old.

I knew that. But in this particular use, the changes usually small, and therefore it is more useful to have it still indexed by its old content than not at all. Apparently there is no way to do that.

>3) Yes. You can select from CTX_USER_PENDING view to see all
>records that are to be [re-]indexed.

Thanks! This is very useful!

I think from here I can use CTX_USER_INDEXES which table and column each indexes in CTX_USER_PENDING corresponding to. From there I can make the intermedia text query on that table and column includes the pending records. Therefore user still can found the record (probably with a note, "these may not be what you ask but they possibly are").

Do you know if the record in CTX_USER_PENDING will be there until the end of index rebuild or it will be removed as soon as the rebuild started?

>You may also start context server (ctxsrv) which will poll pending
>indexes for each user at regular intervals and reindex changed/new
>records in background. Read the documentation on how to start ctxsrv.

I knew that, but I want to avoid too much fragmentation. So I may resolve to scheduled index rebuild.

>4) Can't tell for sure, but this is probably possible, although with a lot of
>effort - you will have to extract all new interMedia Text files, put them
>in correct locations replacing old ones and then run sql scripts that will
>reinstall the database portion of the tool. Also note that new version of
>interMedia Text probably has some hooks with Oracle internals which may
>not be there in older version. So if you want your interMedia Text to be
>up to date, you better upgrade to 8.1.7 and then patch to 8.1.7.2.
>Besides, 8.1.6 is already desupported.

Ah, all the torture of upgrading... usually there are something stop working, or become less efficient, after upgrading. :-(

Thank you!

-- 
                                   S P Arif Sahari Wibowo
  _____  _____  _____  _____
 /____  /____/ /____/ /____          arifsaha_at_yahoo.com
_____/ /      /    / _____/       http://www.arifsaha.com/
Received on Fri Oct 19 2001 - 10:38:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US