Reports for Determining the State of Indexes in UCM when Using Zone Fields, DATABASE.FULLTEXT or OracleTextSearch
Last updated on MAY 01, 2017
Applies to:Oracle WebCenter Content - Version 10.1.3.5.0 and later
Information in this document applies to any platform.
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.
|Zone||x (one field)|
|OracleTextSearch||x (all fields)||x|
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms