Page History
In OracleText, a full-text index can be configured to synchronize manually, at regular intervals or on commit. By default, the Blueriq full-text index on aggregates and documents is synchronized every hour. To change this behaviourbehavior, the index needs to be rebuilt with different parameters.
UI Text Box | ||
---|---|---|
| ||
Always consult the documentation of your particular Oracle database version. The following examples illustrate how to change the synchronization behaviour behavior without setting additional options such as whether the index is rebuilt online or offline, whether it is rebuilt in parallel, etc. |
...
When changing the full-text index to manual synchronization, any modification to aggregates and documents will not be reflected in the index until the stored procedure CTX_DDL.SYNC_INDEX
is not manually called. This has to be done by DBA either manually, or through a scheduled job.
...
UI Text Box | ||
---|---|---|
| ||
When using this synchronization method, the database user needs to have the |
Changing index synchronization to on commit
To change the index synchronization behaviour behavior so that the index is synchronized after every commit, execute the following script:
...
UI Expand | ||
---|---|---|
| ||
|
...
Include Page | ||||
---|---|---|---|---|
|