Modifying the Default Stoplist

The default stoplist is always named .CTXSYS.DEFAULT_STOPLIST. Use the following procedures to modify this stoplist:

• CTX_DDL.ADD_STOPWORD

• CTX_DDL.REMOVE_STOPWORD

• CTX_DDL.ADD_STOPTHEME

• CTX_DDL.ADD_STOPCLASS

When you modify CTXSYS.DEFAULT_STOPLIST with the CTX_DDL package, you must re-create your index for the changes to take effect.

Dynamic Addition of Stopwords

You can add stopwords dynamically to a default or custom stoplist with ALTER INDEX. When you add a stopword dynamically, you need not re-index, because the word immediately becomes a stopword and is removed from the index.

Note: Even though you can dynamically add stopwords to an index, you cannot dynamically remove stopwords. To remove a stopword, you must use CTX_DDL.REMOVE_STOPWORD, drop your index and re-create it.

See Also: “ALTER INDEX” in Oracle Text SQL Statements and Operators