Index

BLASTER FILTER (pre 8.1), 4-3

BLOB columns

CHINESE V-GRAM LEXER (pre-8.1), 4-3

CLOB columns

CLOSE_CON procedure (pre-8.1), 6-5

code

migrating, 2-4

columns with multiple indexes, 5-2

composite textkey query

migrating, 6-10

compressor object (pre-8.1), 4-4

CONTAINS operator, 6-3

ConText query

migrating, 6-2

ConText Workbench (pre-8.1), 3-7

COUNT_HITS procedure, 6-14

COUNT_LAST procedure (pre-8.1), 6-5, 6-14

counting hits, 6-14

CREATE INDEX command, 5-7

CREATE_INDEX procedure (pre-8.1), 5-7

CREATE_PREFERENCE procedure, 5-6

CREATE_SECTION_GROUP procedure, 5-17

CREATE_STOPLIST procedure, 5-15

CTX_ADM package, A-2

CTX_DDL package, A-4

CTX_DML package (pre-8.1), A-3

CTX_DOC package, 7-2, 7-5

CTX_INFO package (pre-8.1), A-6

CTX_LING output tables (pre-8.1)

creating, 7-6

CTX_LING package (pre-8.1), 7-5, A-7

CTX_QUERY package, A-8

CTX_SERVERS view, 3-2

CTX_SVC package (pre-8.1), A-10

CTXADMIN role (pre-8.1), 3-3

CTXAPP role, 3-3

ctxctl (pre-8.1), 1-13, 3-2

ctxkbtc compiler, 1-4, 1-13

starting and shutting down, 3-7

viewing status of, 3-2

CTXSYS role, 3-3

CTXSYS user

role in migration, 2-8

CTXUSER role (pre-8.1), 3-3

cursor query

migrating, 6-5

customer support

contacting, xiii

D server, 5-14

Danish alternate spelling, 1-6

data migration

about, 2-5

when to perform, 2-8

data storage

USER_DATASTORE object, 1-11

preference example, 5-6

user, 1-4

datastore objects

migrating, 4-3

DDL pipe (pre-8.1), 3-5

default index behavior, 1-3

DIRECT (pre 8.1), 4-3

DIRECTORY READER (pre-8.1), 4-4

disk requirements, 2-6

DML processing

background, 1-13, 3-2, 5-13

batch, 5-14

document

synthesizing at index-time, 1-4

document filtering, 1-3

document loading, 1-13, 3-4

document presentation

migrating, 7-1

document sections, 5-17

drminst script

about, 4-7

when to run, 2-7

drmrun script

about, 4-7

when to run, 2-7

DROP INDEX command, 5-9

DROP_INDEX procedure (pre-8.1), 5-9

DROP_PREFERENCE procedure, 5-8

DROP_STOPLIST procedure, 5-16

dropping an index, 5-9

engine objects

migrating, 4-4

enhancements in 8.1, 1-3

executables

changed and new, 1-13

execute operator

migrating, 6-13

explain information

obtaining, 6-19

explain plan, 6-19

extensible knowledge base, 1-4

compiling, 1-13

extensible query optimizer, 1-3

features

new, 1-3

feedback

query, 1-4

FETCH_HIT procedure(pre-8.1), 6-5

field section

filter class

filter objects

FILTER procedure, 7-4

filtering

about, 1-3

to HTML and plain text, 7-4

FIRST_ROWS hint, 6-6

first/next operator, 6-11

migrating, 6-12

full themes

obtaining, 7-8

GENERIC ENGINE (pre-8.1), 4-4

GENERIC LOADER (pre-8.1), 4-4

GENERIC STOP LIST (pre-8.1), 4-4

GENERIC WORD LIST (pre 8.1), 4-4

German alternate spelling, 1-6

GIST procedure, 7-5, 7-9

example, 7-9

Gist table, 7-9

Gists

8.1, 7-8

overview of differences, 7-5

hardware requirements, 2-6

granting roles, 3-3

hierarchical query feedback, 1-4

HIGHLIGHT procedure

8.1, 7-3

pre-8.1, 7-2

highlighting

overview of differences, 7-2

highlighting text, 7-3

highlighting themes, 7-2, 7-3

hits counting, 6-14

HTML

filtering to, 1-4, 7-4

HTML FILTER (pre-8.1), 4-3

index

about, 5-2

background DML, 5-13

creating, 5-7

default behavior, 1-3

dropping, 5-9

optimizing, 5-12

procedure for creating, 5-4

rebuilding, 5-11

synchronizing, 3-2, 5-14

theme component, 6-9

index creation

migration script warnings, 4-10

index migration, 4-7

manual, 2-4

plan, 2-3

steps, 2-8

with migration scripts, 2-4

index objects

changes, 4-2

new, 1-11, 4-5

indexes

multiple, 5-2

indexing

resuming failed, 5-10

indexing views, 5-2

warning, 4-10

initsid.ora file, 3-6

in-memory query, see cursor query

Inso filter

about, 1-3

installing Oracle8i, 2-7

integration with Oracle

new feature, 1-3

interMedia Text

related publications, xii

JAPANESE V-GRAM LEXER (pre-8.1), 4-3

knowledge base

extending, 1-4

knowledge base compiler, 1-13

KOREAN LEXER (pre-8.1), 4-3

lexer class

overview of differences, 7-5

lexer objects

migrating, 4-3

list of themes

obtaining, 7-8

loader objects (pre-8.1), 4-4

loading documents, 1-13, 3-4

LOB columns

location of migration scripts, 4-7

LONG columns

M personality of ctxsrv, 3-2, 5-13

migrating, 2-5

machine requirements, 2-6

marked-up document

obtaining, 7-3

MARKUP procedure, 7-3

MASTER DETAIL (pre 8.1), 4-3

MASTER DETAIL NEW (pre-8.1), 4-3

location and function, 4-7

using, 4-7

warnings, 4-7, 4-8, 4-10

when to run, 2-7

migrating

application code, 2-8

data, 2-5

document presentation, 7-1

Gists, 7-8

highlighting, 7-2

index, 2-3, 2-8

index preference objects, 4-2

system-defined preferences, 4-8

theme summary, 7-8

user-defined preferences, 4-7

migration

definition, 2-3

disk requirements, 2-6

Oracle7, 2-2

path, 2-2

plan, 2-3

steps, 2-7

migration scripts

about, 2-4

using, 4-7

mixed-format columns

filtering, 1-3

multiple indexes, 5-2

multiple policies, 4-10

new features, 1-3

news group documents

support for sections, 1-6

NEWS_SECTION_GROUP object, 1-6, 1-11

NLS_LEXER (pre-8.1), 4-4

non-indexed policies

warnings, 4-10

notational conventions, xiii

NULL COMPRESSOR (pre-8.1), 4-4

NULL FILTER (pre-8.1), 4-3

NULL TRANSLATOR (pre 8.1), 4-4

obsolete

index objects, 4-2, 4-7

operators, 1-9

PL/SQL packages and procedures, A-1

system-defined preferences, 4-8

utility (ctxctl), 1-13

offset information

highlight, 7-3

one-step queries (pre-8.1), 3-6

OPEN_CON procedure (pre-8.1), 6-5

operators

changes in 8.1, 1-9

obsolete, 6-11

SQE, 6-16

OPTIMIZE_INDEX procedure (pre-8.1), 5-12

optimizing index, 5-12

optimizing queries, 1-3

Oracle Corporation

customer support, xiii

Oracle Data Migration Assistant, 2-8

Oracle Enterprise Manager, 3-2, 3-7

oracle homes

required for migration, 2-6

Oracle7 users

migration path, 2-2

Oracle8 users

migration path, 2-2

Oracle8i

installing, 2-7

Oracle8i interMedia Text Manager, 3-2, 3-7

ORDER BY clause, 6-3

OSFILE (pre-8.1), 4-3

paragraph section, 5-18

paramstring for CREATE INDEX, 5-7

path

migration, 2-2

personality of server, 1-13, 3-2

plain-text

filtering to, 1-4, 7-4

plan for migration, 2-3

PL/SQL operator

PL/SQL packages

policy warnings, 4-10

preference objects, See index objects

preferences, 2-3

creating (example), 5-6

creating with admin tool, 3-7

dropping, 5-8

migrating system-defined, 4-8

migrating user-defined, 4-7

new system-defined, 4-6

PURGE_SQE procedure (pre-8.1), 6-16

query

8.1 PL/SQL example, 6-4

8.1 SQL example, 6-3

composite textkey, 6-10

counting hits, 6-14

cursor (in-memory), 6-5

query explain plan

query expression

query feedback

query feedback, see query explain plan

query methods

changes, 6-2

query optimizer, 1-3

query pipe (pre-8.1), 3-5

rebuilding an index, 5-11

REFRESH_SQE procedure (pre-8.1), 6-16

REMOVE_SQE procedure

8.1, 6-17

REMOVE_STOPCLASS procedure, 5-16

REMOVE_STOPTHEME procedure, 5-16

REMOVE_STOPWORD procedure, 5-15

REQUEST_GIST procedure (pre-8.1), 7-5, 7-6

REQUEST_THEMES procedure (pre-8.1), 7-5, 7-6

RESUME_FAILED_INDEX procedure (pre-8.1), 5-10

resuming failed index, 5-10

roles

changes, 3-3

granting, 3-3

section group

creating with admin tool, 3-7

migrating, 5-17

new objects, 1-11

section group class

section searching enhancements, 1-5

SECTION_GROUP attribute (pre-8.1), 4-4

sentence section, 5-18

server, See ctxsrv

services queue (pre-8.1), 3-5, 7-5

SET_ATTRIBUTE procedure, 5-6

single themes

obtaining, 7-8

SOUNDEX_AT_INDEX attribute (pre-8.1), 4-4

special sections, 5-18

spelling

alternate, 1-6

SQE operator, 6-16

SQL

changes and new commands, 1-8

SQL*Loader, 3-4, 4-4

STCLAUSE attribute (pre-8.1), 4-4

steps for migration, 2-7

stopclass, 1-5, 5-15

stoplist

creating with admin tool, 3-7

stoplist class

stoplist enhancements, 1-5

storage class

storage objects

STORE_SQE procedure, 6-16

8.1, 6-17

stored query expressions

structured query

SUBMIT procedure (pre-8.1), 7-7

Swedish alternate spelling, 1-6

SYNC procedure (pre-8.1), 5-14

synchronizing index, 3-2, 5-14

system-defined preferences

migrating, 4-8

new, 4-6

table

CTX_LING pre-8.1, 7-6

Gist, 7-9

template policies

test environment

text highlighting, 7-3

Text index

about, 1-3

definition, 1-2

Text Manager tool, 3-7

Text query

definition, 1-2

text request queue (pre-8.1), 3-5

text_enable variable, 3-6

text-only index

about, 5-2

theme base

extending, 1-4

theme highlighting, 7-2, 7-3

THEME LEXER (pre-8.1), 4-4

theme query

migrating, 6-9

theme summary

8.1, 7-8

overview of differences, 7-5

theme table

8.1, 7-8

theme-only index about, 5-2

THEMES procedure, 7-5, 7-8

thesaurus

compiling, 1-4

importing, 3-4

two-step query

migrating, 6-2

unsupported operators, 1-9, 6-13

updating index

background DML, 5-13

batch DML, 5-14

upgrading

Oracle8 to Oracel8i, 2-5

upgrading Oracle8, 2-2

URL (pre-8.1), 4-3

user data storage, 1-4

USER FILTER (pre-8.1), 4-3

USER TRANSLATOR (pre-8.1), 4-4

USER_DATASTORE object, 1-4, 1-11, 5-2

user-defined preferences

migrating, 4-7

users

changes, 3-3

views

indexing, 5-2

new and changed system-supplied, 1-14

warnings in migration script

non-migratable policies and structures, 4-10

obsolete preference object, 4-7

obsolete system-defined preference, 4-8

WHERE clause, 6-3

WITHIN operator, 5-17

word query

definition, 1-2

wordlist class