Enabling the text search feature for CTXCAT index
The CTXCAT index automatically updates text search indexes.
Therefore, the DBA need not manually run the
to update text search indexes.
About this task
To enable the text search feature on an Oracle database using the CTXCAT index:
- Make sure that the Oracle database is configured with the Oracle Text feature.
- Log in to the Oracle server with a user ID
- Verify that the text search index creation was successful.
- Edit the
customer_overrides.propertiesfile that is located in the
<INSTALL_DIR>/propertiesdirectory to add the following entries:
yfs.yfs.db.textsearch=Y yfs.yfs.db.textsearch.oracle.contexttype=ctxcat .