My Oracle Support Banner

What Happens When Indexing a Content Item on UCM Using Oracle Database with OracleTextSearch Enabled? (Doc ID 871388.1)

Last updated on MAY 29, 2018

Applies to:

Oracle WebCenter Content - Version 11.1.1.8.0 to 11.1.1.8.0 [Release 11g]
Oracle WebCenter Content - Version 10.1.3.3.0 to 10.1.3.3.4 [Release 10gR3]
Oracle WebCenter Content - Version 12.2.1.3.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.

Goal

This note is intended to follow a document through the indexing process when the UCM environment is configured with OracleTextSearch. The configuration setting that enables this is SearchIndexerEngineName=OracleTextSearch. This indexing process and the example used is specific to OracleTextSearch. Using other search configurations, such as Verity, DATABASE.METADATA, or DATABASE.FULLTEXT have similar steps, but differ in certain areas.

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!


In this Document
Goal
Solution
 Check in a New Content Item
 The Text Extraction Process
 Preparing the Database Table (IdcText1 or IdcText2) for the New Content Item
 
Inserting the Metadata and Full Text
 Database Indexes: FT_IDCTEXT1 and FT_IDCTEXT2
 Searching for the content item
 Deleting a content item
References

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