Query with synonym operator (SYN) fails with Text error DRG-11702: "Too Many Synonyms Per Synonym Ring"

Query with synonym operator (SYN) fails with Text error DRG-11702: "Too Many Synonyms Per Synonym Ring" (Doc ID 1276835.1)

Last updated on APRIL 20, 2011

Applies to:

Oracle Text - Version: 11.2.0.1 and later [Release: 11.2 and later ]
Information in this document applies to any platform.

After database upgrade from 10g to 11gR2 every query using the synonym operator (SYN) or CTX_THES.SYN fails with below errors:

ERROR at line 1:
ORA-29902: error in executing ODCIIndexStart() routine
ORA-20000: Oracle Text error:
DRG-11702: too many synonyms per synonym ring

Database upgraded from 10g to 11gR2.

	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