Reports for Determining the State of Indexes in UCM when Using Zone Fields, DATABASE.FULLTEXT or OracleTextSearch (Doc ID 1338849.1)

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.

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

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