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 11.1.1.3.0 and later
Information in this document applies to any platform.

Purpose

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.