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.
DEFAULT_DATASTORE
is the default.DEFAULT_LEXER
is the default value.DEFAULT_WORDLIST
is the default value.DEFAULT_STORAGE
, the default value, indicates that the Text index tables are created in the index owner's default tablespace.CTXSYS.DEFAULT_STOPLIST
, or you can select a stoplist that you create. See Stopwords and Stoplists for an example of creating a stoplist.NOT APPLICABLE
.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.
Copyright © 2006, 2008, Oracle. All rights reserved.