[SOLVED] too many synonyms per synonym ring

too many synonyms per synonym ring - Oracle Text

I created my own thesaurus for Arabic language and created relations between terms to define synonyms, I used This Code:

  ctx_thes.create_thesaurus ('myThesurus');
  ctx_thes.create_relation ('myThesurus', 'لعب', 'syn', 'مرح');

it worked fine, I created more than 10000 synonyms. but when I used this code:

SELECT CTX_THES.SYN ('هم', 'plagThesurus') FROM DUAL;

it returned this error message

ORA-20000: Oracle Text error:
DRG-11702: too many synonyms per synonym ring
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_THES", line 708
ORA-06512: at line 1

I searched many, but I couldn't find any results any help please?

Solution

Looks like you have exceeded the limit. From oracle docs https://docs.oracle.com/database/121/CCREF/cthes.htm#CCREF2157

CREATE_RELATION Creates a relation between two phrases in the thesaurus. The synonym ring is limited in length to about 4000 synonyms, depending on word length.