My Oracle Support Banner

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

Last updated on APRIL 16, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.