Context Index Settings

Specify the context index settings for the text column. The default selections will work well in many cases. For detailed information about these choices, see the Oracle Text documentation.

For each setting, you specify a Schema and a Name. The default schema in all cases is CTXSYS, the Oracle Text schema for context indexes.

Note: We recommend that you use the default values in all instances, except for Stoplist.

If the datatype of the text column is CLOB or BLOB, the Use multilexer selection is enabled; the default is to not use the multilexer.

If you are creating an index for a column that you have indexed before, the default is to reuse the existing index. If you do not want to reuse the existing index, click the Use existing index if there is one checkbox (to remove the check mark).

Note: If this wizard is invoked from a mining activity, the Use existing index if there is one checkbox is not available. In a mining activity, the activity always creates its own index based on the settings supplied.

For more information about context indexes, see the Oracle Text documentation. Where to Find More Information describes how to locate Oracle Text documentation.