My Oracle Support Banner

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

Last updated on JANUARY 03, 2023

Applies to:

Oracle WebCenter Content - Version 10.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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Determining the index name in use for DATABASE.FULLTEXT and OracleTextSearch
 Determining the index names of Zone Text Fields
 Oracle Text Procedures

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.