This script enables the text search feature on an Oracle
database using the CONTEXT index.
About this task
The CONTEXT index does not automatically
update text search indexes. Therefore, a DBA has to manually update
text search indexes by running the EFrame_TextIndexUpdates.sql script.
To
enable the text search feature on an Oracle database using the CONTEXT
index:
Procedure
- Make sure that the Oracle database is configured
with the Oracle Text feature.
- Log in to the Oracle server with a user ID
having the
CTXAPP privilege. Note: The CONTEXT type text search indexes that are created
on Oracle database using the EFrame_TextIndexAdds.sql script
are not updated automatically. The DBA has to run the EFrame_TextIndexUpdates.sql script
to update the CONTEXT type text search indexes using scheduled jobs.
The frequency of these scheduled jobs can be decided by the DBA.
- Verify that the text search index creation
was successful.
- 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=context
