My Oracle Support Banner

ORA-20000, DRG-50857, ORA-942 from CTX_DDL.SYNC_INDEX (Doc ID 1280649.1)

Last updated on NOVEMBER 05, 2012

Applies to:

Oracle Text - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 05-Nov-2012***

Symptoms

A scheduled job that syncs Text indexes fails with errors:

ORA-20000: ORA-20000: Oracle Text error:
DRG-50857: oracle error in drekmap (execute insert)
ORA-00942: table or view does not exist
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 539
ORA-06512: at "USER.NAME_TS_JOB", line 3


Or manually sync'ing a Text index fails with errors

SQL> exec ctx_ddl.sync_index('BOOKS_INDEX');
BEGIN ctx_ddl.sync_index('BOOKS_INDEX'); END;
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-50857: oracle error in dreii0fsh
ORA-00942: table or view does not exist
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 539
ORA-06512: at line 1

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
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.