Legacy platform

Enabling the text search feature for CTXCAT index

The CTXCAT index automatically updates text search indexes. Therefore, the DBA need not manually run the EFrame_TextIndexUpdates.sql script to update text search indexes.

About this task

To enable the text search feature on an Oracle database using the CTXCAT index:

Procedure

  1. Make sure that the Oracle database is configured with the Oracle Text feature.
  2. Log in to the Oracle server with a user ID having the CTXAPP privilege.
  3. Verify that the text search index creation was successful.
  4. Edit the customer_overrides.properties file that is located in the <INSTALL_DIR>/properties directory to add the following entries:
    
       yfs.yfs.db.textsearch=Y 
       yfs.yfs.db.textsearch.oracle.contexttype=ctxcat
    
    .