Index

A B C D E F G H I J L M N O P Q R S T U V X

A

action contexts, 5-10

name-value pairs

adding, 12-10, 12-24, 12-26

altering, 12-8

removing, 12-11, 12-26

querying, 12-22

system-created rules, 6-50

ADD SUPPLEMENTAL LOG DATA clause of ALTER TABLE, 16-10

ADD_COLUMN member procedure, 16-13

ADD_GLOBAL_RULES procedure, 6-14

ADD_MESSAGE_RULE procedure, 10-27

ADD_PAIR member procedure, 12-8, 12-10, 12-24, 12-26, 17-6, 17-16, 17-25, 17-40

ADD_RULE procedure, 5-8, 12-6

ADD_SCHEMA_PROPAGATION_RULES procedure, 6-18

ADD_SUBSCRIBER procedure, 10-3

ADD_SUBSET_PROPAGATION_RULES procedure

row migration, 6-27

ADD_SUBSET_RULES procedure, 6-12, 6-23

row migration, 6-27

ADD_TABLE_RULES procedure, 6-20

alert log

Oracle Streams entries, 15-27

ALTER TABLE statement

ADD SUPPLEMENTAL LOG DATA clause, 16-10

ALTER_APPLY procedure

removing a rule set, 11-15

removing the message handler, 11-18

removing the precommit handler, 11-21

setting an apply user, 11-17

setting the message handler, 11-18

setting the precommit handler, 11-20

specifying a rule set, 11-11

ALTER_CAPTURE procedure

removing a rule set, 9-31

setting a capture user, 9-32

setting the first SCN, 9-34, 9-36

specifying a rule set, 9-27

specifying database link use, 9-37

ALTER_PROPAGATION procedure

removing the rule set, 10-18

specifying the rule set, 10-14

ALTER_PROPAGATION_SCHEDULE procedure, 10-12

ALTER_RULE procedure, 12-7

AnyData datatype

queues, 3-12, 10-20

creating, 10-2

dequeuing, 10-23

enqueuing, 10-20

monitoring, 14-22

removing, 10-6

wrapper for messages, 3-12, 10-20

application

upgrading

using Streams, B-14

applied SCN, 2-24, 14-17

apply forwarding, 3-8

apply handlers, 4-5

apply process, 4-1

apply forwarding, 3-8

apply handlers, 4-5

Java stored procedures, 4-11

apply servers, 4-14

states, 4-16

apply user, 4-2

secure queues, 3-20

setting, 11-17

architecture, 4-14

automatic restart, 4-21

coordinator process, 4-14

states, 4-16

creating, 11-2

creation, 4-17

datatypes applied, 4-11

DDL handlers, 4-4

DML handlers, 4-4

creating, 16-13

dropping, 11-10

enqueuing events, 11-21

monitoring, 14-47

error handlers

creating, 11-25

monitoring, 14-36

setting, 11-30

error queue, 4-22

monitoring, 14-48, 14-50

events, 4-3

captured, 4-3

user-enqueued, 4-3

logical change records (LCRs), 4-4

managing, 11-1

message handlers, 4-4

monitoring, 14-37

removing, 11-18

setting, 11-18

monitoring, 14-32

apply handlers, 14-35

compatible tables, 14-74

latency, 14-39, 14-42

transactions, 14-41

non-LCR events, 4-7

options, 4-4

Oracle Real Application Clusters, 4-13

parallelism, 14-46

parameters, 4-19

commit_serialization, 4-20

disable_on_error, 4-21

disable_on_limit, 4-21

parallelism, 4-19

setting, 11-16

time_limit, 4-21

transaction_limit, 4-21

persistent status, 4-22

precommit handlers, 4-8

creating, 11-18

monitoring, 14-37

removing, 11-21

setting, 11-20

reader server, 4-14

states, 4-15

re-enqueue captured events, 16-15

RESTRICTED SESSION, 4-12

row subsetting, 6-12

supplemental logging, 6-32

rule sets

removing, 11-15

specifying, 11-11

rules, 4-2, 6-2

adding, 11-12

removing, 11-14

specifying execution, 11-23

monitoring, 14-48

starting, 11-10

stopping, 11-10

trace files, 15-29

transformations

rule-based, 6-71

troubleshooting, 15-13

checking apply handlers, 15-17

checking event type, 15-15

checking status, 15-13

error queue, 15-18

AQ_TM_PROCESSES initialization parameter

Streams apply process, 15-17

ARCHIVELOG mode

capture process, 2-46, 8-11, 16-4

B

buffered queues, 3-16

BUILD procedure, 2-24, 2-34

C

capture process, 2-1

applied SCN, 2-24, 14-17

architecture, 2-28

ARCHIVELOG mode, 2-46, 8-11, 16-4

automatic restart, 2-48

builder server, 2-29

capture user

secure queues, 3-20

setting, 9-32

captured events, 3-3

captured SCN, 2-24

changes captured, 2-10

DDL changes, 2-12

DML changes, 2-10

NOLOGGING keyword, 2-13

UNRECOVERABLE clause for SQL*Loader, 2-14

UNRECOVERABLE keyword, 2-13

checkpoints, 2-31

required checkpoint SCN, 2-46

creating, 9-2

creation, 2-32

datatypes captured, 2-8

DBID, 2-33, 9-3

downstream capture, 2-17

advantages, 2-21

creating, 9-2

database link, 2-22, 9-37

monitoring, 14-9

monitoring remote access, 14-5

dropping, 9-26

first SCN, 2-24

setting, 9-34, 9-36

global name, 2-33, 9-3

index-organized tables, 2-10

local capture, 2-17

advantages, 2-18

log transport services, 2-17

LogMiner, 2-31

multiple sessions, 2-31

LogMiner data dictionary, 2-34

managing, 9-1

maximum checkpoint SCN, 2-31, 2-37

monitoring, 14-6

applied SCN, 14-17

compatible tables, 14-74

downstream capture, 14-9

last redo entry, 14-15

latency, 14-18, 14-19

old log files, 14-13

registered log files, 14-11, 14-13

rule evaluations, 14-20

Oracle Real Application Clusters, 2-27

parameters, 2-47

disable_on_limit, 2-48

message_limit, 2-48

parallelism, 2-48

setting, 9-32

time_limit, 2-48

persistent status, 2-52

preparer servers, 2-29

preparing for, 8-11

reader server, 2-29

redo logs, 2-2

adding manually, 9-33

missing files, 15-4

required checkpoint SCN, 2-31

RESTRICTED SESSION, 2-26

rule evaluation, 2-49

rule sets

removing, 9-31

specifying, 9-27

rules, 2-7, 6-2

adding, 9-28

removing, 9-30

SGA_MAX_SIZE initialization parameter, 2-31

start SCN, 2-24

starting, 9-26

states, 2-30

stopping, 9-26

supplemental logging, 2-15

specifying, 9-33

SYS schema, 2-7, 2-10

SYSTEM schema, 2-7, 2-10

trace files, 15-28

transformations

rule-based, 6-67

troubleshooting, 15-2

checking progress, 15-3

checking status, 15-2

captured SCN, 2-24

character sets

migrating

using Streams, B-14

CLOSE_ITERATOR procedure, 17-11

COMPATIBLE initialization parameter, 8-6, 16-4

COMPATIBLE_10_1 function, 6-56

COMPATIBLE_9_2 function, 6-56

conditions

rules, 5-2

CREATE_APPLY procedure, 4-17, 11-2

CREATE_CAPTURE procedure, 2-32, 9-2, 9-5

CREATE_EVALUATION_CONTEXT procedure, 17-1

CREATE_PROPAGATION procedure, 10-8

CREATE_RULE procedure, 12-4

CREATE_RULE_SET procedure, 12-3

D

database links

Oracle Streams, 8-11

database maintenance

using Streams, B-1

datatypes

applied, 4-11

captured, 2-8

DBA_APPLY view, 14-32, 14-34, 14-37, 14-38, 14-44, 15-13, 15-15

DBA_APPLY_DML_HANDLERS view, 14-36

DBA_APPLY_ENQUEUE view, 14-47

DBA_APPLY_ERROR view, 14-48, 14-50, 14-54, 14-55

DBA_APPLY_EXECUTE view, 14-48

DBA_APPLY_PARAMETERS view, 14-34

DBA_APPLY_PROGRESS view, 14-42

DBA_CAPTURE view, 14-7, 14-9, 14-11, 14-13, 14-17, 15-2

DBA_CAPTURE_EXTRA_ATTRIBUTES view, 14-17

DBA_CAPTURE_PARAMETERS view, 14-16

DBA_EVALUATION_CONTEXT_TABLES view, 14-65

DBA_EVALUATION_CONTEXT_VARS view, 14-66

DBA_LOGMNR_PURGED_LOG view, 2-25, 2-46, 14-13

DBA_PROPAGATION view, 14-27, 14-28, 14-29, 14-31, 15-8, 15-9

DBA_QUEUE_SCHEDULES view, 14-29, 14-31, 15-9

DBA_QUEUE_TABLES view, 14-22

DBA_QUEUES view, 14-22

DBA_REGISTERED_ARCHIVED_LOG view, 14-11, 14-13

DBA_RULE_SET_RULES view, 14-67, 14-68

DBA_RULE_SETS view, 14-65

DBA_RULES view, 14-67, 14-68

DBA_STREAMS_NEWLY_SUPPORTED view, 14-77

DBA_STREAMS_RULES view, 14-63, 15-19

DBA_STREAMS_TRANSFORM_FUNCTION view, 14-69

DBA_STREAMS_UNSUPPORTED view, 14-75

DBID (database identifier)

capture process, 2-33, 9-3

DBMS_APPLY_ADM package, 11-1

DBMS_CAPTURE_ADM package, 9-1

DBMS_PROPAGATION_ADM package, 10-1

DBMS_RULE package, 5-13, 17-1

DBMS_RULE_ADM package, 12-1, 12-2, 17-1

DBMS_STREAMS_ADM package, 6-7, 9-1, 10-1, 11-1

apply process creation, 4-17

capture process creation, 2-32

creating a capture process, 9-2

creating a propagation, 10-8

creating an apply process, 11-2

DDL handlers, 4-4

DELETE_ALL_ERRORS procedure, 11-34

DELETE_ERROR procedure, 4-22, 11-33

DEQUEUE procedure, 10-23, 10-28

example, 16-16

destination queue, 3-2

direct path load

capture processes, 2-14

directed networks, 3-7

apply forwarding, 3-8

queue forwarding, 3-8

DISABLE_DB_ACCESS procedure, 10-5

DISABLE_PROPAGATION_SCHEDULE procedure, 10-18

DML handlers, 4-4

creating, 16-13

DROP_APPLY procedure, 11-10

DROP_CAPTURE procedure, 9-26

DROP_PROPAGATION procedure, 10-19

DROP_RULE procedure, 12-14

DROP_RULE_SET procedure, 12-14

E

ENABLE_DB_ACCESS procedure, 10-3

ENABLE_PROPAGATION_SCHEDULE procedure, 10-11

ENQUEUE procedure, 10-22, 10-27

error handlers

creating, 11-25

monitoring, 14-36

setting, 11-30

unsetting, 11-31

error queue, 4-22

apply process, 15-18

deleting errors, 11-33

executing errors, 11-32

monitoring, 14-48, 14-50

EVALUATE procedure, 5-13, 17-8, 17-11, 17-19, 17-26, 17-34, 17-42, 17-51

evaluation contexts, 5-6

association with rule sets, 5-8

association with rules, 5-8

creating, 17-1

evaluation function, 5-9

object privileges

granting, 12-16

revoking, 12-17

system privileges

granting, 12-15

revoking, 12-17

user-created, 6-54, 6-63

variables, 5-7

event contexts

example, 17-44

system-created rules, 6-50

events

apply process, 4-3

captured, 3-3

dequeue, 3-3

enqueue, 3-3

propagation, 3-5

user-enqueued, 3-3

EXECUTE member procedure, 11-28, 16-13

EXECUTE_ALL_ERRORS procedure, 11-33

EXECUTE_ERROR procedure, 4-22, 11-32

explicit capture, 1-3

Export

Oracle Streams, 13-2

F

first SCN, 2-24

G

GET_ALL_NAMES member function, 17-8, 17-11, 17-19, 17-26, 17-34, 17-42, 17-51

GET_COMMAND_TYPE member function, 11-28, 14-52, 16-13

GET_COMPATIBLE member function, 6-56

GET_DDL_TEXT member function, 14-52

GET_ERROR_MESSAGE function, 14-54, 14-55

GET_EXTRA_ATTRIBUTE member function, 14-52

GET_INFORMATION function, 11-28

GET_NEXT_HIT function, 5-13, 17-11

GET_OBJECT_NAME member function, 11-28, 12-19, 14-52

GET_OBJECT_OWNER member function, 12-19, 14-52

GET_SOURCE_DATABASE_NAME member function, 14-52

GET_STREAMS_NAME function, 11-28

GET_VALUE member function

LCRs, 12-19

rules, 17-8, 17-11, 17-19, 17-26, 17-34, 17-42, 17-51

GET_VALUES member function, 11-28, 14-52, 16-13

global name

capture process, 2-33, 9-3

GLOBAL_NAME view, 14-9, 15-8

GLOBAL_NAMES initialization parameter, 8-6, 16-4

GRANT_ADMIN_PRIVILEGE procedure, 8-2

GRANT_OBJECT_PRIVILEGE procedure, 5-17

GRANT_REMOTE_ADMIN_ACCESS procedure, 9-9

GRANT_SYSTEM_PRIVILEGE procedure, 5-17

H

high availability

Streams, 7-1

advantages, 7-3

apply, 7-11

best practices, 7-6

capture, 7-9

database links, 7-10

propagation, 7-11

I

implicit capture, 1-3

Import

Oracle Streams, 13-2

INCLUDE_EXTRA_ATTRIBUTE procedure, 2-6, 9-38

index-organized tables

capture process, 2-10

initialization parameters

AQ_TM_PROCESSES

Streams apply process, 15-17

COMPATIBLE, 8-6

GLOBAL_NAMES, 8-6

JOB_QUEUE_PROCESSES, 8-6

LOG_ARCHIVE_DEST_n, 8-7

LOG_ARCHIVE_DEST_STATE_n, 8-7

OPEN_LINKS, 8-7

Oracle Streams, 8-6

PARALLEL_MAX_SERVERS, 8-7

PROCESSES, 8-8

REMOTE_ARCHIVE_ENABLE, 8-8

SESSIONS, 8-8

SGA_MAX_SIZE, 8-8

SHARED_POOL_SIZE, 8-8

STREAMS_POOL_SIZE, 3-16, 8-9

TIMED_STATISTICS, 8-10

UNDO_RETENTION, 8-10

instantiation

export/import

Data Pump and original, 2-16

in Streams, 2-15

interoperability

Streams, 14-77

IS_NULL_TAG member function, 14-52

J

job queue processes

propagation jobs, 3-17

JOB_QUEUE_PROCESSES initialization parameter, 8-6, 16-4

propagation, 15-10

L

LCRs. See logical change records

LOG_ARCHIVE_DEST_n initialization parameter, 8-7

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 8-7

logical change records (LCRs), 2-2

apply process, 4-4

DDL LCRs, 2-5

rules, 6-22, 6-43

extra attributes, 2-6

managing, 9-38

monitoring, 14-17

getting compatibility information, 6-56

getting constraint, 11-28

getting information about, 12-19, 14-52

getting sender, 11-28

row LCRs, 2-3

getting list of column values, 11-28

rules, 6-15

setting list of column values, 11-28

XML schema, A-1

LogMiner

capture process, 2-31

multiple sessions, 2-31

M

maximum checkpoint SCN, 2-31, 2-37

message handlers, 4-4

monitoring, 14-37

messaging, 3-12, 10-20

AnyData queues, 10-20

dequeue, 10-25

enqueue, 10-25

messaging clients

example, 16-15

managing, 10-25

notifications

managing, 10-25

messaging client, 3-11

messaging client user

secure queues, 3-20

transformations

rule-based, 6-74

migrating

to different character set

using Streams, B-14

to different operating system

using Streams, B-14

monitoring

AnyData datatype queues, 14-22

event consumers, 14-24

viewing event contents, 14-25

apply process, 14-32

apply handlers, 14-35

compatible tables, 14-74

error handlers, 14-36

error queue, 14-48, 14-50

message handlers, 14-37

capture process, 14-6

applied SCN, 14-17

compatible tables, 14-74

latency, 14-18, 14-19

rule evaluations, 14-20

Oracle Streams, 14-1

performance, 14-79

propagation jobs, 14-27

propagations, 14-27

rule-based transformations, 14-69

rules, 14-56

N

new features, v-xxix

NOLOGGING mode

capture process, 2-13

O

OPEN_LINKS initialization parameter, 8-7

operating systems

migrating

using Streams, B-14

ORA-01291 error, 15-4

ORA-24093 error, 15-11

ORA-25224 error, 15-12

ORA-26678 error, 15-6

Oracle Enterprise Manager Console

Streams tool, 1-24

Oracle Real Application Clusters

interoperation with Oracle Streams, 2-27, 3-14, 4-13

Oracle Streams

administrator

configuring, 8-2

monitoring, 14-4

alert log, 15-27

AnyData queues, 10-20

apply process, 4-1

capture process, 2-1

compatibility, 6-56, 14-74

data dictionary, 3-23, 4-18, 14-1

Data Pump, 2-16

database links, 8-11

database maintenance, B-1

directed networks, 3-7

example environments

single database, 16-1

Export utility, 2-16, 13-2

high availability, 7-1

Import utility, 2-16, 13-2

initialization parameters, 8-6, 16-4

instantiation, 2-15

interoperability, 14-77

logical change records (LCRs), 2-2

XML schema, A-1

LogMiner data dictionary, 2-34

messaging, 3-12, 10-20

messaging clients, 3-11

monitoring, 14-1

network connectivity, 8-11

new features, v-xxix

overview, 1-2

packages, 1-22

preparing for, 8-1

propagation, 3-1

Oracle Real Application Clusters, 3-14

rules, 6-1

action context, 6-50

evaluation context, 6-11, 6-45

event context, 6-50

subset rules, 6-12, 6-23

system-created, 6-7

staging, 3-1

Oracle Real Application Clusters, 3-14

Streams data dictionary, 2-45

Streams pool, 3-16

Streams tool, 1-24

supplemental logging, 2-15

tags, 1-17

trace files, 15-27

transformations

rule-based, 6-63

troubleshooting, 15-1

upgrading online, B-3

user messages, 3-2

P

PARALLEL_MAX_SERVERS initialization parameter, 8-7

patches

applying

using Streams, B-14

precommit handlers, 4-8

creating, 11-18

monitoring, 14-37

removing, 11-21

setting, 11-20

privileges

Oracle Streams administrator, 8-2

monitoring, 14-4

rules, 5-17

PROCESSES initialization parameter, 8-8

propagation jobs, 3-17

altering, 10-12

disabling, 10-18

enabling, 10-11

job queue processes, 3-17

managing, 10-7

monitoring, 14-27

RESTRICTED SESSION, 3-19

scheduling, 3-18, 10-12

trace files, 15-28

troubleshooting, 15-7

checking status, 15-9

job queue processes, 15-10

unscheduling, 10-13

propagations, 3-1

architecture, 3-16

binary files, 3-11

buffered queues, 3-16

creating, 10-8

destination queue, 3-2

directed networks, 3-7

dropping, 10-19

ensured delivery, 3-6

managing, 10-7

monitoring, 14-27

queues, 3-5

rule sets

removing, 10-18

specifying, 10-14

rules, 3-5, 6-2

adding, 10-15

removing, 10-17

source queue, 3-2

transformations

rule-based, 6-69

troubleshooting, 15-7

checking queues, 15-8

security, 15-11

Q

queue forwarding, 3-8

queues

AnyData, 3-12, 10-20

creating, 10-2

dequeuing, 16-16

removing, 10-6

nontransactional, 3-22

secure, 3-19

disabling user access, 10-5

enabling user access, 10-3

users, 3-20

transactional, 3-22

typed, 3-12

R

RE$NAME_ARRAY type, 17-26, 17-34, 17-42, 17-51

RE$NV_LIST type, 5-13, 17-6, 17-16, 17-25, 17-26, 17-34, 17-40, 17-42, 17-51

ADD_PAIR member procedure, 12-8, 12-10, 12-24, 12-26

REMOVE_PAIR member procedure, 12-8, 12-11, 12-26, 12-27

RE$RULE_HIT_LIST type, 17-8, 17-19, 17-26, 17-34, 17-42, 17-51

RE$TABLE_ALIAS_LIST type, 17-24, 17-32, 17-40, 17-48

RE$TABLE_VALUE type, 17-26, 17-34, 17-42, 17-51

RE$TABLE_VALUE_LIST type, 17-26, 17-34, 17-42, 17-51

RE$VARIABLE_TYPE_LIST type, 17-5, 17-16, 17-32, 17-40, 17-48

RE$VARIABLE_VALUE type, 17-8, 17-11, 17-19, 17-34

RE$VARIABLE_VALUE_LIST type, 17-8, 17-11, 17-19, 17-34

redo logs

capture process, 2-2

re-enqueue

captured events, 16-1

REMOTE_ARCHIVE_ENABLE initialization parameter, 8-8

REMOVE_PAIR member procedure, 12-8, 12-11, 12-26, 12-27

REMOVE_QUEUE procedure, 10-6

REMOVE_RULE procedure, 9-30, 10-17, 11-14, 12-14

required checkpoint SCN, 2-31, 2-46

RESTRICTED SESSION system privilege

apply processes, 4-12

capture processes, 2-26

propagation jobs, 3-19

REVOKE_OBJECT_PRIVILEGE procedure, 5-17

REVOKE_SYSTEM_PRIVILEGE procedure, 5-17

row migration, 6-27

rule sets, 5-2

adding rules to, 12-6

creating, 12-3

dropping, 12-14

evaluation, 5-13

partial, 5-15

negative, 6-4

object privileges

granting, 12-16

revoking, 12-17

positive, 6-4

removing rules from, 12-14

system privileges

granting, 12-15

revoking, 12-17

rule-based transformations, 6-63

rules, 5-1

action contexts, 5-10

adding name-value pairs, 12-8, 12-10, 12-24, 12-26

altering, 12-8

removing name-value pairs, 12-8, 12-11, 12-26, 12-27

transformations, 6-63

ADD_RULE procedure, 5-8

altering, 12-7

apply process, 4-2, 6-2

capture process, 2-7, 6-2

components, 5-2

creating, 12-4

DBMS_RULE package, 5-13

DBMS_RULE_ADM package, 12-1

dropping, 12-14

EVALUATE procedure, 5-13, 17-1

evaluation, 5-13, 17-1

capture process, 2-49

iterators, 5-13

partial, 5-15

evaluation contexts, 5-6

creating, 17-1

evaluation function, 5-9

user-created, 6-63

variables, 5-7

event context, 5-13

example, 17-44

example applications, 17-1

explicit variables, 5-7

example, 17-3, 17-28

implicit variables, 5-7

example, 17-36

iterative results, 5-13

example, 17-10

managing, 12-2

MAYBE rules, 5-13

example, 17-14

maybe_rules, 5-13

monitoring, 14-56

object privileges

granting, 12-16

revoking, 12-17

partial evaluation, 5-15

example, 17-14

privileges, 5-17

managing, 12-15

propagations, 3-5, 6-2

rule conditions, 5-2, 6-20, 6-23

complex, 6-58

explicit variables, 5-7

finding patterns in, 14-68

implicit variables, 5-7

Streams compatibility, 6-56

types of operations, 6-55

undefined variables, 6-61

using NOT, 6-59

variables, 6-15

rule_hits, 5-13

simple rules, 5-4

subset, 6-23

querying for action context of, 12-22

querying for names of, 12-22

system privileges

granting, 12-15

revoking, 12-17

system-created, 6-1, 6-7

action context, 6-50

and_condition parameter, 6-44

DDL rules, 6-22, 6-43

DML rules, 6-15

evaluation context, 6-11, 6-45

event context, 6-50

global, 6-14

modifying, 12-13

row migration, 6-27

schema, 6-18

STREAMS$EVALUATION_CONTEXT, 6-11, 6-45

subset, 6-12, 6-23

table, 6-20

table data

example, 17-22, 17-28, 17-36

troubleshooting, 15-18

TRUE rules, 5-13

user-created, 6-54

variables, 5-7

S

SCHEDULE_PROPAGATION procedure, 10-12

secure queues, 3-19

disabling user access, 10-5

enabling user access, 10-3

propagation, 15-11

Streams clients

users, 3-20

SESSIONS initialization parameter, 8-8

SET_COMMAND_TYPE member procedure, 16-13

SET_DML_HANDLER procedure, 4-6

setting an error handler, 11-30

unsetting an error handler, 11-31

SET_ENQUEUE_DESTINATION procedure, 11-21, 16-15

SET_EXECUTE procedure, 11-23

SET_MESSAGE_NOTIFICATION procedure, 10-28

SET_OBJECT_NAME member procedure, 16-13

SET_PARAMETER procedure

apply process, 11-16

capture process, 9-32

SET_RULE_TRANSFORM_FUNCTION procedure, 12-18

SET_UP_QUEUE procedure, 10-2

SET_VALUE member procedure

LCRs, 12-19

SET_VALUES member procedure, 11-28, 16-13

SGA_MAX_SIZE initialization parameter, 2-31, 8-8

SHARED_POOL_SIZE initialization parameter, 8-8

source queue, 3-2

SQL*Loader

capture processes, 2-14

staging, 3-1

architecture, 3-16

buffered queues, 3-16

events, 3-3

management, 10-1

secure queues, 3-19

disabling user access, 10-5

enabling user access, 10-3

start SCN, 2-24

START_APPLY procedure, 11-10

START_CAPTURE procedure, 9-26

Statspack

Oracle Streams, 14-79

STOP_APPLY procedure, 11-10

STOP_CAPTURE procedure, 9-26

Streams data dictionary, 2-45, 3-23, 4-18

Streams pool, 3-16

Streams. See Oracle Streams

Streams tool, 1-24

STREAMS$_EVALUATION_CONTEXT, 6-11, 6-45

STREAMS$_TRANSFORM_FUNCTION, 6-64

STREAMS_POOL_SIZE initialization parameter, 3-16, 8-9

supplemental logging

capture process, 2-15

example, 16-10

row subsetting, 6-32

specifying, 9-33

SYS.AnyData. See Also AnyData datatype

system change numbers (SCN)

applied SCN for a capture process, 2-24, 14-17

captured SCN for a capture process, 2-24

first SCN for a capture process, 2-24

maximum checkpoint SCN for a capture process, 2-31

required checkpoint SCN for a capture process, 2-31

start SCN for a capture process, 2-24

T

tags, 1-17

TIMED_STATISTICS initialization parameter, 8-10

trace files

Oracle Streams, 15-27

transformations

Oracle Streams, 6-63

rule-based, 6-63

action context, 6-63

altering, 12-25

apply process, 6-71

capture process, 6-67

creating, 12-19

errors during apply, 6-73

errors during capture, 6-69

errors during dequeue, 6-75

errors during propagation, 6-71

managing, 12-18

messaging client, 6-74

multiple, 6-75

propagations, 6-69

removing, 12-27

STREAMS$_TRANSFORM_FUNCTION, 6-64

troubleshooting, 15-26

troubleshooting

apply process, 15-13

checking apply handlers, 15-17

checking event type, 15-15

checking status, 15-13

error queue, 15-18

capture process, 15-2

checking progress, 15-3

checking status, 15-2

Oracle Streams, 15-1

propagation jobs, 15-7

checking status, 15-9

job queue processes, 15-10

propagations, 15-7

checking queues, 15-8

security, 15-11

rule-based transformations, 15-26

rules, 15-18

U

UNDO_RETENTION initialization parameter, 8-10

UNRECOVERABLE clause

SQL*Loader

capture process, 2-14

UNRECOVERABLE keyword

capture process, 2-13

UNSCHEDULE_PROPAGATION procedure, 10-13

upgrading

online using Streams, B-3

user messages, 3-2

V

V$ARCHIVED_LOG view, 2-24

V$RULE view, 14-74

V$RULE_SET view, 14-71, 14-72

V$RULE_SET_AGGREGATE_STATS view, 14-70

V$SESSION view, 14-8, 14-38, 14-39, 14-40, 14-44

V$STREAMS_APPLY_COORDINATOR view, 4-16, 14-40, 14-41, 14-42

V$STREAMS_APPLY_READER view, 4-15, 14-38, 14-39

V$STREAMS_APPLY_SERVER view, 4-16, 14-44, 14-46

V$STREAMS_CAPTURE view, 2-30, 14-8, 14-15, 14-18, 14-19, 14-20, 15-3

X

XML Schema

for LCRs, A-1