Fast Rebuild Throws Error ORA-00942 in systemdatabase Tracing When Selecting from CTXSYS.DR$PENDING (Doc ID 1096265.1)

Last updated on MAY 01, 2017

Applies to:

Oracle WebCenter Content - Version 10.1.3.4.0 to 11.1.1.4.0 [Release 10gR3 to 11g]
Information in this document applies to any platform.

Symptoms

Using OracleTextSearch as the SearchIndexerEngineName, a Fast Rebuild fails with the following error. 

systemdatabase 05.05 16:59:42.500 Text Fast Rebuild !csDbUnableToCreateResultSet,QoracleTextPendingDocIDs(SELECT PND_CID FROM CTXSYS.DR$PENDING WHERE PND_CID = 1435)!$ORA-00942: table or view does not exist
systemdatabase 05.05 16:59:42.500 Text Fast Rebuild 1988832184 ms. [ORA-00942: table or view does not exist
]

Cause

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