Index

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

Symbols

! operator, 3.1.5

- operator, 3.1.5

$ operator, 3.1.5

% wildcard, 3.1.5

* operator, 3.1.5

, operator, 3.1.5

? operator, 3.1.5

\ escape character, 4.2

_ wildcard, 3.1.5

{} escape character, 4.2

= operator, 3.1.5, 3.1.5, 3.1.5

> operator, 3.1.5

A

ABOUT query, 3.1.5

example, 3.1.5

highlight markup, 9, 9

highlight offsets, 9, 9

viewing expansion, 12

accumulate operator, 3.1.5

scoring, 3.1.5

stopword transformations, H.1.5

ADD_ATTR_SECTION procedure, 8

ADD_AUTO_OPTIMIZE procedure, 8

ADD_EVENT procedure, 11

ADD_FIELD_SECTION procedure, 8

ADD_INDEX procedure, 8

ADD_MDATA procedure, 8, 8

ADD_MDATA_SECTION procedure, 8

ADD_SDATA_COLUMN procedure, 8

ADD_SDATA_SECTION procedure, 8

ADD_SPECIAL_SECTION procedure, 8

ADD_STOP_SECTION procedure, 8

ADD_STOPCLASS procedure, 8

ADD_STOPTHEME procedure, 8

ADD_STOPWORD procedure, 8

ADD_SUB_LEXER procedure, 8

example, 2.4.3.3

ADD_TRACE procedure, 11

ADD_ZONE_SECTION procedure, 8

adding a trace, 11

adding an event, 11

adding metadata, 8, 8, 8

adding structured data, 8, 8

AL32UTF8 character set, 2.4.4.2, 2.4.6.2, 2.4.7.3, 2.4.8.2

ALTER INDEX

Add Section Constraints, 1

ALTER INDEX statement, 1

examples, 1

parameters syntax, 1

rebuild syntax, 1

rename syntax, 1

syntax overview, 1

ALTER TABLE

Composite Domain Index and, 1

UPDATE GLOBAL INDEXES, 1, 1, 1, 1

ALTER TABLE statement, 1

ALTER_PHRASE procedure, 14

ALTER_THESAURUS procedure, 14

alternate grammar template, 1

alternate language template, 1

alternate spelling, 17.1.1

about, 17.1

base letter, 17.1.2

Danish, 17.3.2

disabling example, 8, 17.1

enabling example, 17.1

German, 17.3.1

normalized vs. original, 17.1

overriding, 17.2

Swedish, 17.3.3

alternate_spelling attribute, 2.4.2.1, 17.1.1

alternative scoring template, 1

American

index defaults, 2.11.3.1.1

analyzing queries, 13.2

AND operator, 3.1.5

stopword transformations, H.1.3

Asian languages

and CTXRULE indexes, D.2.1.3

attribute section

adding dynamically, 1

defining, 8

dynamically adding, 1, 1

querying, 3.1.5

WITHIN example, 3.1.5

attributes

alternate_spelling, 2.4.2.1, 17.1.1

auto_filter_output_formatting, 2.3.4

base_letter, 2.4.2, 17.1.2, 17.1.2.1

base_letter_type, 2.4.2

binary, 2.2.3

charset, 2.3.1

command, 2.3.5

composite, 2.4.2

continuation, 2.4.2

detail_key, 2.2.3

detail_lineno, 2.2.3

detail_table, 2.2.3

detail_text, 2.2.3

disabling, 8, 8

endjoins, 2.4.2

ftp_proxy, 2.2.5.2

fuzzy_match, 2.5.1

fuzzy_numresults, 2.5.1

fuzzy_score, 2.5.1

http_proxy, 2.2.5.2

i_index_clause, 2.6.1

i_table_clause, 2.6.1

index_text, 2.4.2.1

index_themes, 2.4.2.1

k_table_clause, 2.6.1

maxthreads, 2.2.5.2

maxurls, 2.2.5.2

mixed_case, 2.4.2

n_table_clause, 2.6.1

new_german_spelling, 2.4.2.1, 17.1.3

newline, 2.4.2

no_proxy, 2.2.5.2

numgroup, 2.4.2

numjoin, 2.4.2

output_type, 2.2.6.2

override_base_letter, 17.2.1

p_table_clause, 2.6.1

path, 2.2.4

printjoins, 2.4.2

procedure, 2.2.6

punctuations, 2.4.2

r_table_clause, 2.6.1

setting, 8, 8

skipjoins, 2.4.2

startjoins, 2.4.2

stemmer, 2.5.1

timeout, 2.2.5.2

urlsize, 2.2.5.2

viewing, G.17

viewing allowed values, G.18

whitespace, 2.4.2

auto optimization

add indexes, 8

add partitions, 8

remove indexes, 8

remove partitions, 8

AUTO stemming, 2.5.1

AUTO_FILTER Document Filtering Technology

Supported Platforms for, B.1.3

AUTO_FILTER filter, 2.3.2

and transactional CONTEXT indexes, 1

character set conversion, 2.3.2.3

index preference object, 2.3.2

setting up, B.1

supported formats, B.2

supported platforms, B.1.3, B.1.3.1

unsupported formats, B.1.2

AUTO_FILTER system-defined preference, 2.11.2.2

AUTO_FILTER_OUTPUT_FORMATTING attribute, 2.3.4

AUTO_SECTION_GROUP example, 2.7.1.3

AUTO_SECTION_GROUP object, 1, 2.7, 8

AUTO_SECTION_GROUP system-defined preference, 2.11.4.4

automatic index synchronization, 1, 1

available traces, 11

B

backslash escape character, 4.2

base_letter attribute, 2.4.2, 17.1.2

base_letter_type attribute, 2.4.2, 17.1.2.1

base-letter conversions, 17.1.2, 17.1.2.1

base-letter conversions, overriding, 17.2.1

BASIC_LEXER object, 2.4.2

supported character sets, 2.4.2

BASIC_LEXER system-defined preference, 2.11.3.3

BASIC_LEXER type

example, 2.4.2.2

BASIC_SECTION_GROUP object, 1, 2.7, 8

BASIC_STOPLIST type, 8

BASIC_STORAGE object

attributes for, 2.6.1

defaults, 2.6.1.1

example, 2.6.1.2

BASIC_WORDLIST object

attributes for, 2.5.1

example, 2.5.2

BFILE column

indexing, 1

big_io, 2.6.1

binary attribute, 2.2.3, 2.2.7

binary documents

filtering, 2.2.2

BINARY format column value, 1

BLOB column

indexing, 1

loading example, C.2

brace escape character, 4.2

brackets

altering precedence, 3.1.5, 4.1

grouping character, 4.1

broader term operators

example, 3.1.5

broader term query feedback, 12

BROWSE_WORDS procedure, 12

browsing words in index, 12

BT function, 14

BT operator, 3.1.5

BTG function, 14

BTG operator, 3.1.5

BTI function, 14

BTI operator, 3.1.5

BTP function, 14

BTP operator, 3.1.5

C

case-sensitive

ABOUT queries, 3.1.5

case-sensitive index

creating, 2.4.2

CATSEARCH operator, 1

CHAR column

indexing, 1

character sets

Chinese, 2.4.4.2

conversion with AUTO_FILTER, 2.3.2.3

indexing mixed columns, 2.3.1.2

Japanese, 2.4.6.2

Korean, 2.4.8.2

characters

continuation, 2.4.2

numgroup, 2.4.2

numjoin, 2.4.2

printjoin, 2.4.2

punctuation, 2.4.2

skipjoin, 2.4.2

specifying for newline, 2.4.2

specifying for whitespace, 2.4.2

startjoin and endjoin, 2.4.2

charset attribute, 2.3.1

charset column, 1

CHARSET_FILTER

attributes for, 2.3.1

mixed character set example, 2.3.1.2.1

Chinese

fuzzy matching, 2.5.1

Chinese character sets supported, 2.4.4.2

Chinese lexicon, modifying, 16.4

Chinese text

indexing, 2.4.4

CHINESE_LEXER, 2.10.2

CHINESE_LEXER Attribute, 2.4.5.1

CHINESE_VGRAM_LEXER object, 2.4.4

classifying documents, 7

clustering, 2.9, 7

CLOB column

indexing, 1

clump, 3.1.5

clump size in near operator, 3.1.5

CLUSTER_NUM, 2.9.1

clustering, 2.9, 7

KMEAN_CLUSTERING, 2.9.1

types, 2.9

CLUSTERING procedure, 7

clustering types, 2.9

columns types

supported for CTXCAT index, 1

supported for CTXRULE index, 1

supported for indexing, 1

command attribute, 2.3.5

compiler, lexical, 16.4

compMem element, 2.4.9.9

composite attribute

BASIC_LEXER, 2.4.2

KOREAN_MORPH_LEXER, 2.4.8.4

composite domain index, 1

composite textkey

encoding, 9

composite word dictionary, 2.4.2.1

composite word index

creating for German or Dutch text, 2.4.2

composite words

viewing, 12

concordance, 9

CONTAINS operator

example, 1

syntax, 1

CONTEXT index

about, 1

default parameters, 2.12.2.1

syntax, 1

context indextype, 1

continuation attribute, 2.4.2

control file example

SQL*Loader, C.2.2.1

COPY_POLICY procedure, 8

CREATE INDEX statement, 1

CONTEXT, 1

CTXCAT, 1

CTXRULE, 1

default parameters, 2.12.2, 2.12.3

failure, 5

CREATE_INDEX_SCRIPT procedure, 13.2

CREATE_INDEX_SET procedure, 8, 8, 8

CREATE_PHRASE procedure, 14

CREATE_POLICY procedure, 8

CREATE_POLICY_SCRIPT procedure, 13.2

CREATE_PREFERENCE procedure, 8

CREATE_RELATION procedure, 14

CREATE_SECTION_GROUP procedure, 8

CREATE_STOPLIST procedure, 8

CREATE_THESAURUS function, 14

CREATE_TRANSLATION procedure, 14

creating an index report, 13.2

CTX_ADM package

MARK_FAILED, 5

RECOVER, 5

RESET_AUTO_OPTIMIZE_STATUS, 5

SET_PARAMETER, 5

CTX_ADM.MARK_FAILED, 5

CTX_AUTO_OPTIMIZE_INDEXES view, G.2

CTX_AUTO_OPTIMIZE_STATUS view, G.3

CTX_CLASSES view, G.4, G.5, G.6, G.19, G.39, G.49

CTX_CLS

CLUSTERING, 7

TRAIN, 7

CTX_DDL package

ADD_ATTR_SECTION, 8

ADD_AUTO_OPTIMIZE, 8

ADD_FIELD_SECTION, 8

ADD_MDATA, 8, 8

ADD_MDATA_SECTION, 8

ADD_SDATA_COLUMN, 8

ADD_SDATA_SECTION, 8

ADD_SPECIAL_SECTION, 8

ADD_STOP_SECTION, 8

ADD_STOPCLASS, 8

ADD_STOPTHEME, 8

ADD_STOPWORD, 8

ADD_SUB_LEXER, 8

ADD_ZONE_SECTION, 8

COPY_POLICY, 8

CREATE_INDEX_SET, 8, 8, 8

CREATE_POLICY, 8

CREATE_PREFERENCE, 8

CREATE_SECTION_GROUP, 8

CREATE_STOPLIST, 8

DROP_POLICY, 8

DROP_PREFERENCE, 8

DROP_STOPLIST, 8

OPTIMIZE_INDEX procedure, 8

PREFERENCE_IMPLICIT_COMMIT variable, 8

REMOVE_AUTO_OPTIMIZE, 8

REMOVE_MDATA, 8

REMOVE_SECTION, 8

REMOVE_STOPCLASS, 8

REMOVE_STOPTHEME, 8

REMOVE_STOPWORD, 8

REMOVE_SUB_LEXER, 8

REPLACE_INDEX_METADATA, 8

SET_ATTRIBUTE, 8

SET_SECTION_ATTRIBUTE, 8

SYNC_INDEX procedure, 8

UNSET_ATTRIBUTE, 8, 8

UPDATE_SUB_LEXER, 8

CTX_DDL.ADD_INDEX procedure, 8

CTX_DOC package, 9

FILTER, 9

GIST, 9

HIGHLIGHT, 9

IFILTER, 9

MARKUP, 9

PKENCODE, 9

POLICY_FILTER, 9

POLICY_GIST, 9

POLICY_HIGHLIGHT, 9

POLICY_MARKUP, 9

POLICY_SNIPPET, 9

POLICY_THEMES, 9

POLICY_TOKENS, 9

result tables, A.2

SET_KEY_TYPE, 9

SNIPPET, 9

THEMES, 9

TOKENS, 9

CTX_DOC_KEY_TYPE system parameter, 2.12.1

CTX_FEEDBACK_ITEM_TYPE type, A.1.2.3

CTX_FEEDBACK_TYPE type, 12, A.1.2.3

CTX_FILTER_CACHE_STATISTICS view, G.6

CTX_INDEX_ERRORS view, G.8

example, 1

CTX_INDEX_OBJECTS view, G.9

CTX_INDEX_SET_INDEXES view

views

CTX_INDEX_SET_INDEXES, G.12

CTX_INDEX_SUB_LEXERS view, G.13, G.47

CTX_INDEX_SUB_LEXERS_VALUES view, G.14

CTX_INDEX_VALUES view, G.15

CTX_INDEXES view, G.7

CTX_OBJECT_ATTRIBUTE_LOV view, G.18

CTX_OBJECT_ATTRIBUTES view, G.17

CTX_OBJECTS view, G.16

CTX_OUTPUT package, 11

ADD_EVENT, 11

ADD_TRACE, 11

DISABLE_QUERY_STATS, 11

ENABLE_QUERY_STATS, 11

END_LOG, 11

GET_TRACE_VALUE, 11

LOG_TRACES, 11

LOGFILENAME, 11

REMOVE_EVENT, 11

REMOVE_TRACE, 11

RESET_TRACE, 11

START_LOG, 11

CTX_PARAMETERS view, 2.12, G.20

CTX_PENDING view, G.21

CTX_PREFERENCE_VALUES view, G.23

CTX_PREFERENCES view, G.22

CTX_QUERY package

BROWSE_WORDS, 12

EXPLAIN, 12

HFEEDBACK, 12

REMOVE_SQE, 12

result tables, A.1

STORE_SQE, 12

CTX_QUERY.disable_transactional_query session variable, 1

CTX_REPORT output format, 13.2, 13.2, 13.2, 13.2, 13.2

CTX_REPORT package, 13

CREATE_INDEX_SCRIPT, 13.2

CREATE_POLICY_SCRIPT, 13.2

DESCRIBE_INDEX, 13.2

DESCRIBE_POLICY, 13.2

function versions of procedures, 13.2

INDEX_SIZE, 13.2

INDEX_STATS, 13.2

QUERY_LOG_SUMMARY, 13.2

TOKEN_INFO, 13.2

TOKEN_TYPE, 13.2

CTX_SECTION_GROUPS view, G.25

CTX_SECTIONS view, G.24

CTX_SQES view, G.26

CTX_STOPLISTS view, G.27

CTX_STOPWORDS view, G.28

CTX_SUB_LEXERS view, G.29

CTX_THES package, 14

ALTER_PHRASE, 14

ALTER_THESAURUS, 14

BT, 14

BTG, 14

BTI, 14

BTP, 14

CREATE_PHRASE, 14

CREATE_RELATION, 14

CREATE_THESAURUS, 14

DROP_PHRASE, 14

DROP_RELATION, 14

DROP_THESAURUS, 14

NT, 14

NTG, 14

NTI, 14

NTP, 14

OUTPUT_STYLE, 14

PT, 14

result tables, A.3

RT, 14

SN, 14

SYN, 14

THES_TT, 14

TR, 14

TRSYN, 14

TT, 14

CTX_THESAURI view, G.30

CTX_THES.CREATE_TRANSLATION, 14

CTX_THES.DROP_TRANSLATION, 14

CTX_THES.UPDATE_TRANSLATION, 14

CTX_TRACE_VALUES view, G.32

CTX_ULEXER package, 15

CTX_USER_AUTO_OPTIMIZE_STATUS view, G.34

CTX_USER_INDEX_ERRORS view, G.41

example, 1

CTX_USER_INDEX_OBJECTS view, G.42

CTX_USER_INDEX_SET_INDEXES view, G.45

CTX_USER_INDEX_SETS view, G.44

CTX_USER_INDEX_SUB_LEXERS view, G.46

CTX_USER_INDEX_VALUES view, G.48

CTX_USER_INDEXES view, G.40

CTX_USER_PENDING view, G.50

CTX_USER_PREFERENCE_VALUES view, G.52

CTX_USER_PREFERENCES view, G.51

CTX_USER_SECTION_GROUPS view, G.54

CTX_USER_SECTIONS view, G.53

CTX_USER_SQES view, G.55, G.56

CTX_USER_STOPLISTS view, G.57

CTX_USER_STOPWORDS view, G.58

CTX_USER_SUB_LEXERS view, G.59

CTX_USER_THES_PHRASES view, G.61

CTX_USER_THESAURI view, G.60

CTX_VERSION view, G.62

CTXCAT index

about, 1

default parameters, 2.12.2.2

supported preferences, 1

syntax, 1

unsupported preferences, 1

CTXFILTERCACHE operator, 3.1.5

ctxkbtc complier, 16.3

ctxlc (lexical compiler), 16.4

ctxload, 16.1

examples, 16.1.3.1

import file structure, C.3

CTXRULE index

about, 1

and Asian languages, D.2.1.3

and multilingual support, D.2.1.3

and USER_LEXER, 2.4.9.1

default parameters, 2.12.2.3

lexer types, 1

syntax, 1

CTXRULE Index Limitations, 2.12.2.3

CTXSYS.AUTO_FILTER system preference, 2.3.2.1

CTXSYS.DEFAULT_STOPLIST, 2.10.3

CTXSYS.INSO_FILTER system preference (deprecated), 2.3.2.1

D

d_table_clause, 2.6.1

Danish

alternate spelling, 17.3.2

index defaults, 2.11.3.1.2

supplied stoplist, E.4

data storage

defined procedurally, 2.2.6

direct, 2.2.1

example, 8

external, 2.2.4

master/detail, 2.2.3

URL, 2.2.5

datastore types, 2.2

DATE column, 1

DBMS_PCLUTIL

BUILD_PART_INDEX, 1

default index

example, 1

default parameters

changing, 2.12.2.5

CONTEXT index, 2.12.2.1

CTXCAT index, 2.12.2.2

CTXRULE index, 2.12.2.3

viewing, 2.12.2.4

DEFAULT thesaurus, 3.1.5, 3.1.5

DEFAULT_CTXCAT_INDEX_SET system parameter, 2.12.2.2

DEFAULT_CTXCAT_LEXER system parameter, 2.12.2.2

DEFAULT_CTXCAT_STOPLIST system parameter, 2.12.2.2

DEFAULT_CTXCAT_STORAGE system parameter, 2.12.2.2

DEFAULT_CTXCAT_WORDLIST system parameter, 2.12.2.2

DEFAULT_CTXRULE_LEXER system parameter, 2.12.2.3

DEFAULT_CTXRULE_STOPLIST system parameter, 2.12.2.3

DEFAULT_CTXRULE_WORDLIST system parameter, 2.12.2.3, 2.12.2.3

DEFAULT_DATASTORE system parameter, 2.12.2.1

DEFAULT_DATASTORE system-defined indexing preference, 2.11.1.1

DEFAULT_FILTER_BINARY system parameter, 2.12.2.1, 2.12.3

DEFAULT_FILTER_FILE system parameter, 2.12.2.1

DEFAULT_FILTER_TEXT system parameter, 2.12.2.1, 2.12.3

DEFAULT_INDEX_MEMORY system parameter, 2.12.1

DEFAULT_LEXER system parameter, 2.12.2.1, 2.12.3

DEFAULT_LEXER system-defined indexing preference, 2.11.3.1

DEFAULT_RULE_STORAGE system parameter, 2.12.2.3

DEFAULT_SECTION_HTML system parameter, 2.12.2.1, 2.12.3

DEFAULT_SECTION_TEXT system parameter, 2.12.2.1, 2.12.3

DEFAULT_STOPLIST system parameter, 2.12.2.1, 2.12.3

DEFAULT_STOPLIST system-defined preference, 2.11.5.1

DEFAULT_STORAGE system parameter, 2.12.2.1

DEFAULT_STORAGE system-defined preference, 2.11.6.1

DEFAULT_WORDLIST system parameter, 2.12.2.1, 2.12.3

DEFAULT_WORDLIST system-defined preference, 2.11.7.1

defaults for indexing

viewing, G.20

definemerge operator, 3.1.5

definescore operator, 3.1.5

derivational stemming

enabling for English, 2.5.1

DESCRIBE_INDEX procedure, 13.2

DESCRIBE_POLICY procedure, 13.2

describing an index, 13.2

DETAIL_DATASTORE object, 2.2.3

example, 2.2.3.2

detail_key attribute, 2.2.3

detail_lineno attribute, 2.2.3

detail_table attribute, 2.2.3

detail_text attribute, 2.2.3

dictionary

Chinese, 16.4

Japanese, 16.4

Korean, 2.4.8.1

modifying, 16.4

user, 2.4.2.1

DIRECT_DATASTORE object, 2.2.1

example, 2.2.1.1

DISABLE_QUERY_STATS procedure, 11

disabling transactional queries, 1

disambiguators

in thesaural queries, 3.1.5

in thesaurus import file, C.3.2

DML

affect on scoring, F.1.2

DML errors

viewing, G.8

DML processing

batch, 1

DML queue

viewing, G.21

document

classifying, 7

clustering, 7

filtering to HTML and plain text, 9

document filtering

AUTO_FILTER, B.1

document formats

supported, B.2

unsupported, B.1.2

document loading

SQL*Loader, C.2

document presentation

procedures, 9

document services

logging

requests, 11

domain index, 1

double-truncated queries, 3.1.5

double-truncated searching

improving performance, 2.5.1

DROP INDEX statement, 1

DROP_PHRASE procedure, 14

DROP_POLICY procedure, 8

DROP_PREFERENCE procedure, 8

DROP_RELATION procedure, 14

DROP_STOPLIST procedure, 8

DROP_THESAURUS procedure, 14

DROP_TRANSLATION procedure, 14

duplicating indexes with scripts, 13.2

duplicating policy with script, 13.2

Dutch

composite word indexing, 2.4.2

fuzzy matching, 2.5.1

index defaults, 2.11.3.1.3

stemming, 2.5.1

supplied stoplist, E.5

E

e_table_clause, 2.6.1

e-mail

filtering and indexing, 2.3.4

embedded graphics, B.2.4

empty index

creating, 1

POPULATE | NOPOPULATE and, 1

EMPTY_STOPLIST system-defined preference, 2.11.5.2

ENABLE_QUERY_STATS procedure, 11

enabling tracing, 11

END_LOG procedure, 11

END_QUERY_LOG procedure, 11

ending a log, 11

ending a query log, 11

endjoins attribute, 2.4.2

English

fuzzy matching, 2.5.1

index defaults, 2.11.3.1.1

supplied stoplist, E.1

english attribute (Korean lexer), 2.4.8.4

entity extraction, 10

environment variables

setting for AUTO_FILTER filter, B.1.6

equivalence operator, 3.1.5

stopword transformations, H.1.9

with NEAR, 3.1.5

errors

indexing, 1

escaping special characters, 4.2

event

adding, 11

removing, 11

EVERY parameter, 1, 1

EXP_TAB table type, A.3.1

expansion operator

soundex, 3.1.5

stem, 3.1.5

viewing, 12

EXPLAIN procedure, 12

example, 12

result table, A.1.1

explain table

creating, 12

retrieving data example, 12

structure, A.1.1

EXPORT_THESAURUS procedure, 14

extending knowledge base, 16.3

external filters

specifying, 2.3.5

F

failed index operation

resuming, 1

failure of index loading, 5

fast filtering, 2.3.4

field section

adding dynamically, 1

defining, 8

limitations, 8

querying, 3.1.5

repeated, 3.1.5

WITHIN example, 3.1.5

file data storage

example, 8

FILE_DATASTORE object, 2.2.4

example, 2.2.4.3

FILE_DATASTORE system-defined preference, 2.11.1.2

filter

INSO (deprecated), 2.3.2

filter attribute

MULTI_COLUMN_DATASTORE, 2.2.2

FILTER BY, 1

FILTER BY and ORDER BY with creating an index example, 1

filter formats

supported, B.2

FILTER procedure, 9

example, 9

in-memory example, 9

result table, A.2.1

filter table

structure, A.2.1

filter types, 2.3

filtering

fast, with AUTO_FILTER_OUTPUT_FORMATTING attribute, 2.3.4

multi_column_datastore, 2.2.2

stored procedures, 2.3.6

to plain text, 9

to plain text and HTML, 9

filters

AUTO_FILTER, 2.3.2, B.1

character-set, 2.3.1

user, 2.3.5

Finnish

index defaults, 2.11.3.1.5

supplied stoplist, E.6

format column, 1

formatted documents

filtering, 2.3.2

forward_index, 2.6.1

fragmentation of index, 1

French

fuzzy matching, 2.5.1

supplied stoplist, E.7

French stemming, 2.5.1

ftp_proxy attribute, 2.2.5.2

fuzzy matching

automatic language detection, 2.5.1

example for enabling, 2.5.2

specifying a language, 2.5.1

fuzzy operator, 3.1.5

fuzzy_match attribute, 2.5.1

fuzzy_numresults attribute, 2.5.1

fuzzy_score attribute, 2.5.1

G

g_index_clause, 2.6.1

g_table_clause, 2.6.1

German

alternate spelling attribute, 2.4.2.1

alternate spelling conventions, 17.3.1

composite word indexing, 2.4.2

fuzzy matching, 2.5.1

index defaults, 2.11.3.1.4

new spelling, querying with, 2.4.2.1, 17.1.3

stemming, 2.5.1

supplied stoplist, E.8

GET_TRACE_VALUE procedure, 11

gist

generating, 9

generating with POLICY_GIST, 9

GIST procedure

example, 9

result table, A.2.2

updated syntax, 9

Gist table

structure, A.2.2

graphics

embedded, B.2.4

standalone, B.2.4

H

hanja attribute, 2.4.8.4

HASPATH operator, 3.1.5

and special characters, 3.1.5

HFEEDBACK procedure, 12

example, 12

result table, A.1.2

hierarchical query feedback information

generating, 12

hierarchical relationships

in thesaurus import file, C.3.1

HIGHLIGHT procedure, 9

example, 9

result table, A.2.3

highlight table

example, 9, 9

structure, A.2.3

highlighting

generating markup, 9, 9

generating offsets, 9, 9

with NEAR operator, 3.1.5

homographs

in broader term queries, 3.1.5

in queries, 3.1.5

in thesaurus import file, C.3.2

HTML

bypassing filtering, 2.3.2.2

filtering to, 9

generating, 9

generating highlight offsets for, 9, 9

highlight markup, 9, 9

highlighting example, 9

indexing, 1, 2.3.3.1, 2.7, 8

zone section example, 8

HTML_SECTION_GROUP

example, 2.7.1.1

HTML_SECTION_GROUP object, 1, 2.7, 8, 8

with NULL_FILTER, 2.3.3.1

HTML_SECTION_GROUP system-defined preference, 2.11.4.2, 2.11.4.3

http_proxy attribute, 2.2.5.2

I

i_index_clause attribute, 2.6.1

i_rowid_index_clause, 2.6.1

i_table_clause attribute, 2.6.1

IFILTER procedure, 9

IGNORE format column value, 1

import file

examples of, C.3.4

structure, C.3

IMPORT_THESAURUS procedure, 14

index

creating, 1

creating a report on, 13.2

creating index script, 13.2

describing, 13.2

duplicating with script, 13.2

loading failure, 5

renaming, 1

script, 13.2

show size of objects, 13.2

show statistics, 13.2

synchronizing, 1, 1

transactional, 12

transactional CONTEXT, 1, 1

viewing registered, G.7

index creation

custom preference example, 1

default example, 1

index creation parameters

example, 2.6.1.2

index errors

deleting, 1

viewing, 1

index fragmentation, 1

index maintenance, 1

index objects, 2

viewing, G.9, G.16

index preference

about, 2.1

creating, 2.1.1, 8

index reports, 13

index requests

logging, 11

index status, 5

index tablespace parameters

specifying, 2.6

index tokens

generating for a document, 9, 9

INDEX_PROCEDURE user_lexer attribute, 2.4.9.3

INDEX_SIZE procedure, 13.2

INDEX_STATS procedure, 13.2

index_stems

attributes, 2.4.2

index_stems attribute, 2.4.2.1

index_text attribute, 2.4.2.1

index_themes attribute, 2.4.2.1

indexing

master/detail example, 2.2.3.2.4

multilingual documents, 2.4.3, 2.4.10, D.2.5

parallel, 1, 1

themes, 2.4.2.1

indexing types

classifier, 2.8.1

clustering, 2.9

datastore, 2.2

filter, 2.3

lexer, 2.4

section group, 2.7

storage, 2.6

vs. preferences, 2.1.1

wordlist, 2.5

indexless document services, see policy-based document services

index-organized table, 1

indextype context, 1

inflectional stemming

enabling, 2.5.1

INPATH operator, 3.1.5

and special characters, 3.1.5

INPUT_TYPE user_lexer attribute, 2.4.9.4

INSERT statement

loading example, C.1

INSO_FILTER (deprecated), 2.3.2

inverse frequency scoring, F.1

Italian

fuzzy matching, 2.5.1

stemming, 2.5.1

supplied stoplist, E.9

J

JA16EUC character set, 2.4.6.2, 2.4.7.3

JA16EUCTILDE character set, 2.4.6.2, 2.4.7.3

JA16EUCYEN character set, 2.4.6.2, 2.4.7.3

JA16SJIS character set, 2.4.6.2, 2.4.7.3

JA16SJISTILDE character set, 2.4.6.2, 2.4.7.3

JA16SJISYEN character set, 2.4.6.2, 2.4.7.3

Japanese

fuzzy matching, 2.5.1

index defaults, 2.11.3.1.6

indexing, 2.4.6

stemming, 2.5.1

japanese attribute (Korean lexer), 2.4.8.4

Japanese character sets supported, 2.4.6.2

Japanese EUC character se, 2.4.7

Japanese lexicon, modifying, 16.4

Japanese stemming, 2.5.1, 3.1.5

JAPANESE_LEXER, 2.4.7, 2.10.2

JAPANESE_LEXER Attributes, 2.4.7.2

JAPANESE_VGRAM_LEXER Attributes, 2.4.6.1

JAPANESE_VGRAM_LEXER object, 2.4.6

JOB_QUEUE_PROCESSES initialization parameter, 1

JSON_SECTTION_GROUP, 2.7

K

k_table_clause attribute, 2.6.1

Key Word in Context. See KWIC

KMEAN_CLUSTERING object, 2.9.1

knowledge base

supported character set, 16.3.1

user-defined, 16.3.8

knowledge base extension compiler, 16.3

KO16KSC5601 character set, 2.4.8.2

KO16MSWIN949 character set, 2.4.8.2

Korean

fuzzy matching, 2.5.1

index defaults, 2.11.3.1.7

unicode character support, 2.4.8.3

korean character sets supported, 2.4.8.2

Korean text

indexing, 2.4.8

KOREAN_MORPH_LEXER, 2.4.8

composite example, 2.4.8.6

supplied dictionaries, 2.4.8.1

Unicode support, 2.4.8.3

KOREAN_MORPH_LEXER Attributes, 2.4.8.4

KWIC (Key Word in Context), 9

L

language

setting, 2.4

language column, 1

language-independent lexer template, 1

left-truncated searching

improving performance, 2.5.1

lexer types, 2.4

and CTXRULE index, 1

lexical compiler, 16.4

lexicon. See entries under dictionary

loading text

SQL INSERT example, C.1

SQL*Loader example, C.2

loading thesaurus, 16.1

LOB columns

loading, C.2

local partition index

parallelism, 1

local partitioned index, 1

LOG_DIRECTORY system parameter, 2.12.1, 11

LOG_TRACES procedure, 11

LOGFILENAME procedure, 11

logging

ending, 11

ending a log, 11

getting log file name, 11

index requests, 11

logging queries, 13.2

logging traces, 11

logical operators

with NEAR, 3.1.5

LONG columns

indexing, 1

long_word attribute, 2.4.8.4

M

mail filter configuration file, 2.3.4.2

mail filtering, see e-mail, 2.3.4

MAIL_FILTER object, 2.3.4

MAIL_FILTER_CONFIG_FILE system parameter, 2.3.4.2

maintaining index, 1

MARK_FAILED procedure, 5

MARKUP procedure, 9

example, 9

HTML highlight example, 9

result table, A.2.4

markup table

example, 9

structure, A.2.4

master/detail data storage, 2.2.3

example, 2.2.3.2, 8

master/detail tables

indexing example, 2.2.3.2.4

MATCH_SCORE operator, 1

MATCHES operator, 1, 1

MAX_DOCTERMS, 2.8.2, 2.9.1

MAX_FEATURES, 2.8.2, 2.9.1

MAX_INDEX_MEMORY system parameter, 2.12.1

max_span parameter in near operator, 3.1.5

MAX_TERMS, 2.8.1

maxthreads attribute, 2.2.5.2

maxurls attribute, 2.2.5.2, 2.2.5.2

MDATA operator, 3.1.5

MDATA section, 8, 8, 8, 8

memory

for indexing, 1, 8

MEMORY_SIZE, 2.8.1, 2.8.2, 2.9.1

META tag

creating field sections for, 8

creating zone section for, 8

metadata, 1, 3.1.5

replacing, 8

METADATA keyword, 1

ALTER INDEX example, 1

metadata section, 8, 8, 8, 8

MINUS operator, 3.1.5

stopword transformations, H.1.6

mixed character-set columns

indexing, 2.3.1.2

mixed_case attribute, 2.4.2

mixed-format columns

filtering, 2.3.2

indexing, 2.3.2.2

supported formats for, B.2

modifying user dictionary, 16.4

morpheme attribute, 2.4.8.4

MULTI_COLUMN_DATASTORE Restriction, 2.2.2.2

MULTI_LEXER object

CREATE INDEX example, 1

example, 2.4.3.3

MULTI_LEXER type, 2.4.3

MULTI_STOPLIST type, 8

multi-language indexing, 2.4.3, 2.4.10, 8, D.2.5

multi-language stoplist, 2.4.3.2, 2.10.1

multi-language tables

querying, 1, 2.4.3.4

multi-lexer example

migrating from single language, 1

N

n_table_clause attribute, 2.6.1

narrower term operators

example, 3.1.5

narrower term query feedback, 12

NEAR operator

backward compatibility, 3.1.5

highlighting, 3.1.5

scoring, 3.1.5

stopword transformations, H.1.10

with other operators, 3.1.5

with within, 3.1.5

nested section searching, 3.1.5

nested zone sections, 8

nested_column attribute, 2.2.7

NESTED_DATASTORE attribute, 2.2.7.1

NESTED_DATASTORE object, 2.2.7

nested_lineno attribute, 2.2.7

nested_text attribute, 2.2.7

nested_type attribute, 2.2.7

new_german_spelling attribute, 2.4.2.1, 17.1.3

newline attribute, 2.4.2

NEWS_SECTION_GROUP object, 2.7, 8

NLS_LENGTH_SEMANTICS parameter, 1

no_proxy attribute, 2.2.5.2

nopopulate index parameter, 1

nopopulate parameter, 1

normalization_expr attribute, 1

normalized word forms, 17.1

Norwegian

index defaults, 2.11.3.1.5

NOT operator, 3.1.5

stopword transformations, H.1.8

NT function, 14

NT operator, 3.1.5

NT_THRESHOLD, 2.8.1

NTG function, 14

NTG operator, 3.1.5

NTI function, 14

NTI operator, 3.1.5

NTP function, 14

NTP operator, 3.1.5

NULL_FILTER object, 2.3.3

NULL_FILTER system-defined preference, 2.11.2.1

NULL_SECTION_GROUP object, 2.7, 8

NULL_SECTION_GROUP system-defined preference, 2.11.4.1

number attribute, 2.4.8.4

NUMBER column, 1

numgroup attribute, 2.4.2

numjoin attribute, 2.4.2

O

o_table_clause, 2.6.1

object values

viewing, G.15

objects

viewing index, G.16

offsets for highlighting, 9, 9

on commit, 1, 1

one_char_word attribute, 2.4.8.4

ONLINE

CREATE INDEX and, 1

OPERATION column of explain table

values, A.1.1.1

OPERATION column of hfeedback table

values, A.1.2.1

operator

ABOUT, 3.1.5

accumulate, 3.1.5

broader term, 3.1.5

equivalence, 3.1.5

fuzzy, 3.1.5

HASPATH, 3.1.5

INPATH, 3.1.5

MATCH_SCORE, 1

MATCHES, 1

MDATA, 3.1.5

MINUS, 3.1.5

narrower term, 3.1.5

NEAR

NOT, 3.1.5

OR, 3.1.5

preferred term, 3.1.5

related term, 3.1.5

SCORE, 1

scoring, 3.1.5, 3.1.5

SDATA, 3.1.5

soundex, 3.1.5

SQE, 3.1.5

stem, 3.1.5

synonym, 3.1.5

threshold, 3.1.5

top term, 3.1.5

TRANSFORM, 1

translation term, 3.1.5, 3.1.5

translation term synonym, 3.1.5

weight, 3.1.5

WITHIN, 3.1.5

operator expansion

viewing, 12

operator precedence, 3.1

examples, 3.1.4

viewing, 12

operators, 3

optimization, 8

strategies, 8

OPTIMIZE_INDEX procedure, 8

OPTIONS column

explain table, A.1.1.2

hfeedback table, A.1.2.2

OR operator, 3.1.5

stopword transformations, H.1.4

ORDER BY, 1

Limitations with PL/SQL Packages, 1

original word forms, 17.1

OUTPUT_STYLE procedure, 14

output_type attribute, 2.2.6.2

overlapping zone sections, 8

override_base_letter attribute, 17.2.1

overriding alternate spelling, 17.2

overriding base-letter conversions, 17.2.1

P

p_table_clause, 2.6.1

PARAGRAPH keyword, 3.1.5

paragraph section

defining, 8

querying, 3.1.5

parallel index creation, 1

parallel indexing, 1, 1, 1

DBMS_PCLUTIL.BUILD_PART_INDEX, 1

example, 1

local partitioned index, 1

parameter

transactional, 1, 1

parameters

setting, 5

viewing system-defined, G.20

parentheses

altering precedence, 3.1.5, 4.1

grouping character, 4.1

partitioned index

creating local in parallel, 1

example, 1

local, 1

parallel creation, 1

rebuild example, 1

partitioned index creation

example, 1

partitioned tables

modifying, 1

parts-of-speech tagging, I

path attribute, 2.2.4

PATH_SECTION_GROUP

querying with, 3.1.5

PATH_SECTION_GROUP object, 2.7, 8

PATH_SECTION_GROUP system-defined preference, 2.11.4.5

pending DML

viewing, G.21

performance

wildcard searches, 3.1.5

PKENCODE function, 9

plain text

bypassing filtering, 2.3.2.2

filtering to, 9, 9

highlight markup, 9, 9

indexing with NULL_FILTER, 2.3.3.1

offsets for highlighting, 9

policy, 9

create script, 13.2

duplicate with script, 13.2

report describing, 13.2

POLICY_FILTER procedure, 9

POLICY_GIST procedure, 9

POLICY_HIGHLIGHT procedure, 9

POLICY_MARKUP procedure, 9

POLICY_SNIPPET procedure, 9

POLICY_THEMES procedure

syntax, 9

POLICY_TOKENS procedure

syntax, 9

policy-based document services, 9

populate index parameter, 1

populate parameter, 1

Portuguese

supplied stoplist, E.10

precedence of operators, 3.1

altering, 3.1.5, 4.1

equivalence operator, 3.1.5

example, 3.1.4

viewing, 12

preference classes

viewing, G.4, G.5, G.6, G.19, G.39, G.49

preference values

viewing, G.23

PREFERENCE_IMPLICIT_COMMIT, 8

preferences

about, 2.1

changing, 1

creating, 8

dropping, 8

replacing, 1

specifying for indexing, 1

system-defined, 2.11

viewing, G.22

vs. types, 2.1.1

preferred term operator

example, 3.1.5

prefix_index attribute, 2.5.1

prefix_max_length attribute, 2.5.1

prefix_min_length attribute, 2.5.1

printjoins attribute, 2.4.2

privileges

required for indexing, 1

procedure

COPY_POLICY, 8

CTX_DDL.ADD_INDEX, 8

CTX_DDL.REPLACE_INDEX_METADATA, 8

CTX_OUTPUT_LOG_TRACES, 11

CTX_OUTPUT.ADD_TRACE, 11

CTX_OUTPUT.END_QUERY_LOG, 11

CTX_OUTPUT.GET_TRACE_VALUE, 11

CTX_OUTPUT.REMOVE_TRACE, 11

CTX_OUTPUT.RESET_TRACE, 11

procedure attribute, 2.2.6

PROCEDURE_FILTER object, 2.3.6

progressive relaxation template, 1

prove_themes attribute, 2.4.2.1

proximity operator, see NEAR operator

PRUNE_LEVEL, 2.8.1

PT function, 14

PT operator, 3.1.5

punctuations attribute, 2.4.2

Q

query

accumulate, 3.1.5

analysis, 13.2

AND, 3.1.5

broader term, 3.1.5

equivalence, 3.1.5

example, 1

hierarchical feedback, 12

MINUS, 3.1.5

narrower term, 3.1.5

NOT, 3.1.5

on unsynched index, 1

OR, 3.1.5

preferred term, 3.1.5

related term, 3.1.5

report of logged, 13.2

scoring, 3.1.5, 3.1.5

stored, 3.1.5

synonym, 3.1.5

threshold, 3.1.5

top term, 3.1.5

transactional, 1, 12

translation term, 3.1.5, 3.1.5

translation term synonym, 3.1.5

weighted, 3.1.5

query relaxation template, 1

query rewrite template, 1

query template, 1, 1

query_filter_cache_size basic storage attribute, 2.6.1

QUERY_LOG_SUMMARY procedure, 13.2

QUERY_PROCEDURE user_lexer attribute, 2.4.9.5

R

r_table_clause, 2.6.1

rebuilding index

example, 1

syntax, 1

RECOVER procedure, 5

related term operator, 3.1.5

related term query feedback, 12

relaxing queries, 1

relevance ranking

word queries, F.1

REMOVE_AUTO_OPTIMIZE procedure, 8

REMOVE_EVENT procedure, 11

REMOVE_MDATA procedure, 8

REMOVE_SECTION procedure, 8

REMOVE_SQE procedure, 12

REMOVE_STOPCLASS procedure, 8

REMOVE_STOPTHEME procedure, 8

REMOVE_STOPWORD procedure, 8

REMOVE_SUB_LEXER procedure, 8

REMOVE_TRACE procedure, 11

removing a trace, 11

removing metadata, 8

renaming index, 1

repeated field sections

querying, 3.1.5

REPLACE_INDEX_METADATA procedure, 8

replacing, 1

replacing metadata, 1

replacing preferences, 1

report

describing index, 13.2

describing policy, 13.2

index objects, 13.2

index size, 13.2

index statistics, 13.2

of logged queries, 13.2

token information, 13.2

reserved words and characters, 4.3

escaping, 4.2

RESET_AUTO_OPTIMIZE_STATUS procedure, 5

RESET_TRACE procedure, 11

resetting a trace, 11

result set interface, 12

result sets, 12

result table

TOKENS, A.2.6

result tables, A

CTX_DOC, A.2

CTX_QUERY, A.1

CTX_THES, A.3

resuming failed index, 1

example, 1

rewriting queries, 1

RFC 1738 URL specification, 2.2.5.1

RFC-2045 messages

filtering, 2.3.4

RFC-822 messages

filtering, 2.3.4

RT function, 14

RT operator, 3.1.5

RULE_CLASSIFIER type, 2.8.1

rules

generating, 7

S

s_table_clause, 2.6.1

Salton’s formula for scoring, F.1

save_copy, 2.6.1

save_copy_max_size, 2.6.1

scope notes

finding, 14

SCORE operator, 1

scoring

accumulate, 3.1.5

effect of DML, F.1.2

for NEAR operator, 3.1.5

scoring algorithm

word queries, F.1

script

create index, 13.2

create policy, 13.2

SDATA operator, 3.1.5

SDATA section, 8, 8

section group

creating, 8

viewing information about, G.25

section group example, 2.7.1

section group types, 2.7, 8

section searching, 3.1.5

nested, 3.1.5

SECTION_WEIGHT, 2.8.2, 2.9.1

sections

adding dynamically, 1

constraints for dynamic addition, 1

creating attribute, 8

creating field, 8

creating zone, 8

nested, 8

overlapping, 8

removing, 8

repeated field, 8

repeated zone, 8

viewing information on, G.24

SENTENCE keyword, 3.1.5

sentence section

defining, 8

querying, 3.1.5

separate_offsets, 2.6.1

SET_ATTRIBUTE procedure, 8

SET_KEY_TYPE procedure, 9

SET_PARAMETER procedure, 2.12, 5

SET_SECTION_ATTRIBUTE procedure, 8

show size of index objects, 13.2

Simplified Chinese

index defaults, 2.11.3.1.8

single-byte languages

indexing, 2.4.2

skipjoins attribute, 2.4.2

SN procedure, 14

SNIPPET procedure, 9

soundex operator, 3.1.5

Spanish

fuzzy matching, 2.5.1

stemming, 2.5.1

supplied stoplist, E.11

special characters

INPATH and HASPATH operators, 3.1.5

special section

defining, 8

querying, 3.1.5

spelling

alternate, 17.1.1

base letter, 17.1.2

new German, 17.1.3

overriding alternate, 17.2

spelling, alternate, 17

spelling, new German, 2.4.2.1

SQE operator, 3.1.5

SQL commands

ALTER INDEX, 1

CREATE INDEX, 1

DROP INDEX, 1

SQL operators

CONTAINS, 1

MATCH_SCORE, 1

MATCHES, 1

SCORE, 1

SQL*Loader

example, C.2

example control file, C.2.2.1

example data file, C.2.2.2

sqlldr example, C.2.2

stage_itab, 2.6.1

standalone graphics, B.2.4

START_LOG procedure, 11

startjoins attribute, 2.4.2

statistics, disabling, 11

statistics, enabling, 11

statistics, showing index, 13.2

stem indexing, 2.4.2.1

stem operator, 3.1.5

STEM_ON, 2.8.2, 2.9.1

stemmer attribute, 2.5.1

stemming, 2.5.1, 2.5.1, 3.1.5

automatic, 2.5.1

example for enabling, 2.5.2

stop section

adding dynamically, 1

dynamically adding example, 1

stop sections

adding, 8

stop_dic attribute, 2.4.8.4

stopclass

defining, 8

removing, 8

stoplist

creating, 8

Danish, E.4

dropping, 8

Dutch, E.5

English, E.1

Finnish, E.6

French, E.7

German, E.8

Italian, E.9

modifying, 2.10.3

multi-language, 2.4.3.2, 2.10.1

Portuguese, E.10

Spanish, E.11

Swedish, E.12

stoplists

about, 2.10

creating, 2.10.2

viewing, G.27

stoptheme

defining, 8

removing, 8

stopword

adding dynamically, 1, 1

defining, 8

removing, 8

viewing all in stoplist, G.28

stopword transformation, H.1

viewing, 12

stopwords

adding dynamically, 2.10.3.1

removing, 2.10.3.1

storage defaults, 2.6.1.1

storage index preference

example, 8

storage objects, 2.6

STORE_SQE procedure

example, 3.1.5

syntax, 12

stored queries, 3.1.5

stored query expression

creating, 12

removing, 12

viewing, G.55, G.56

viewing definition, G.26

structured data, 3.1.5

structured data section, 8, 8

sub-lexer preference

removing, 8

sub-lexer values

viewing, G.14

sub-lexers

viewing, G.13, G.29, G.46, G.47

substring index

example for creating, 2.5.2

substring_index attribute, 2.5.1

supplied stoplists, E

Supported Platforms for AUTO_FILTER, B.1.3

SVM_CLASSIFIER, 2.8.2

Swedish

alternate spelling, 17.3.3

index defaults, 2.11.3.1.5

supplied stoplist, E.12

SYN function, 14

SYN operator, 3.1.5

SYNC EVERY parameter, 1, 1

SYNC ON COMMIT parameter, 1, 1

sync parameter, 1, 1

SYNC_INDEX procedure, 8

synchronize index, 1, 1

synonym operator, 3.1.5

system parameters, 2.12

defaults for indexing, 2.12.2, 2.12.3

system recovery

manual, 5

system-defined preferences, 2.11

CTXSYS.AUTO_FILTER, 2.3.2.1

T

table structure

explain, A.1.1

filter, A.2.1

Gist, A.2.2

hfeedback, A.1.2

highlight, A.2.3

markup, A.2.4

theme, A.2.5

tagged text

searching, 3.1.5

tagging for languages used with AUTO_LEXER, I

template query, 1, 1

TERM_THRESHOLD, 2.8.1

text column

supported types, 1

Text data dictionary

cleaning up, 5, 5

TEXT format column value, 1

text-only index

enabling, 2.4.2.1

example, 8

theme functionality

supported languages, 16.3.8

theme highlighting

generating markup, 9

generating offsets, 9, 9

HTML markup example, 9

HTML offset example, 9

theme index

as default in English, 2.11.3.1.1

creating, 2.4.2.1

theme proving

enabling, 2.4.2.1

theme summary

generating, 9

generating top n, 9

theme table

structure, A.2.5

theme_language attribute, 2.4.2.1

THEME_ON, 2.8.2, 2.9.1

themes

generating for document, 9, 9

generating highlight markup, 9, 9

highlight offset example, 9

indexing, 2.4.2.1

obtaining top n, 9

THEMES procedure

result table, A.2.5

syntax, 9

THES_TT procedure, 14

thesaurus

compiling, 16.3

creating, 14

creating relationships, 14

DEFAULT, 3.1.5

dropping, 14

import/export examples, 16.1.3.1

importing/exporting, 16.1

procedures for browsing, 14

renaming and truncating, 14

viewing information about, G.30

thesaurus import file

examples, C.3.4

structure, C.3

thesaurus phrases

altering, 14

dropping, 14

thesaurus relations

creating, 14

dropping, 14

thesaurus scope note

finding, 14

thesaurus top terms

finding all, 14

THRESHOLD, 2.8.1

threshold operator, 3.1.5

stopword transformations, H.1.12

timeout attribute, 2.2.5.2

to_upper attribute, 2.4.8.4

token report, generating, 13.2

token, translating name into, 13.2

TOKEN_INFO procedure, 13.2

TOKEN_ON, 2.8.2, 2.9.1

TOKEN_TYPE procedure, 13.2

TOKENS procedure

result table, A.2.6

syntax, 9

top term, 3.1.5

top term operator, 3.1.5

TR function, 14

TR operator, 3.1.5, 3.1.5

trace value

getting, 11

traces, available, 11

tracing

adding a trace, 11

available traces, 11

CTX_TRACE_VALUES view, G.32

enabling, 11

getting trace values, 11, G.32

logging traces, 11

removing trace, 11

resetting trace, 11

TRAIN procedure, 7

transactional CONTEXT index, 1, 1

transactional index, 12

transactional parameter, 1, 1

transactional text query, 1, 1

disabling, 1

TRANSFORM operator, 1

transformation

stopword, H.1

translation term operator, 3.1.5, 3.1.5

translation term synonym operator, 3.1.5

translations

adding to thesaurus, 14

dropping, 14

English name to numeric token, 13.2

updating, 14

Transparent Data Encryption

Oracle Text index on a column and, 1

TRSYN function, 14

TRSYN operator, 3.1.5

TT function, 14

TT operator, 3.1.5

type

MULTI_LEXER, 2.4.3

WORLD_LEXER, 2.4.10, D.2.5

types, 2.1.1

indexing, 2.1.1

U

unicode support in Korean lexer, 2.4.8.3

UNSET_ATTRIBUTE procedure, 8, 8

unsupervised classification, see clustering

UPDATE GLOBAL INDEXES, 1, 1, 1, 1

UPDATE_SDATA procedure, 8

UPDATE_SUB_LEXER procedure, 8

UPDATE_TRANSLATION procedure, 14

URL syntax, 2.2.5.1

URL_DATASTORE object

attributes for, 2.2.5

example, 2.2.5.4

URL_DATASTORE system-defined preference, 2.11.1.3

urlsize attribute, 2.2.5.2

user dictionary, modifying, 16.4

USER_DATASTORE object, 2.2.6

example, 2.2.6.3

USER_DATSTORE

filtering binary documents, 9

user_dic attribute, 2.4.8.4

USER_FILTER object, 2.3.5

example, 2.3.5.4

USER_LEXER object, 2.4.9

and CTXRULE index, 2.4.9.1

UTF-16 endian auto-detection, 2.3.1.1

UTF8, 2.4.7

UTF8 character set, 2.4.2, 2.4.4.2, 2.4.6.2, 2.4.7.3, 2.4.8.2

utilities

ctxload, 16.1

V

VARCHAR2 column

indexing, 1

verb_adjective attribute, 2.4.8.4

version numbers

viewing, G.62

viewing, G.3

operator expansion, 12

operator precedence, 12

views

CTX_AUTO_OPTIMIZE_INDEXES, G.2

CTX_AUTO_OPTIMIZE_STATUS, G.3

CTX_CLASSES, G.4, G.5, G.6, G.19, G.39, G.49

CTX_INDEX_ERRORS, G.8

CTX_INDEX_OBJECTS, G.9

CTX_INDEX_SUB_LEXER, G.13

CTX_INDEX_SUB_LEXERS, G.47

CTX_INDEX_SUB_LEXERS_VALUES, G.14

CTX_INDEX_VALUES, G.15

CTX_INDEXES, G.7

CTX_OBJECT_ATTRIBUTE_LOV, G.18

CTX_OBJECT_ATTRIBUTES, G.17

CTX_OBJECTS, G.16

CTX_PARAMETERS, G.20

CTX_PENDING, G.21

CTX_PREFERENCE_VALUES, G.23

CTX_PREFERENCES, G.22

CTX_SECTION_GROUPS, G.25

CTX_SECTIONS, G.24

CTX_SQES, G.26

CTX_STOPLISTS, G.27

CTX_STOPWORDS, G.28

CTX_SUB_LEXERS, G.29

CTX_THESAURI, G.30

CTX_TRACE_VALUES, G.32

CTX_USER_AUTO_OPTIMIZE_STATUS, G.34

CTX_USER_INDEX_ERRORS, G.41

CTX_USER_INDEX_OBJECTS, G.42

CTX_USER_INDEX_SET_INDEXES, G.45

CTX_USER_INDEX_SETS, G.44

CTX_USER_INDEX_SUB_LEXERS, G.46

CTX_USER_INDEX_VALUES, G.48

CTX_USER_INDEXES, G.40

CTX_USER_PENDING, G.50

CTX_USER_PREFERENCE_VALUES, G.52

CTX_USER_PREFERENCES, G.51

CTX_USER_SECTION_GROUPS, G.54

CTX_USER_SECTIONS, G.53

CTX_USER_SQES, G.55, G.56

CTX_USER_STOPLISTS, G.57

CTX_USER_STOPWORDS, G.58

CTX_USER_SUB_LEXERS, G.59

CTX_USER_THES_PHRASES, G.61

CTX_USER_THESAURI, G.60

CTX_VERSION, G.62

visible flag for field sections, 8

visible flag in field sections, 3.1.5

W

weight operator, 3.1.5

stopword transformations, H.1.11

whitespace attribute, 2.4.2

wildcard queries

improving performance, 2.5.1

wildcard searches, 3.1.5

improving performance, 3.1.5

wildcard_maxterms attribute, 2.5.1

WILDCARD_TAB type, 15

WITHIN operator, 3.1.5

attribute sections, 3.1.5

limitations, 3.1.5

nested, 3.1.5

precedence, 3.1.4

stopword transformations, H.1.13

WITHIN query, 2.7

word forms, 17.1

original vs. normalized, 17.1

WORLD_LEXER type, 2.4.10, D.2.5

X

XML documents

attribute sections, 8

doctype sensitive sections, 8

indexing, 1, 2.7, 8

querying, 3.1.5

XML report output format, 13.2, 13.2, 13.2, 13.2, 13.2

XML Search, 8

XML Search Index, 8

XML sectioning, 2.7.1.3

xml_enable, 8

XML_SECTION_GROUP

example, 2.7.1.2

XML_SECTION_GROUP object, 1, 2.7, 8

XMLIndex, Preface

Z

ZHS16CGB231280 character set, 2.4.4.2

ZHS16GBK character set, 2.4.4.2

ZHS32GB18030 character set, 2.4.4.2

ZHT16BIG5 character set, 2.4.4.2

ZHT16HKSCS character set, 2.4.4.2

ZHT16MSWIN950 character set, 2.4.4.2

ZHT32EUC character set, 2.4.4.2

ZHT32TRIS character set, 2.4.4.2

zone section

adding dynamically, 1

creating, 8

dynamically adding example, 1

querying, 3.1.5

repeating, 8