Re: synchronizing an index

As far as I know there is "alter index DBADMIN.DocumentIndex rebuild". But you cannot do the rebuild online which means that the base table is locked during that rebuild. This was a serious reason not to use the interMedia Text in our case but to build our own fault-tolerant search.

Martin

Tim Frith wrote:
>
> I've created an index for doing full-text searches with interMedia Text as
> follows:
> CREATE INDEX DBADMIN.DocumentIndex ON DBADMIN.FORMATTEDDOCUMENT(LOCATION)
> INDEXTYPE IS CTXSYS.CONTEXT
> PARAMETERS (' DATASTORE CTXSYS.URL_DATASTORE FILTER CTXSYS.INSO_FILTER');
>
> My table just holds a URL that points to the document.
> When I do queries using CONTAINS, everything works great.
>
> The PROBLEM:
> When I change one of the indexed documents, the index does not reflect the
> change. So I figured I just had to synchronize the index as follows:
> ALTER INDEX DocumentIndex REBUILD online
> PARAMETERS('sync');
>
> But this doesn't work. In fact, the only way I can see to make the index
> reread the documents and rebuild the index to see my changes - is by
> dropping it and recreating it.
>
> How can I refresh/rebuild the index?
>
> I know that when I do the query the synchronization is complete, because
> there are only 3 small documents in my test database.
>
> Tim Frith
Received on Tue Jan 25 2000 - 03:30:16 CST