synchronizing an index

From: Tim Frith <timfrith_at__home.com>
Date: Mon, 17 Jan 2000 20:33:01 GMT
Message-ID: <10Lg4.1119$a43.88464@news1.gvcl1.bc.home.com>

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 Mon Jan 17 2000 - 14:33:01 CST