Where are the default stop lists???

1053685

Hi all,

I am trying to SELECT a list of all stop words that ship with Oracle. The documentation states:

"The system supplies a list of stopwords called a stoplist for every language. By default during indexing, the system uses the Oracle Text default stoplist for your language." [1]

When I run SELECT * FROM CTX_STOPWORDS, I only get results for the DEFAULT_STOPLIST, which is in English. How can I access the stop lists for other languages?

[1] https://docs.oracle.com/database/121/CCAPP/GUID-71087894-0C0B-42CF-B37E-064401C54545.htm#CCAPP9094

Bud Light

Also, they can be found in:  ORACLE_HOME\ctx\admin\defaults

Bud Light

They are referenced in the appendix:

https://docs.oracle.com/database/121/CCREF/astopsup.htm#CCREF1400

Bud Light

Also, they can be found in:  ORACLE_HOME\ctx\admin\defaults