My Oracle Support Banner

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

Last updated on JULY 31, 2018

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

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.