Reports for Determining the State of Indexes in UCM when Using Zone Fields, DATABASE.FULLTEXT or OracleTextSearch
(Doc ID 1338849.1)
Last updated on APRIL 04, 2024
Applies to:
Oracle WebCenter Content - Version 10.0 and later Information in this document applies to any platform.
Goal
UCM uses a type of index on the Oracle Database called a CONTEXT index, which is part of the database component known as Oracle Text. Reports on these types of indexes are available and can be useful in determining the state of the index. CONTEXT indexes are used in UCM for the following search components:
1. Zone Text Fields - for zone fields, an Oracle Text CONTEXT index is placed on an individual metadata field. These are enabled through the component DBSearchContainsOpSupport.
2. SearchIndexerEngineName=DATABASE.FULLTEXT - when this option is used as the UCM search index, the extracted full text of content items is stored in a CONTEXT index.
3. SearchIndexerEngineName=OracleTextSearch - when this option is used as the UCM search index, both metadata and full text are stored in a CONTEXT index.
Metadata
Fulltext
Zone
x (one field)
DATABASE.FULLTEXT
x
OracleTextSearch
x (all fields)
x
Solution
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!