Oracle8i Documentation Addendum -- Index

? operator, 2-36

ADD_INDEX new procedure, 2-38

ADD_STOPWORD procedure

updated syntax, 2-47

ALTER DATABASE CHARACTER SET statement, 3-7

ALTER DATABASE NATIONAL CHARACTER SET statement, 3-7

ALTER DATABASE statement

CREATE STANDBY CONTROLFILE clause, 12-22

ALTER INDEX, 2-20

interMedia Text examples, 2-22

archive destinations

multiple, 12-14

archived redo logs

and multiple destinations, 12-14

array parameter

Character Set Scanner Utility, 3-16

Average Elapsed Time data view, 13-10

backup command (RMAN), 7-42

backups

standby database

archived redo logs, 7-29

interpreting RC_ARCHIVED_LOG view, 7-26

overview of RMAN, 7-25

restrictions, 7-26

using RMAN, 7-25, 7-31, 7-32

testing RMAN, 7-33

Basic Statistics for Parse/Execute/Fetch drilldown data view, 13-19

binary files

formatting using Oracle Trace, 13-5

BLANK_TRIMMING initialization parameter, 3-4

boundaries parameter

Character Set Scanner Utility, 3-16

capture parameter

Character Set Scanner Utility, 3-17

catalog index

about, 2-3

catproc.sql script, 6-2

CATSEARCH operator, 2-13

character set errors

troubleshooting with RMAN, 7-38

character set migration

data scanning, 3-7

Character Set Scanner

scan modes, 3-11

Character Set Scanner Utility, 3-1, 3-9, 3-17

array parameter, 3-16

boundaries parameter, 3-16

capture parameter, 3-17

compatibility, 3-13

feedback parameter, 3-17

fromnchar parameter, 3-18

full parameter, 3-18

help parameter, 3-18

invoking, 3-13

lastrpt parameter, 3-19

maxblocks parameter, 3-19

online help, 3-14

parameter file, 3-15

parameters, 3-16

parfile parameter, 3-20

scanner messages, 3-38

scanner parameters, 3-16

scanner tables, 3-36

suppress parameter, 3-20

table parameter, 3-21

tochar parameter, 3-21

tonchar parameter, 3-21

user parameter, 3-21

userid parameter, 3-22

character sets

choosing, 3-2

data loss, 3-4

migrating, 3-2

migration, 3-2

choosing character sets, 3-2

collections, 13-4, 13-25

commands, Recovery Manager

backup, 7-42

changes to, 7-41

copy, 7-45

debug, 7-46

duplicate, 7-2, 7-47

set, 7-49

compatibility

Recovery Manager, 7-39

COMPATIBLE initialization parameter, 12-16

snapshot base tables, 9-7

configure compatible command (RMAN)

obsolete in 8.1.7, 7-38

configuring

directory access, 5-2

domain hints to Oracle Names servers, 5-14

initialization parameter file, 12-14, 12-16, 12-24, 12-26

instance role, 5-11

listener.ora file, 12-12

network files, 12-12

session data unit (SDU), 5-9

tnsnames.ora file, 12-12

CONTEXT indextype, 2-16

control files

creating, 12-7, 12-22

snapshot

setting default location, 7-33

CONTROL_FILES initialization parameter, 12-9, 12-16

copy command (RMAN), 7-45

CPU Statistics data view, 13-12

CPU Statistics for Parse/Execute/Fetch drilldown data view, 13-19

CREATE INDEX, 2-16

CREATE PACKAGE BODY command, 6-3

CREATE PACKAGE command, 6-3

CREATE_INDEX_SET new procedure, 2-41

CREATE_STOPLIST procedure

updated syntax, 2-46

CREATE_TRANSLATION new procedure, 2-49

creating

control files, 12-22

packages, 6-3

standby databases, 12-6

crosschecking

catalog not required, 7-37

on multiple channels, 7-34

CSM$COLUMNS parameter, 3-34

CSM$ERRORS parameter, 3-35

CSM$TABLES parameter, 3-34

CSMIG user, 3-12

CSMINST.SQL script, 3-12

running, 3-13

CTX_DDL.ADD_INDEX, 2-38

CTX_DDL.ADD_STOPWORD, 2-47

CTX_DDL.CREATE_INDEX_SET, 2-41

CTX_DDL.CREATE_STOPLIST, 2-46

CTX_DDL.DROP_INDEX_SET, 2-42

CTX_DOC.GIST, 2-59

CTX_DOC.THEMES, 2-56

CTX_THES.CREATE_TRANSLATION, 2-49

CTX_THES.DROP_TRANSLATION, 2-50

CTX_THES.UPDATE_TRANSLATION, 2-52

CTXCAT indextype, 2-16

about, 2-3

CTXKBTC knowledge base compiler

updated syntax, 2-12

data conversion

database character set, 3-7

data expansion during character set migration, 3-2

data inconsistencies

causing data loss, 3-5

data loss

caused by data inconsistencies, 3-5

during character set migration, 3-4

from mixed character sets, 3-6

data scanning

character set migration, 3-7

data truncation, 3-2

restrictions, 3-3

data views in Oracle Trace, 13-7

Average Elapsed Time, 13-10

CPU Statistics, 13-12

Disk Reads, 13-9

Disk Reads/Execution Ratio, 13-9

Disk Reads/Logical Reads Ratio, 13-10

Disk Reads/Rows Fetched Ratio, 13-9

Execute Elapsed Time, 13-11

Fetch Elapsed Time, 13-11

Logical Reads, 13-9

Logical Reads/Rows Fetched Ratio, 13-9

Number of Rows Processed, 13-12

Parse Elapsed Time, 13-11

Parse/Execution Ratio, 13-10

Re-Parse Frequency, 13-10

Rows Fetched/Fetch Count Ratio, 13-12

Rows Sorted, 13-12

Sorts in Memory, 13-12

Sorts on Disk, 13-12

Total Elapsed Time, 13-11

Waits by Average Wait Time, 13-13

Waits by Event Frequency, 13-13

Waits by Total Wait Time, 13-13

database character set

conversion, 3-7

database character set migration, 3-6

database conections

RMAN and Oracle Parallel Server, 4-2

Database Connection event, 13-5

Database Scan Summary Report, 3-25, 3-26

databases

standby

creating, procedures for, 12-6

DB_FILE_NAME_CONVERT initialization parameter, 12-10, 12-16

DB_FILES initialization parameter, 12-16

DB_NAME initialization parameter, 12-16

DBA Studio

Replication Management tool included, 9-15

DBMS_JOB package, 6-5

DBMS_REPCAT_INSTANTIATE package

INSTANTIATE_OFFLINE_REPAPI function, 10-2

DBMS_REPCAT_RGT package

INSTANTIATE_OFFLINE_REPAPI function, 10-6

debug command (RMAN), 7-46

deleting

using RMAN

catalog not required, 7-37

deleting backups

on multiple channels, 7-34

DESDecrypt procedure, 6-70, 6-74

DESEncrypt procedure, 6-69, 6-73

detail report in Oracle Trace, 13-6

details property sheet in Oracle Trace, 13-15

directory access configuration, 5-2

ldapmodify tool, 5-8

ldap.ora file, 5-3

Net8 Configuration Assistant options, 5-5

Oracle Context, 5-3

OracleDBCreators group, 5-3, 5-6

OracleNetAdmins group, 5-3, 5-6, 5-8

OracleSecurityAdmins group, 5-3, 5-6

performing after installation, 5-5

performing during installation, 5-2

client, 5-4

server custom, 5-2

Disk Reads data view, 13-9

Disk Reads/Execution Ratio data view, 13-9

Disk Reads/Logical Reads Ratio data view, 13-10

Disk Reads/Rows Fetched Ratio data view, 13-9

document formats

supported, 2-9

document tokens

about, 2-8

DOMAIN_HINT command, 5-14

drilldown data views in Oracle Trace, 13-17

Basic Statistics for Parse/Execute/Fetch, 13-19

CPU Statistics for Parse/Execute/Fetch, 13-19

Parse Statistics, 13-19

Row Statistics for Execute/Fetch, 13-20

DROP_INDEX_SET new procedure, 2-42

DROP_TRANSLATION new procedure, 2-50

duplicate command (RMAN), 7-47

duplicate databases

creating

on a remote host with same directory structure, 7-13

on local host, 7-20

on remote host with different directory structure, 7-15

duration events in Oracle Trace, 13-5

ENABLE option

LOG_ARCHIVE_DEST_n initialization parameter, 12-15

events in Oracle Trace, 13-5

Execute Elapsed Time data view, 13-11

fast refresh

avoiding problems, 9-6

feedback parameter

Character Set Scanner Utility, 3-17

Fetch Elapsed Time data view, 13-11

filtering documents

interMedia Text, 2-9

FORMAT statement

in Oracle Trace, 13-21

formatter tables

in Oracle Trace, 13-5

French knowledge base, 2-10

fromchar parameter, 3-17

Character Set Scanner Utility, 3-17

fromnchar parameter

Character Set Scanner Utility, 3-18

full parameter

Character Set Scanner Utility, 3-18

fuzzy operator, 2-36

about, 2-9

gap sequences

applying the logs to standby database, 12-20, 12-27

copying the logs in, 12-19

identifying the logs in, 12-18

gist

generating, 2-59

GIST procedure

example, 2-62

updated syntax, 2-59

help parameter

Character Set Scanner Utility, 3-18

index

creating interMedia Text, 2-16

index maintenance

interMedia Text, 2-20

index optimization, 2-21

Individual Exception Report, 3-25, 3-32

initialization parameter files

configuring, 12-14, 12-16, 12-24, 12-26

initialization parameters

BLANK_TRIMMING, 3-4

COMPATIBLE, 12-16

CONTROL_FILES, 12-9, 12-16

DB_FILE_NAME_CONVERT, 12-10, 12-16

DB_FILES, 12-16

DB_NAME, 12-16

in Oracle Trace, 13-24

LOCK_NAME_SPACE, 12-9, 12-16

LOG_ARCHIVE_DEST_n, 12-15, 12-16

LOG_ARCHIVE_FORMAT, 12-15

LOG_ARCHIVE_START, 12-25

LOG_FILE_NAME_CONVERT, 12-10, 12-25

ORACLE_TRACE_ENABLE, 8-2

STANDBY_ARCHIVE_DEST, 12-16

Inso filter

newly supported formats, 2-9

supported platforms, 2-10

installation

directory access configuration, 5-2

instance role configuration, 5-11

connections in TAF, 5-13

connections to primary and secondary instances, 5-11

connections to specific instances, 5-12

INSTANCE_ROLE

use of in secondary instance connections, 4-2

INSTANCE_ROLE parameter, 5-11

interconnects

and the OPS_INTERCONNECTS parameter, 4-2

interMedia Text

new features and enhancements, 2-3

I/O

Statistics for Parse/Execute/Fetch view, 13-19

keyless index

about, 2-5

knowledge base

French and English, 2-10

supported character set, 2-11

user-defined, 2-10

lastrpt parameter

Character Set Scanner Utility, 3-19

ldapmodify tool, 5-8

ldap.ora file, 5-3

LISTENER.ORA file

configuring, 12-12

format, 12-13, 12-23

LOCK_NAME_SPACE initialization parameter, 12-9, 12-16

LOG_ARCHIVE_DEST_n initialization parameter, 12-15, 12-16

ENABLE option, 12-15

OPTIONAL option, 12-15

REOPEN option, 12-15

SERVICE option, 12-15

specifying destinations using, 12-15

LOG_ARCHIVE_FORMAT initialization parameter, 12-15

LOG_ARCHIVE_START initialization parameter, 12-25

LOG_FILE_NAME_CONVERT initialization parameter, 12-10, 12-25

Logical Reads data view, 13-9

Logical Reads/Rows Fetched Ratio data view, 13-9

master sites

scheduled links for

guidelines, 9-9

scheduled purge for

guidelines, 9-12

maxblocks parameter

Character Set Scanner Utility, 3-19

migrating character sets, 3-2

migration

database character set, 3-6

post-migration actions, 6-66

mixed character sets

causing data loss, 3-6

MULTI_COLUMN_DATASTORE, 2-24

multi-column datastore

about, 2-6

multi-language stoplist

about, 2-7

multimaster replication, 6-1

NAMES.DOMAIN_HINTS parameter, 5-14

Net8 Configuration Assistant

configuring directory access, 5-2

OracleDBCreators group, 5-3, 5-6

OracleNetAdmins group, 5-3, 5-6

OracleSecurityAdmins group, 5-3, 5-6

network files

configuring, 12-12

Number of Rows Processed data view, 13-12

numthemes new parameter

CTX_DOC.GIST, 2-62

CTX_DOC.THEMES, 2-57

operator

fuzzy, 2-36

OPS_INTERCONNECTS

for Oracle Parallel Server, 4-2

optimization

token, 2-22

optimizing index, 2-21

OPTIONAL option

LOG_ARCHIVE_DEST_n initialization parameter, 12-15

OR REPLACE clause

for creating packages, 6-3

Oracle Context creation, 5-3

Oracle Names Control utility

DOMAIN_HINT command, 5-14

REGISTER command, 5-17

REGISTER_NS command, 5-17

UNREGISTER command, 5-17

UNREGISTER_NS command, 5-19

Oracle Parallel Server

during database character set migration, 3-8

using RMAN, 7-36

Oracle Server

events, 13-5

Oracle Trace

accessing collected data, 13-5

binary files, 13-5

collection results, 13-31

collections, 13-4, 13-25

command-line interface, 13-20

data views, 13-7

Average Elapsed Time, 13-10

CPU Statistics, 13-12

Disk Reads, 13-9

Disk Reads/Execution Ratio, 13-9

Disk Reads/Logical Reads Ratio, 13-10

Disk Reads/Rows Fetched Ratio, 13-9

Execute Elapsed Time, 13-11

Fetch Elapsed Time, 13-11

Logical Reads, 13-9

Logical Reads/Rows Fetched Ratio, 13-9

Number of Rows Processed, 13-12

Parse Elapsed Time, 13-11

Parse/Execution Ratio, 13-10

Re-Parse Frequency, 13-10

Rows Fetched/Fetch Count Ratio, 13-12

Rows Sorted, 13-12

Sorts in Memory, 13-12

Sorts on Disk, 13-12

Total Elapsed Time, 13-11

Waits by Average Wait Time, 13-13

Waits by Event Frequency, 13-13

Waits by Total Wait Time, 13-13

deleting files, 13-24

details property sheet, 13-15

drilldown data views, 13-17, 13-19

Basic Statistics for Parse/Execute/Fetch view, 13-19

CPU Statistics for Parse/Execute/Fetch view, 13-19

Parse Statistics view, 13-19

Row Statistics for Execute/Fetch view, 13-20

duration events, 13-5

events, 13-5

FORMAT statement, 13-21

formatter tables, 13-5

Oracle Trace Data Viewer, 13-6

parameters, 13-24

point events, 13-5

predefined data views, 13-7

reporting utility, 13-6, 13-32

SQL statement property sheet, 13-15

START statement, 13-21

STOP statement, 13-21, 13-23

using to collect workload data, 13-3

viewing data, 13-13

Oracle Trace Data Viewer, 13-6

Oracle Trace Manager, 13-4

used for formatting collections, 13-5

ORACLE_TRACE_COLLECTION_NAME initialization parameter, 13-24

ORACLE_TRACE_COLLECTION_PATH initialization parameter, 13-24

ORACLE_TRACE_COLLECTION_SIZE initialization parameter, 13-24

ORACLE_TRACE_ENABLE initialization parameter, 8-2, 13-24

ORACLE_TRACE_FACILITY_NAME initialization parameter, 13-24, 13-26

ORACLE_TRACE_FACILITY_PATH initialization parameter, 13-24

OracleDBCreators group, 5-3, 5-6

OracleNetAdmins group, 5-3, 5-6, 5-8

OracleSecurityAdmins group, 5-3, 5-6

package overview, 6-2

packages

creating, 6-3

referencing, 6-5

parallel propagation

replication, 9-14

parameters

CSM$COLUMNS, 3-34

CSM$ERRORS, 3-35

CSM$TABLES, 3-34

parfile parameter

Character Set Scanner Utility, 3-20

Parse Elapsed Time data view, 13-11

Parse Statistics drilldown data view, 13-19

Parse/Execution Ratio data view, 13-10

point events in Oracle Trace, 13-5

prefix indexing, 2-7, 2-33

primary and secondary instances, 5-11

procedure filter, 2-7, 2-28

raw partitions

tablespace size requirements for Oracle Parallel Server, 4-2

RECOVER statement

specifying the TIMEOUT option, 12-21

recovery catalog

crosschecking, 7-37

deleting, 7-37

views, 7-50

Recovery Manager

and Oracle Parallel Server, 4-2

backups

standby database, 7-32

testing, 7-33

character set errors

troubleshooting, 7-38

commands

changes to, 7-41

duplicate, 7-2

compatibility, 7-39

snapshot control file

setting default location, 7-33

standby database

about creating, 7-2

backing up, 7-25

backing up archived logs, 7-29

backing up overview, 7-25

backing up the database, 7-31

backup restrictions, 7-26

copying standby control file, 7-6

creating, 7-9

creating standby control file, 7-3

creating standby control file using RMAN backup command, 7-4

creating standby control file using RMAN copy command, 7-5

creating standby control file using SQL, 7-5

creating using image copies, 7-20

creation overview, 7-9

DB_FILE_NAME_CONVERT initialization parameter, 7-8

interpreting the RC_ARCHIVED_LOG view, 7-26

LOG_FILE_NAME_CONVERT initialization parameter, 7-8

naming online redo logs, 7-8

naming standby datafiles, 7-6

preparing using RMAN, 7-2

restrictions when creating, 7-12

starting RMAN and standby instance, 7-12

views, 7-50

REGISTER command, 5-17

REGISTER_NS command, 5-17

REOPEN option

LOG_ARCHIVE_DEST_n initialization parameter, 12-15

Re-Parse Frequency data view, 13-10

replication, 9-1

adding snapshot sites

avoiding problems, 9-6

COMPATIBLE initialization parameter

snapshot base tables, 9-7

continuous push

scheduling, 9-11, 9-13

creating an environment, 9-40

deferred transactions

continuous purge, 9-13

continuous push, 9-11

periodic purge, 9-12

periodic push, 9-10

deployment templates

offline instantiation, 10-2, 10-6

documentation

additions, 9-5, 10-10

updates, 9-7

flowchart for creating environment, 9-40

generated files

location, 9-5

instantiate offline

INSTANTIATE_OFFLINE_REPAPI function, 10-2, 10-6

master sites

switching, 10-10

multimaster, 6-1

new features, 9-2

offline instantiation

INSTANTIATE_OFFLINE_REPAPI function, 10-2, 10-6

RepAPI clients, 10-2, 10-6

procedural replication

snapshot sites, 9-5

propagation

serial and parallel, 9-14

quiesce reduced, 9-2

replication management API, 10-1

Replication Management tool, 9-15

Copy Template Wizard, 9-38

Deployment Template Wizard, 9-34

first login, 9-17

interface, 9-18

navigator pane, 9-19

Offline Instantiation Wizard, 9-36

right pane, 9-24

Setup Wizard, 9-30

Snapshot Group Wizard, 9-33

Topology tab, 9-26

usage scenarios, 9-16

wizards, 9-29

scheduled links

continuous push, 9-11, 9-13

guidelines for, 9-9

parallel propagation, 9-14

serial propagation, 9-14

Index

Symbols

A

B

C

D

E

F

G

H

I

K

L

M

N

O

P

R

S

T

U

V

W