My Oracle Support Banner

Oracle WebCenter Content (WCC) Best Practices for Using Oracle Text Search (OTS) - Part 1: Gathering Information about the Text Index (Doc ID 1996503.1)

Last updated on MARCH 05, 2024

Applies to:

Oracle WebCenter Content - Version and later
Information in this document applies to any platform.


There are two parts to this document, together they help detail the best practices for the implementation of Oracle Text Search (OTS).  Part 1 is about gathering information about the Text Index.  Part 2 is about controlling the size of the Text Index.  To read Part 2, please reference <Note 1996531.1>

Questions and Answers

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
Questions and Answers
 Using the Active Index the database information can be determined using the following table
 The next step is determining the overall health of the database index itself.
 The next steps are related to determining the amount of content that is full text indexed.
 Controlling the Size of the Text Index – The Indexing procedure
 Indexing with Oracle Text
 The Text Extraction Process
 Preparing the Database Table (IdcText1 or IdcText2) for the New Content Item
 Database Indexes: FT_IDCTEXT1 and FT_IDCTEXT2

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