Oracle Reference -- Index

! operator, 3-40

escape character, 4-3

$ operator, 3-41

% wildcard, 3-54

* operator, 3-52

, operator, 3-10

= operator, 3-16

> operator, 3-45

? operator, 3-17

- operator, 3-28

_ wildcard, 3-54

{} escape character, 4-3

ABOUT query, 3-6

example, 3-7

highlight markup, 8-14

highlight offsets, 8-10

viewing expansion, 10-6

accumulate operator, 3-10

scoring, 3-10

stopword transformations, H-4

ADD_ATTR_SECTION procedure, 7-3

ADD_EVENT procedure, 9-2

ADD_FIELD_SECTION procedure, 7-5

ADD_SPECIAL_SECTION procedure, 7-11

ADD_STOP_SECTION procedure, 7-14

ADD_STOPCLASS procedure, 7-13

ADD_STOPTHEME procedure, 7-16

ADD_STOPWORD procedure, 7-17

ADD_SUB_LEXER procedure, 7-19

example, 2-46

ADD_ZONE_SECTION procedure, 7-22

ALTER INDEX, 1-2

examples, 1-10

rebuild syntax, 1-4

rename syntax, 1-3

ALTER TABLE, 1-13

ALTER_PHRASE procedure, 12-3

ALTER_THESAURUS procedure, 12-5

alternate spelling

about, E-2

Danish, E-4

disabling example, 7-55, E-2

enabling example, E-2

German, E-3

Swedish, E-5

alternate_spelling attribute, 2-45

American

index defaults, 2-89

AND operator, 3-12

stopword transformations, H-3

attribute section

defining, 7-3

dynamically adding, 1-12

querying, 3-56

attribute sections

adding dynamically, 1-8

WITHIN example, 3-59

attributes

alternate_spelling, 2-45

base_letter, 2-42

binary, 2-8

charset, 2-24

command, 2-31

composite, 2-43

continuation, 2-39

detail_key, 2-8

detail_lineno, 2-8

detail_table, 2-8

detail_text, 2-8

disabling, 7-55

endjoins, 2-41

ftp_proxy, 2-14

fuzzy_match, 2-73

fuzzy_numresults, 2-73

fuzzy_score, 2-73

http_proxy, 2-14

i_index_clause, 2-79

i_table_clause, 2-78

index_text, 2-44

index_themes, 2-43

k_table_clause, 2-78

maxdocsize, 2-14

maxthreads, 2-13

maxurls, 2-14

mixed_case, 2-42

n_table_clause, 2-79

newline, 2-42

no_proxy, 2-14

numgroup, 2-40

numjoin, 2-40

output_type, 2-17

p_table_clause, 2-79

path, 2-11

printjoins, 2-40

procedure, 2-16

punctuations, 2-40

r_table_clause, 2-78

setting, 7-52

skipjoins, 2-41

startjoins, 2-41

stemmer, 2-72

timeout, 2-13

urlsize, 2-13

viewing, G-10

viewing allowed values, G-10

whitespace, 2-42

AUTO stemming, 2-71

AUTO_SECTION_GROUP example, 2-83

AUTO_SECTION_GROUP object, 1-45, 2-82, 7-34

AUTO_SECTION_GROUP system-defined preference, 2-90

backslash escape character, 4-3

base_letter attribute, 2-42

BASIC_LEXER object, 2-38

supported character sets, 2-38

BASIC_LEXER system-defined preference, 2-90

BASIC_LEXER type

example, 2-45

BASIC_SECTION_GROUP object, 1-44, 2-81, 7-33

BASIC_STOPLIST type, 7-36

BASIC_STORAGE object

attributes for, 2-78

defaults, 2-79

example, 2-79

BASIC_WORDLIST object

attributes for, 2-71

example, 2-75

BFILE column

indexing, 1-31

BINARY

format column value, 1-35

binary attribute, 2-8, 2-20

BLOB column

indexing, 1-31

loading example, C-3

brace escape character, 4-3

brackets

altering precedence, 3-5, 4-2

grouping character, 4-2

broader term operators

example, 3-13

broader term query feedback, 10-9

BROWSE_WORDS procedure, 10-2

browsing words in index, 10-2

BT function, 12-7

BT operator, 3-13

BTG function, 12-10

BTG operator, 3-13

BTI function, 12-12

BTI operator, 3-13

BTP function, 12-14

BTP operator, 3-13

case-sensitive

ABOUT queries, 3-7

case-sensitive index

creating, 2-42

categories in knowledge catalog, I-1

CATSEARCH operator, 1-17

CHAR column

indexing, 1-31

character sets

Chinese, 2-47

Japanese, 2-48

Korean, 2-50, 2-51

characters

continuation, 2-39

numgroup, 2-40

numjoin, 2-40

printjoin, 2-40

punctuation, 2-40

skipjoin, 2-41

specifying for newline, 2-42

specifying for whitespace, 2-42

startjoin and endjoin, 2-41

character-set

indexing mixed columns, 2-24

character-set conversion

with INSO_FILTER, 2-28

charset attribute, 2-24

charset column, 1-35

CHARSET_FILTER

attributes for, 2-24

mixed character-set example, 2-25

Chinese

fuzzy matching, 2-72

Chinese character sets supported, 2-47

Chinese text

indexing, 2-47

CHINESE_VGRAM_LEXER object, 2-47

classifying documents, 6-2

CLOB column

indexing, 1-31

clump size in near operator, 3-32

columns types

supported for CTXCAT index, 1-41, 1-44

supported for CTXXPATH index, 1-46

supported for indexing, 1-31

command attribute, 2-31

composite attribute

BASIC_LEXER, 2-43

KOREAN_MORP_LEXER, 2-52

composite textkey

encoding, 8-20

composite word dictionary, 2-43

composite word index

creating for German or Dutch text, 2-43

composite words

viewing, 10-6

concepts in knowledge catalog, I-1

CONTAINS operator

example, 1-25

syntax, 1-24

CONTEXT index

about, 1-29

default parameters, 2-93

syntax, 1-31

context indextype, 1-29

continuation attribute, 2-39

control file example

SQL*Loader, C-4

COUNT_HITS procedure, 10-5

CREATE INDEX, 1-29

CONTEXT, 1-31

CTXCAT, 1-41

CTXRULE, 1-44

CTXXPATH, 1-46

default parameters, 2-93

CREATE_INDEX_SET procedure, 7-26, 7-56

CREATE_PHRASE procedure, 12-16

CREATE_POLICY procedure, 7-27

CREATE_PREFERENCE procedure, 7-30

CREATE_RELATION procedure, 12-18

CREATE_SECTION_GROUP procedure, 7-33

CREATE_STOPLIST procedure, 7-36

CREATE_THESAURUS function, 12-20

CREATE_TRANSLATION procedure, 12-21

CTX_ADM package

RECOVER, 5-2

SET_PARAMETER, 5-3

SHUTDOWN, 5-5

CTX_CLASSES view, G-4

CTX_CLS

TRAIN, 6-2

CTX_DDL package

ADD_ATTR_SECTION, 7-3

ADD_FIELD_SECTION, 7-5

ADD_SPECIAL_SECTION, 7-11

ADD_STOP_SECTION, 7-14

ADD_STOPCLASS, 7-13

ADD_STOPTHEME, 7-16

ADD_STOPWORD, 7-17

ADD_SUB_LEXER, 7-19

ADD_ZONE_SECTION, 7-22

CREATE_INDEX_SET, 7-26, 7-56

CREATE_POLICY, 7-27

CREATE_PREFERENCE, 7-30

CREATE_SECTION_GROUP, 7-33

CREATE_STOPLIST, 7-36

DROP_POLICY, 7-39

DROP_PREFERENCE, 7-40

DROP_STOPLIST, 7-42

OPTIMIZE_INDEX procedure, 7-43

REMOVE_SECTION, 7-47

REMOVE_STOPCLASS, 7-49

REMOVE_STOPTHEME, 7-50

REMOVE_STOPWORD, 7-51

SET_ATTRIBUTE, 7-52

SYNC_INDEX procedure, 7-53

UNSET_ATTRIBUTE, 7-55

CTX_DOC package, 8-1

FILTER, 8-2

GIST, 8-5

HIGHLIGHT, 8-10

IFILTER, 8-13

MARKUP, 8-14

PKENCODE, 8-20

result tables, A-8

SET_KEY_TYPE, 8-22

THEMES, 8-23

TOKENS, 8-26

CTX_DOC_KEY_TYPE system parameter, 2-92

CTX_FEEDBACK_ITEM_TYPE type, A-7

CTX_FEEDBACK_TYPE type, 10-10, A-7

CTX_INDEX_ERRORS view, G-5

example, 1-40

CTX_INDEX_OBJECTS view, G-5

CTX_INDEX_SET_INDEXES view, G-7

CTX_INDEX_SUB_LEXERS view, G-7, G-21

CTX_INDEX_SUB_LEXERS_VALUES view, G-8

CTX_INDEX_VALUES view, G-9

CTX_INDEXES view, G-4

CTX_OBJECT_ATTRIBUTE_LOV view, G-10

CTX_OBJECT_ATTRIBUTES view, G-10

CTX_OBJECTS view, G-9

CTX_OUTPUT package, 9-1

ADD_EVENT, 9-2

END_LOG, 9-3

LOGFILENAME, 9-4

REMOVE_EVENT, 9-5

START_LOG, 9-6

CTX_PARAMETERS view, 2-92, G-11

CTX_PENDING view, G-13

CTX_PREFERENCE_VALUES view, G-14

CTX_PREFERENCES view, G-13

CTX_QUERY package

BROWSE_WORDS, 10-2

COUNT_HITS, 10-5

EXPLAIN, 10-6

HFEEDBACK, 10-9

REMOVE_SQE, 10-14

result tables, A-2

STORE_SQE, 10-15

CTX_SECTION_GROUPS view, G-15

CTX_SECTIONS view, G-14

CTX_SERVERS view, G-15

CTX_SQES view, G-16

CTX_STOPLISTS view, G-16

CTX_STOPWORDS view, G-16

CTX_SUB_LEXERS view, G-17

CTX_THES package, 12-1

ALTER_PHRASE, 12-3

ALTER_THESAURUS, 12-5

BT, 12-7

BTG, 12-10

BTI, 12-12

BTP, 12-14

CREATE_PHRASE, 12-16

CREATE_RELATION, 12-18

CREATE_THESAURUS, 12-20

DROP_PHRASE, 12-22

DROP_RELATION, 12-24

DROP_THESAURUS, 12-27

NT, 12-30

NTG, 12-33

NTI, 12-35

NTP, 12-37

OUTPUT_STYLE, 12-39

PT, 12-40

result tables, A-12

RT, 12-42

SN, 12-44

SYN, 12-45

THES_TT, 12-48

TR, 12-49

TRSYN, 12-51

TT, 12-53

CTX_THESAURI view, G-17

CTX_THES.CREATE_TRANSLATION, 12-21

CTX_THES.DROP_TRANSLATION, 12-28

CTX_THES.UPDATE_TRANSLATION, 12-55

CTX_ULEXER package, 13-1

CTX_USER_INDEX_ERRORS view, G-19

example, 1-40

CTX_USER_INDEX_OBJECTS view, G-19

CTX_USER_INDEX_SET_INDEXES view, G-21

CTX_USER_INDEX_SETS view, G-20

CTX_USER_INDEX_SUB_LEXERS view, G-21

CTX_USER_INDEX_VALUES view, G-22

CTX_USER_INDEXES view, G-18

CTX_USER_PENDING view, G-22

CTX_USER_PREFERENCE_VALUES view, G-23

CTX_USER_PREFERENCES view, G-22

CTX_USER_SECTION_GROUPS view, G-23

CTX_USER_SECTIONS view, G-23

CTX_USER_SQES view, G-24

CTX_USER_STOPLISTS view, G-24

CTX_USER_STOPWORDS view, G-24

CTX_USER_SUB_LEXERS view, G-25

CTX_USER_THES_PHRASES view, G-25

CTX_USER_THESAURI view, G-25

CTX_VERSION view, G-26

CTXCAT index

about, 1-29

default parameters, 2-94

supported preferences, 1-41

syntax, 1-41

unsupported preferences, 1-42

ctxkbtc complier, 12-6

ctxload, 12-2

examples, 12-5

import file structure, C-6

CTXRULE index

about, 1-29

default parameters, 2-95

syntax, 1-44

ctxsrv

shutting down, 5-5

viewing active servers, G-15

CTXXPATH index

about, 1-29

syntax, 1-46

CTXXPATH indextype

creating, 1-47

Danish

alternate spelling, E-4

index defaults, 2-89

supplied stoplist, D-5

data storage

defined procedurally, 2-16

direct, 2-3

example, 7-30

external, 2-11

master/detail, 2-8

URL, 2-12

datastore types, 2-3

DATE column, 1-31

default index

example, 1-38

default parameters

changing, 2-96

CONTEXT index, 2-93

CTXCAT index, 2-94

CTXRULE index, 2-95

viewing, 2-95

DEFAULT thesaurus, 3-14, 3-30

DEFAULT_CTXCAT_INDEX_SET system parameter, 2-94

DEFAULT_CTXCAT_LEXER system parameter, 2-94

DEFAULT_CTXCAT_STOPLIST system parameter, 2-94

DEFAULT_CTXCAT_STORAGE system parameter, 2-94

DEFAULT_CTXCAT_WORDLIST system parameter, 2-95

DEFAULT_CTXRULE_LEXER system parameter, 2-95

DEFAULT_CTXRULE_STOPLIST system parameter, 2-95

DEFAULT_CTXRULE_WORDLIST system parameter, 2-95

DEFAULT_DATASTORE system parameter, 2-93

DEFAULT_DATASTORE system-defined indexing preference, 2-88

DEFAULT_FILTER_BINARY system parameter, 2-93

DEFAULT_FILTER_FILE system parameter, 2-93

DEFAULT_FILTER_TEXT system parameter, 2-93

DEFAULT_INDEX_MEMORY system parameter, 2-92

DEFAULT_LEXER system parameter, 2-94

DEFAULT_LEXER system-defined indexing preference, 2-89

DEFAULT_RULE_STORAGE system parameter, 2-95

DEFAULT_SECTION_HTML system parameter, 2-93

DEFAULT_SECTION_TEXT system parameter, 2-94

DEFAULT_STOPLIST system parameter, 2-94

DEFAULT_STOPLIST system-defined preference, 2-91

DEFAULT_STORAGE system parameter, 2-94

DEFAULT_STORAGE system-defined preference, 2-91

DEFAULT_WORDLIST system parameter, 2-94

DEFAULT_WORDLIST system-defined preference, 2-91

defaults for indexing

viewing, G-11

derivational stemming

enabling for English, 2-72

DETAIL_DATASTORE object, 2-8

example, 2-8

detail_key attribute, 2-8

detail_lineno attribute, 2-8

detail_table attribute, 2-8

detail_text attribute, 2-8

dictionary

Korean, 2-51

user, 2-43

DIRECT_DATASTORE object, 2-3

example, 2-3

disambiguators

in thesaural queries, 3-13

in thesaurus import file, C-9

DML

affect on scoring, F-3

DML errors

viewing, G-5

DML processing

batch, 1-4

DML queue

viewing, G-13

document

filtering to HTML and plain text, 8-2

document filtering

Inso, B-2

document formats

supported, B-5

unsupported, B-14

document loading

SQL*Loader, C-3

document presentation

procedures, 8-1

document services

logging requests, 9-6

double-truncated queries, 3-54

double-truncated searching

improving performance, 2-73

DROP INDEX, 1-48

DROP_PHRASE procedure, 12-22

DROP_POLICY procedure, 7-39

DROP_PREFERENCE procedure, 7-40

DROP_RELATION procedure, 12-24

DROP_STOPLIST procedure, 7-42

DROP_THESAURUS procedure, 12-27

DROP_TRANSLATION procedure, 12-28

Dutch

composite word indexing, 2-43

fuzzy matching, 2-72

index defaults, 2-89

stemming, 2-71

supplied stoplist, D-6

empty indexes

creating, 1-37, 1-46

EMPTY_STOPLIST system-defined preference, 2-91

END_LOG procedure, 9-3

endjoins attribute, 2-41

English

fuzzy matching, 2-72

index defaults, 2-89

supplied stoplist, D-2

english attribute (Korean lexer), 2-52

environment variables

setting for Inso filter, B-3

equivalence operator, 3-16

stopword transformations, H-6

with NEAR, 3-33

errors

indexing, 1-40

escaping special characters, 4-3

example, 1-39

EXP_TAB table type, A-12

expansion operator

soundex, 3-40

stem, 3-41

viewing, 10-6

EXPLAIN procedure, 10-6

example, 10-8

result table, A-2

explain table

creating, 10-7

retrieving data example, 10-8

structure, A-2

extending knowledge base, 12-6

external filters

specifying, 2-31

failed index operation

resuming, 1-6

features

new, xxv

field section

defining, 7-5

limitations, 7-7

querying, 3-56

field sections

adding dynamically, 1-8

repeated, 3-59

WITHIN example, 3-58

file data storage

example, 7-30

FILE_DATASTORE object, 2-11

example, 2-11

FILE_DATASTORE system-defined preference, 2-88

filter formats

supported, B-5

FILTER procedure, 8-2

example, 8-4

in-memory example, 8-3

result table, A-8

filter table

structure, A-8

filter types, 2-23

filtering

to plain text, 8-13

to plain text and HTML, 8-2

filters

character-set, 2-24

Inso, 2-26, B-2

user, 2-31

Finnish

index defaults, 2-89

supplied stoplist, D-7

format column, 1-35

formatted documents

filtering, 2-26

fragmentation of index, 1-37

French

fuzzy matching, 2-72

supplied stoplist, D-8

French stemming, 2-71

ftp_proxy attribute, 2-14

fuzzy matching

automatic language detection, 2-72

example for enabling, 2-75

specifying a language, 2-73

fuzzy operator, 3-17

fuzzy_match attribute, 2-73

fuzzy_numresults attribute, 2-73

fuzzy_score attribute, 2-73

German

alternate spelling attribute, 2-45

alternate spelling conventions, E-3

composite word indexing, 2-43

fuzzy matching, 2-72

index defaults, 2-89

stemming, 2-71

supplied stoplist, D-9

gist

generating, 8-5

GIST procedure

example, 8-8

result table, A-8

updated syntax, 8-5

Gist table

structure, A-8

hanja attribute, 2-52

HASPATH operator, 3-19

HFEEDBACK procedure, 10-9

example, 10-10

result table, A-5

hierarchical query feedback information

generating, 10-9

hierarchical relationships

in thesaurus import file, C-8

HIGHLIGHT procedure, 8-10

example, 8-12

result table, A-10

highlight table

example, 8-12

structure, A-10

highlighting

generating markup, 8-14

generating offsets, 8-10

with NEAR operator, 3-34

hit counting, 10-5

HOME environment variable

setting for INSO, B-3

homographs

in broader term queries, 3-14

in queries, 3-13

in thesaurus import file, C-9

HTML

bypassing filtering, 2-27

filtering to, 8-2

generating highlight offsets for, 8-10

highlight markup, 8-14

highlighting example, 8-18

indexing, 1-44, 2-30, 2-81, 7-33

zone section example, 7-23

HTML_SECTION_GROUP

example, 2-82

HTML_SECTION_GROUP object, 1-44, 2-81, 7-23, 7-33

with NULL_FILTER, 2-30

HTML_SECTION_GROUP system-defined preference, 2-90

http_proxy attribute, 2-14

i_index_clause attribute, 2-79

i_table_clause attribute, 2-78

IFILTER procedure, 8-13

IGNORE

format column value, 1-35

import file

examples of, C-11

structure, C-6

index

creating, 1-29

renaming, 1-3

viewing registered, G-4

index creation

custom preference example, 1-38

default example, 1-38

index creation parameters

example, 2-79

index errors

deleting, 1-40

viewing, 1-40

index fragmentation, 1-37

index maintenance, 1-2

index objects, 2-1

viewing, G-5, G-9

index optimization, 1-6

index preference

about, 2-2

creating, 2-2, 7-30

index requests

logging, 9-6

index tablespace parameters

specifying, 2-78

index tokens

generating for a document, 8-26

INDEX_PROCEDURE user_lexer attribute, 2-56

index_stems attribute, 2-44

index_text attribute, 2-44

index_themes attribute, 2-43

indexing

master/detail example, 2-10

parallel, 1-4, 1-32

themes, 2-43

indextype context, 1-29

inflectional stemming

enabling, 2-72

INPATH operator, 3-21

INPUT_TYPE user_lexer attribute, 2-56

INSERT statement

loading example, C-2

Inso filter

index preference object, 2-26

setting up, B-2

supported formats, B-5

supported platforms, B-2

unsupported formats, B-14

INSO_FILTER object, 2-26

character-set conversion, 2-28

INSO_FILTER system-defined preference, 2-89

inverse frequency scoring, F-2

Italian

fuzzy matching, 2-72

stemming, 2-71

supplied stoplist, D-10

JA16EUC character set, 2-48, 2-49

JA16SJIS character set, 2-48, 2-49

Japanese

fuzzy matching, 2-72

index defaults, 2-90

indexing, 2-48

japanese attribute (Korean lexer), 2-52

Japanese character sets supported, 2-48

Japanese EUC character set, 2-49

JAPANESE_LEXER, 2-49

JAPANESE_VGRAM_LEXER object, 2-48

JOB_QUEUE_PROCESSES initialization parameter, 1-4, 1-32

k_table_clause attribute, 2-78

knowledge base

supported character set, 12-6

user-defined, 12-10

knowledge base extension compiler, 12-6

knowledge catalog

category hierarchy, I-1

KO16KSC5601 character set, 2-50, 2-51

Korean

fuzzy matching, 2-72

index defaults, 2-90

korean character sets supported, 2-50, 2-51

Korean text

indexing, 2-51

KOREAN_LEXER object, 2-50

KOREAN_MORP_LEXER, 2-51

composite example, 2-53

supplied dictionaries, 2-51

language

setting, 2-37

language column, 1-36

left-truncated searching

improving performance, 2-73

lexer types, 2-37

loading text

SQL INSERT example, C-2

SQL*Loader example, C-3

loading thesaurus, 12-2

LOB columns

loading, C-3

LOG_DIRECTORY system parameter, 2-92, 9-4

LOGFILENAME procedure, 9-4

logging index requests, 9-6

logical operators

with NEAR, 3-33

LONG columns

indexing, 1-31

long_word attribute, 2-52

maintaining index, 1-2

MARKUP procedure, 8-14

example, 8-18

HTML highlight example, 8-18

result table, A-10

markup table

example, 8-18

structure, A-10

master/detail data storage, 2-8

example, 2-8, 7-31

master/detail tables

indexing example, 2-10

MAX_INDEX_MEMORY system parameter, 2-92

max_span parameter in near operator, 3-32

maxdocsize attribute, 2-14

maxthreads attribute, 2-13

maxurls attribute, 2-14

memory

for index synchronize, 1-7

for indexing, 1-7, 1-37, 1-46, 7-53

META tag

creating field sections for, 7-7

creating zone section for, 7-23

MINUS operator, 3-28

stopword transformations, H-5

mixed character-set columns

indexing, 2-24

mixed_case attribute, 2-42

mixed-format columns

filtering, 2-26

indexing, 2-27

supported formats for, B-5

morpheme attribute, 2-52

MULTI_LEXER object

CREATE INDEX example, 1-38

example, 2-46

MULTI_LEXER type, 2-46

MULTI_STOPLIST type, 7-36

multi-language indexing, 7-19

multi-language stoplist, 2-46, 2-86

multi-language tables

querying, 1-26, 2-47

n_table_clause attribute, 2-79

narrower term operators

example, 3-29

narrower term query feedback, 10-9

NEAR operator, 3-32

backward compatibility, 3-34

highlighting, 3-34

scoring, 3-33

stopword transformations, H-6

with other operators, 3-33

with within, 3-57

nested section searching, 3-58

nested zone sections, 7-25

nested_column attribute, 2-20

NESTED_DATASTORE attribute, 2-21

NESTED_DATASTORE object, 2-20

nested_lineno attribute, 2-20

nested_text attribute, 2-20

nested_type attribute, 2-20

new features, xxv

newline attribute, 2-42

NEWS_SECTION_GROUP object, 2-82, 7-34

no_proxy attribute, 2-14

nopopulate index parameter, 1-37, 1-46

Norwegian

index defaults, 2-89

NOT operator, 3-36

stopword transformations, H-5

NT function, 12-30

NT operator, 3-29

NTG function, 12-33

NTG operator, 3-29

NTI function, 12-35

NTI operator, 3-29

NTP function, 12-37

NTP operator, 3-29

NULL_FILTER object, 2-30

NULL_FILTER system-defined preference, 2-89

NULL_SECTION_GROUP object, 2-81, 7-33

NULL_SECTION_GROUP system-defined preference, 2-90

number attribute, 2-52

NUMBER column, 1-31

numgroup attribute, 2-40

numjoin attribute, 2-40

object values

viewing, G-9

objects

viewing index, G-9

offsets for highlighting, 8-10

one_char_word attribute, 2-52

OPERATION column of explain table

values, A-3

OPERATION column of hfeedback table

values, A-6

operator

ABOUT, 3-6

accumulate, 3-10

broader term, 3-13

equivalence, 3-16

fuzzy, 3-17

HASPATH, 3-19

INPATH, 3-21

MINUS, 3-28

narrower term, 3-29

NEAR, 3-32

NOT, 3-36

OR, 3-37

preferred term, 3-38

related term, 3-39

soundex, 3-40

SQE, 3-42

stem, 3-41

synonym, 3-43

threshold, 3-45

top term, 3-50

translation term, 3-46

translation term synonym, 3-48

weight, 3-52

WITHIN, 3-56

operator expansion

viewing, 10-6

operator precedence, 3-3

examples, 3-4

viewing, 10-6

operators, 3-1

OPTIMIZE_INDEX procedure, 7-43

optimizing index, 1-6

OPTIONS column

explain table, A-4

hfeedback table, A-6

OR operator, 3-37

stopword transformations, H-3

OUTPUT_STYLE procedure, 12-39

output_type attribute, 2-17

overlapping zone sections, 7-24

p_table_clause, 2-79

PARAGRAPH keyword, 3-59

paragraph section

defining, 7-11

querying, 3-56

parallel index creation, 1-39

parallel indexing, 1-4, 1-32

example, 1-39

parameters

setting, 5-3

viewing system-defined, G-11

parentheses

altering precedence, 3-5, 4-2

grouping character, 4-2

partitioned index

example, 1-39

rebuild example, 1-10

partitioned index creation

example, 1-39

partitioned tables

modifying, 1-13

path attribute, 2-11

PATH environment variable

setting for Inso, B-3

PATH_SECTION_GROUP

querying with, 3-21

PATH_SECTION_GROUP object, 2-82, 7-34

PATH_SECTION_GROUP system-defined preference, 2-90

pending DML

viewing, G-13

performance

wildcard searches, 3-55

PKENCODE function, 8-20

plain text

bypassing filtering, 2-27

filtering to, 8-2, 8-13

highlight markup, 8-14

indexing, 2-28

indexing with NULL_FILTER, 2-30

offsets for highlighting, 8-10

populate index parameter, 1-37, 1-46

Portuguese

supplied stoplist, D-11

precedence of operators, 3-3

altering, 3-5, 4-2

equivalence operator, 3-16

example, 3-4

viewing, 10-6

preference classes

viewing, G-4

preference values

viewing, G-14

preferences

about, 2-2

creating, 7-30

dropping, 7-40

replacing, 1-4

specifying for indexing, 1-34

system-defined, 2-88

viewing, G-13

preferred term operator

example, 3-38

prefix_index attribute, 2-74

prefix_length_max attribute, 2-75

prefix_length_min attribute, 2-75

printjoins attribute, 2-40

privileges

required for indexing, 1-29

procedure attribute, 2-16

prove_themes attribute, 2-44

proximity operator, see NEAR operator

PT function, 12-40

PT operator, 3-38

punctuations attribute, 2-40

query

accumulate, 3-10

AND, 3-12

broader term, 3-13

equivalence, 3-16

example, 1-25

hierarchical feedback, 10-9

MINUS, 3-28

narrower term, 3-29

NOT, 3-36

OR, 3-37

preferred term, 3-38

related term, 3-39

stored, 3-42

synonym, 3-43

threshold, 3-45

top term, 3-50

translation term, 3-46

translation term synonym, 3-48

weighted, 3-52

query template, 1-19, 1-24

QUERY_PROCEDURE user_lexer attribute, 2-60

r_table_clause attribute, 2-78

rebuilding index

example, 1-10

syntax, 1-4

RECOVER procedure, 5-2

related term operator, 3-39

related term query feedback, 10-9

relevance ranking

word queries, F-2

REMOVE_EVENT procedure, 9-5

REMOVE_SECTION procedure, 7-47

REMOVE_SQE procedure, 10-14

REMOVE_STOPCLASS procedure, 7-49

REMOVE_STOPTHEME procedure, 7-50

REMOVE_STOPWORD procedure, 7-51

renaming index, 1-3

repeated field sections

querying, 3-59

replacing preferences, 1-4

reserved words and characters, 4-4

escaping, 4-3

result table

TOKENS, A-11

result tables, A-1

CTX_DOC, A-8

CTX_QUERY, A-2

CTX_THES, A-12

resuming failed index, 1-6

example, 1-10

RFC 1738 URL specification, 2-12

RT function, 12-42

RT operator, 3-39

RULE_CLASSIFIER type, 2-84

rules

generating, 6-2

Salton's formula for scoring, F-2

scope notes

finding, 12-44

SCORE operator, 1-51

scoring

accumulate, 3-10

effect of DML, F-3

for NEAR operator, 3-33

scoring algorithm

word queries, F-2

section group

creating, 7-33

viewing information about, G-15

section group example, 2-82

section group types, 2-81, 7-33

section searching, 3-56

nested, 3-58

sections

adding dynamically, 1-4

constraints for dynamic addition, 1-9

creating attribute, 7-3

creating field, 7-5

creating zone, 7-22

nested, 7-25

overlapping, 7-24

removing, 7-47

repeated field, 7-7

repeated zone, 7-24

viewing information on, G-14

SENTENCE keyword, 3-59

sentence section

defining, 7-11

querying, 3-56

server

shutting down, 5-5

viewing active, G-15

SET_ATTRIBUTE procedure, 7-52

SET_KEY_TYPE procedure, 8-22

SET_PARAMETER procedure, 2-92, 5-3

ShiftJis, 2-49

SHUTDOWN procedure, 5-5

Simplified Chinese

index defaults, 2-90

single-byte languages

indexing, 2-38

skipjoins attribute, 2-41

SN procedure, 12-44

soundex operator, 3-40

Spanish

fuzzy matching, 2-72

stemming, 2-71

supplied stoplist, D-12

special section

defining, 7-11

querying, 3-56

SQE operator, 3-42

SQL commands

ALTER INDEX, 1-2

CREATE INDEX, 1-29

DROP INDEX, 1-48

SQL operators

CONTAINS, 1-24

SCORE, 1-51

SQL*Loader

example, C-3

example control file, C-4

example data file, C-5

sqlldr example, C-3

START_LOG procedure, 9-6

startjoins attribute, 2-41

stem indexing, 2-44

stem operator, 3-41

stemmer attribute, 2-72

stemming, 2-72

automatic, 2-71

example for enabling, 2-75

stop section

adding dynamically, 1-9

dynamically adding example, 1-12

stop sections

adding, 7-14

stop_dic attribute, 2-52

stopclass

defining, 7-13

removing, 7-49

stoplist

creating, 7-36

Danish, D-5

dropping, 7-42

Dutch, D-6

English, D-2

Finnish, D-7

French, D-8

German, D-9

Italian, D-10

modifying, 2-86

multi-language, 2-46, 2-86

Portuguese, D-11

Spanish, D-12

Swedish, D-13

stoplists

about, 2-86

creating, 2-86

viewing, G-16

stoptheme

defining, 7-16

removing, 7-50

stopword

adding dynamically, 1-4, 1-7

defining, 7-17

removing, 7-51

viewing all in stoplist, G-16

stopword transformation, H-2

viewing, 10-6

stopwords

adding dynamically, 2-87

removing, 2-87

storage defaults, 2-79

storage index preference

example, 7-31

storage objects, 2-78

STORE_SQE procedure

example, 3-42

syntax, 10-15

stored queries, 3-42

stored query expression

creating, 10-15

removing, 10-14

viewing, G-24

viewing definition, G-16

sub-lexer values

viewing, G-8

sub-lexers

viewing, G-7, G-17, G-21

substring index

example for creating, 2-75

substring_index attribute, 2-73

supplied stoplists, D-1

Swedish

alternate spelling, E-5

index defaults, 2-89

supplied stoplist, D-13

SYN function, 12-45

SYN operator, 3-43

SYNC_INDEX procedure, 7-53

synonym operator, 3-43

system parameters, 2-92

defaults for indexing, 2-93

system recovery

manual, 5-2

system-defined preferences, 2-88

table structure

explain, A-2

filter, A-8

Gist, A-8

hfeedback, A-5

highlight, A-10

markup, A-10

theme, A-11

tagged text

searching, 3-56

template query, 1-19, 1-24

TEXT

format column value, 1-35

text column

supported types, 1-31

Text data dictionary

cleaning up, 5-2

text-only index

enabling, 2-44

example, 7-30

theme base, I-1

theme functionality

supported languages, 12-10

theme highlighting

generating markup, 8-14

generating offsets, 8-10

HTML markup example, 8-19

HTML offset example, 8-12

theme index

as default in English, 2-89

creating, 2-43

theme proving

enabling, 2-44

theme summary

generating, 8-5

generating top n, 8-8

theme table

structure, A-11

theme_language attribute, 2-44

themes

generating for document, 8-23

generating highlight markup, 8-14

highlight offset example, 8-12

indexing, 2-43

obtaining top n, 8-25

THEMES procedure

result table, A-11

syntax, 8-23

THES_TT procedure, 12-48

thesaurus

compiling, 12-6

creating, 12-20

creating relationships, 12-16

DEFAULT, 3-14

dropping, 12-27

import/export examples, 12-5

importing/exporting, 12-2

procedures for browsing, 12-1

renaming and truncating, 12-5

viewing information about, G-17

thesaurus import file

examples, C-11

structure, C-6

thesaurus phrases

altering, 12-3

dropping, 12-22

thesaurus relations

creating, 12-18

dropping, 12-24

thesaurus scope note

finding, 12-44

thesaurus top terms

finding all, 12-48

threshold operator, 3-45

stopword transformations, H-7

timeout attribute, 2-13

to_upper attribute, 2-52

token index optimization, 1-6

TOKENS procedure

result table, A-11

syntax, 8-26

top term operator, 3-50

TR function, 12-49

TR operator, 3-46

TRAIN procedure, 6-2

transformation

stopword, H-2

translation term operator, 3-46

translation term synonym operator, 3-48

translations

adding to thesaurus, 12-21

dropping, 12-28

updating, 12-55

TRSYN function, 12-51

TRSYN operator, 3-48

TT function, 12-53

TT operator, 3-50

UNIX platforms

setting variables for Inso, B-3

UNSET_ATTRIBUTE procedure, 7-55

UPDATE_TRANSLATION procedure, 12-55

URL syntax, 2-12

URL_DATASTORE object

attributes for, 2-12

example, 2-15

URL_DATASTORE system-defined preference, 2-88

urlsize attribute, 2-13

USER_DATASTORE object, 2-16

example, 2-17

USER_DATSTORE

filtering binary documents, 8-13

user_dic attribute, 2-52

USER_FILTER object, 2-31

example, 2-31

USER_LEXER object, 2-55

UTF-16 endian auto-detection, 2-24

UTF8, 2-49

UTF8 character set, 2-38, 2-48, 2-49, 2-50, 2-51

utilities

ctxload, 12-2

VARCHAR2 column

indexing, 1-31

verb_adjective attribute, 2-52

version numbers

viewing, G-26

viewing

operator expansion, 10-6

operator precedence, 10-6

views, G-1

visible flag for field sections, 7-6

visible flag in field sections, 3-58

weight operator, 3-52

stopword transformations, H-7

whitespace attribute, 2-42

wildcard queries

improving performance, 2-74

wildcard searches, 3-54

improving performance, 3-55

wildcard_maxterms attribute, 2-75

WILDCARD_TAB type, 13-1

WITHIN operator, 3-56

attribute sections, 3-59

limitations, 3-62

nested, 3-58

precedence, 3-4

stopword transformations, H-7

XML documents

attribute sections, 7-3

doctype sensitive sections, 7-24

indexing, 1-45, 2-82, 7-34

querying, 3-59

XML sectioning, 2-83

XML_SECTION_GROUP

example, 2-83

XML_SECTION_GROUP object, 1-45, 2-81, 7-33

XMLType column

indexing, 1-47

ZHS16CGB231280 character set, 2-47

ZHS16GBK character set, 2-48

ZHT16BIG5 character set, 2-48

ZHT32EUC character set, 2-48

ZHT32TRIS character set, 2-48

zone section

adding dynamically, 1-7

creating, 7-22

dynamically adding example, 1-11

querying, 3-56

repeating, 7-24

Index

Symbols

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Z