Page History
...
| UI Text Box | ||
|---|---|---|
| ||
When changing the stoplist of the full-text index, the changes do not take effect until the index is rebuilt. |
Modifying the default stoplist
The default stoplist is CTXSYS.DEFAULT_STOPLIST, and it used when the index is created without specifying a stoplist. Stopwords can be added or removed from this stoplist as in the following script:
...
- the default stoplist is owned by the sys user. In order to change the stoplist, the script must be executed as sys.
- after changing the default stoplist (either adding or removing words), the full-text index needs to be re-created
- simply rebuilding the index does not have any effect
Creating a new stoplist
A new stoplist can be created and stopwords can be added or removed as in the following script:
...
The above statement must be executed each time the stoplist is modified in order for the changes to the stoplist take effect.
Dynamically adding stopwords
It is possible to add stopwords to the stoplist of the full-text index without having to rebuild the index using the 'alter index parameters' statement:
...
Overview
Content Tools