CONTEXT Index Parameters

The following default parameters are used when you create a CONTEXT index and do not specify preferences in the parameter clause of CREATE INDEX. Each default parameter names a system-defined preference to use for data storage, filtering, lexing, and so on.

Table 46 Default CONTEXT Index Parameters

Parameter Used When Default Value
DEFAULT_DATASTORE No datastore preference specified in parameter clause of CREATE INDEX. CTXSYS.DEFAULT_DATASTORE
DEFAULT_FILTER_FILE

No filter preference specified in parameter clause of CREATE INDEX, and either of the following conditions is true:

  • Your files are stored in external files (BFILES) or

  • Specify a datastore preference that uses FILE_DATASTORE

CTXSYS.AUTO_FILTER
DEFAULT_FILTER_BINARY No filter preference specified in parameter clause of CREATE INDEX, and Oracle Text detects that the text column datatype is RAW, LONG RAW, or BLOB. CTXSYS.AUTO_FILTER
DEFAULT_FILTER_TEXT No filter preference specified in parameter clause of CREATE INDEX, and Oracle Text detects that the text column datatype is either LONG, VARCHAR2, VARCHAR, CHAR, or CLOB. CTXSYS.NULL_FILTER
DEFAULT_SECTION_HTML

No section group specified in parameter clause of CREATE INDEX, and when either of the following conditions is true:

  • Your datastore preference uses URL_DATASTORE or

  • Your filter preference uses AUTO_FILTER.

CTXSYS.HTML_SECTION_GROUP
DEFAULT_SECTION_TEXT No section group specified in parameter clause of CREATE INDEX, and when you do not use either URL_DATASTORE or AUTO_FILTER. CTXSYS.NULL_SECTION_GROUP
DEFAULT_STORAGE No storage preference specified in parameter clause of CREATE INDEX. CTXSYS.DEFAULT_STORAGE
DEFAULT_LEXER No lexer preference specified in parameter clause of CREATE INDEX. CTXSYS.DERAULT_LEXER
DEFAULT_STOPLIST No stoplist specified in parameter clause of CREATE INDEX. CTXSYS.DEFAULT_STOPLIST
DEFAULT_WORDLIST No wordlist preference specified in parameter clause of CREATE INDEX. CTXSYS.DEFAULT_WORDLIST

See Also:System-Defined Preferences