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 47 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) orSpecify 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”