Fast Rebuild Throws Error ORA-00942 in systemdatabase Tracing When Selecting from CTXSYS.DR$PENDING
(Doc ID 1096265.1)
Last updated on MARCH 14, 2023
Applies to:
Oracle WebCenter Content - Version 10.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! |
In this Document
| Symptoms |
| Cause |
| Solution |