LOAD_STOPLIST

Use this procedure to load a source file of stopwords to your stoplist for the required language.

A default stoplist is automatically loaded during installation or upgrade based on the database language that you choose. By default, only one SQL file is loaded for the chosen language. You can call the CTX_DDL.LOAD_STOPLIST procedure to customize your stoplist or modify the default list of stopwords. This procedure takes a source file of stopwords for the specified language and adds each word to your stoplist from the stoplist_dir/stoplist_file.

The Oracle Text supplied stoplists contain default stopwords for all BASIC_LEXER and AUTO_LEXER supported languages.

You can also load multi-language stoplists to hold language-specific stopwords. A multi-language stoplist is useful when you index a table that contains documents in different languages, such as English, German, and Japanese. When indexing a multi-language table with a multi-language stoplist, the table must have a language column.

Specify a stoplist in the parameter string of CREATE INDEX or ALTER INDEX to override the default stoplist CTXSYS.DEFAULT_STOPLIST. Add either stopwords, stopclasses, or stopthemes to a stoplist using ADD_STOPWORD, ADD_STOPCLASS, or ADD_STOPTHEME.

Syntax

PROCEDURE LOAD_STOPLIST(
  stoplist_name       IN  VARCHAR2,
  stoplist_dir        IN  VARCHAR2,
  stoplist_file       IN  VARCHAR2,
  language            IN  VARCHAR2 default NULL,
  language_dependent  IN BOOLEAN default TRUE
)

stoplist_name

Specify the name of the stoplist to be loaded.

stoplist_dir

Specify the directory location of the source file that you want to load. The source files for default stoplists are located in the $ORACLE_HOME/ctx/data/stoplist directory.

stoplist_file

Specify the name of the source file located in the $ORACLE_HOME/ctx/data/stoplist directory. These source files are named drstopLANG.txt, where LANG specifies the language code. The contents of the source files are the extracted terms from the drdefLANG.sql files (located in the $ORACLE_HOME/ctx/admin directory).

language

Specify the language of a stopword when loading multi-language stoplists. You must specify the globalization support name or abbreviation of an Oracle Text-supported language.

To make a stopword active in multiple languages, specify ALL for this parameter. For example, defining ALL stopwords is useful when you have international documents that contain English fragments to be stopped in any language. An ALL stopword is active in all languages. If you use multi-lexer, the language-specific lexing of a stopword occurs just as if it has been added multiple times in multiple specific languages.

Otherwise, specify NULL.

language_dependent

Set this parameter to FALSE to indicate that any user-defined string can be specified for the language parameter.

Examples

Single-language stoplist:

The following example loads a stoplist named mystop for French (language code: f):
```
begin
ctx_ddl.load_stoplist('mystop', 'ORACLE_HOME/ctx/data/stoplist', 'drstopf.txt');
end;
```

Multi-language stoplist:

The following example loads a multi-language stoplist named multistop for Arabic (language code: ar) and Dutch (language code: nl):

begin
ctx_ddl.load_stoplist('multistop', 'ORACLE_HOME/ctx/data/stoplist', 'drstopar.txt', 'arabic');
ctx_ddl.load_stoplist('multistop', 'ORACLE_HOME/ctx/data/stoplist', 'drstopnl.txt', 'dutch');
end;

Related Topics