How To Manually Remove Oracle Text Search Collection And Rebuild for WebCenter Content (WCC)

(Doc ID 1332148.1)

Last updated on JANUARY 13, 2017

Applies to:

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

Goal

Is it possible to wipe out or remove the existing WCC Oracle Text Search index manually and start from scratch?

e.g.
A number of attempts have been made to complete a Full Collection Rebuild Cycle in the Repository Manager.
The Index rebuild keeps being interrupted by an archiving process that runs on the Oracle 11g database.
It reports out of I/O in the process of doing a full collection rebuild because the normal Oracle database archiving process was also running and competing for I/O.
The database archiving process has been stopped to allow the index to complete.
There have been three failed attempts to re-index and it seems like the existing Oracle Text Search collection has been damaged.

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