Oracle9i Streams -- Index

ABORT_GLOBAL_INSTANTIATION procedure, 12-12

ABORT_SCHEMA_INSTANTIATION procedure, 12-12

ABORT_TABLE_INSTANTIATION procedure, 12-12

action contexts, 5-9

adding name-value pairs, 15-16, 15-20

creating

example, 22-35

querying, 15-15

removing name-value pairs, 15-20

system-created rules, 6-18

ADD SUPPLEMENTAL LOG DATA clause, 12-10

ADD SUPPLEMENTAL LOG GROUP clause, 12-9, 20-12, 21-12, 22-23, 23-26

ADD_COLUMN member procedure, 20-16

ADD_GLOBAL_RULES procedure, 6-14

ADD_PAIR member procedure, 15-16, 15-20, 22-35, 24-6, 24-13, 24-31

ADD_RULE procedure, 5-8, 15-5

ADD_SCHEMA_PROPAGATION_RULES procedure, 6-12

ADD_SUBSCRIBER procedure, 13-3, 19-25, 20-15

ADD_SUBSET_RULES procedure, 4-12, 6-5, 6-6

row migration, 4-12

ADD_TABLE_RULES procedure, 6-6

alert log

Oracle Streams entries, 18-24

ALL_STREAMS_GLOBAL_RULES view, 17-44

ALL_STREAMS_SCHEMA_RULES view, 17-44

ALL_STREAMS_TABLE_RULES view, 17-44

ALTER DATABASE statement

ADD SUPPLEMENTAL LOG DATA clause, 12-10

DROP SUPPLEMENTAL LOG DATA clause, 12-10

ALTER TABLE statement

ADD SUPPLEMENTAL LOG GROUP clause, 12-9, 20-12, 21-12, 22-23, 23-26

DROP SUPPLEMENTAL LOG GROUP clause, 12-10

ALTER_APPLY procedure

removing the DDL handler, 14-21

removing the message handler, 14-13

removing the rule set, 14-10

removing the tag value, 16-28

setting an apply user, 14-12

setting the DDL handler, 14-20

setting the message handler, 14-13

setting the tag value, 8-2, 8-6, 16-28

specifying the rule set, 14-8

ALTER_CAPTURE procedure

removing the rule set, 12-7

setting the start SCN, 12-11

specifying a rule set, 12-5

ALTER_PROPAGATION procedure

removing the rule set, 13-16

specifying the rule set, 13-14

ALTER_PROPAGATION_SCHEDULE procedure, 13-12

ALTER_RULE procedure, 15-5

AnyData datatype

message propagation, 3-16

queues, 3-11, 13-18

creating, 13-2

dequeuing, 13-22

dropping, 13-7

enqueuing, 13-19

monitoring, 17-12

propagating to typed queues, 3-16

user-defined types, 3-17

wrapper for messages, 3-11, 13-19

applied SCN, 2-16, 4-28, 17-7

apply forwarding, 3-8

apply process, 4-1

applied SCN, 4-28

apply forwarding, 3-8

apply handlers, 4-16

apply servers, 4-31

apply user, 4-2

setting, 14-12

architecture, 4-30

automatic restart, 4-36

conflict handlers, 4-16

heterogeneous environments, 9-5

conflict resolution, 4-16, 7-1

constraints, 4-10

coordinator process, 4-31

creating, 14-2

creation, 4-32

datatypes applied, 4-9

heterogeneous environments, 9-6

DDL changes, 4-21

CREATE TABLE AS SELECT, 4-24

current schema, 4-23

data structures, 4-22

ignored, 4-21

system-generated names, 4-23

DDL handlers, 4-4

creating, 14-19

monitoring, 17-24

removing, 14-21

setting, 14-20

dependent transactions, 18-12

DML changes, 4-10

heterogeneous environments, 9-7

DML handlers, 4-4

creating, 14-14, 20-16

heterogeneous environments, 9-5

monitoring, 17-23

re-enqueue captured events, 20-1

setting, 14-16

dropping, 14-7

error handlers

creating, 14-21

heterogeneous environments, 9-5

monitoring, 17-23

setting, 14-26

events, 4-3

captured, 4-3

user-enqueued, 4-3

exception queue, 4-37

monitoring, 17-36, 17-37

heterogeneous environments, 9-3, 9-12

database links, 9-4

example, 22-38

high-watermark, 4-28

ignore SCN, 4-27

instantiation SCN, 4-27

key columns, 4-10

LOBs, 16-13

logical change records (LCRs), 4-4

low-watermark, 4-28

managing, 14-1

message handlers, 4-4

creating, 19-17

heterogeneous environments, 9-5

monitoring, 17-24

removing, 14-13

setting, 14-13

monitoring, 17-20

apply handlers, 17-23

latency, 17-29, 17-31

non-LCR events, 4-7

oldest SCN, 4-28

options, 4-4

Oracle Real Application Clusters, 4-29

parallelism, 17-35

parameters, 4-34

commit_serialization, 4-35, 18-12

disable_on_error, 4-36

disable_on_limit, 4-36

heterogeneous environments, 9-5

parallelism, 4-34, 18-12

setting, 14-11

time_limit, 4-36

transaction_limit, 4-36

persistent state, 4-36

reader server, 4-31

RESTRICTED SESSION, 4-29

row migration, 4-12

row subsetting, 4-12, 6-5

supplemental logging, 4-14

rule set

removing, 14-10

specifying, 14-8

rules, 4-2, 6-2

adding, 14-8

removing, 14-9

starting, 14-7

stopping, 14-7

substitute key columns, 4-11

heterogeneous environments, 9-4, 9-5

removing, 14-29

setting, 14-28

tables, 4-10

apply handlers, 4-16

column discrepancies, 4-14

tags, 8-6

monitoring, 17-51

removing, 16-28

setting, 16-28

trace files, 18-26

transformations

rule-based, 6-32

triggers

firing property, 4-25

ON SCHEMA clause, 4-26

troubleshooting, 18-9

checking apply handlers, 18-12

checking event type, 18-11

checking status, 18-10

exception queue, 18-13

AQ_TM_PROCESSES initialization parameter, 11-5, 21-3, 22-5

ARCHIVE_LAG_TARGET initialization parameter, 11-5

ARCHIVELOG mode

capture process, 2-25, 11-13, 20-4, 21-3, 22-6

backups

online

Streams, 8-5

capture process, 2-1

applied SCN, 2-16, 17-7

architecture, 2-18

ARCHIVELOG mode, 2-25, 11-13, 20-4, 21-3, 22-6

automatic restart, 2-26

builder server, 2-19

captured events, 3-3

captured SCN, 2-16

changes captured, 2-7

DDL changes, 2-8

DML changes, 2-7

NOLOGGING keyword, 2-9

UNRECOVERABLE clause for SQL*Loader, 2-10

UNRECOVERABLE keyword, 2-9

configuring, 11-13

creating, 12-2

creation, 2-21

data dictionary duplication, 2-22

datatypes captured, 2-6

DBID, 2-22, 12-13

DBNAME, 2-22

dropping, 12-14

heterogeneous environments, 9-3

log sequence number, 12-13

LogMiner, 2-20

alternate tablespace for, 2-20, 11-13

multiple sessions, 2-20

LOGMNR_MAX_PERSISTENT_SESSIONS initialization parameter, 2-20

managing, 12-1

monitoring, 17-3

applied SCN, 17-7

latency, 17-7, 17-8

Oracle Real Application Clusters, 2-17

parameters, 2-25

disable_on_limit, 2-26

message_limit, 2-26

parallelism, 2-26

setting, 12-8

time_limit, 2-26

persistent state, 2-30

preparer servers, 2-19

reader server, 2-19

redo logs, 2-2

re-enqueue events, 20-1

RESTRICTED SESSION, 2-16

rule evaluation, 2-27

rule set

removing, 12-7

specifying, 12-5

rules, 2-5, 6-2

adding, 12-5

removing, 12-6

start SCN, 2-15, 2-16

setting, 12-11

starting, 12-5

stopping, 12-14

supplemental logging, 2-11

specifying, 12-9

SYS schema, 2-6, 2-7

SYSTEM schema, 2-6, 2-7

trace files, 18-25

transformations

rule-based, 6-28

troubleshooting, 18-2

checking progress, 18-3

checking status, 18-2

log parallelism, 18-3

persistent sessions, 18-4

captured SCN, 2-16

change cycling

avoidance

tags, 8-8

column lists, 7-12

COMPATIBLE initialization parameter, 11-5, 19-4, 20-4, 21-3, 22-5

conditions

rules, 5-2

conflict resolution, 7-1

column lists, 7-12

conflict handlers, 7-4, 7-5, 7-6, 7-8

custom, 7-15

interaction with apply handlers, 4-16

modifying, 14-31

prebuilt, 7-8

removing, 14-32

setting, 14-30

data convergence, 7-15

DISCARD handler, 7-10

MAXIMUM handler, 7-10

example, 23-32

latest time, 7-11

MINIMUM handler, 7-12

OVERWRITE handler, 7-10

resolution columns, 7-14

time-based, 7-11

example, 23-32

preparing for, 23-12

conflicts

avoidance, 7-6

delete, 7-7

primary database ownership, 7-6

uniqueness, 7-6

update, 7-7

delete, 7-3

detection, 7-5

identifying rows, 7-5

DML conflicts, 7-2

foreign key, 7-3

transaction ordering, 7-4

types of, 7-2

uniqueness, 7-3

update, 7-3

CONVERT_ANYDATA_TO_LCR_DDL function, 13-28

CONVERT_ANYDATA_TO_LCR_ROW function, 13-28

CREATE TABLE statement

AS SELECT

apply process, 4-24

CREATE_APPLY procedure, 4-32, 14-2

tags, 8-2, 8-6

CREATE_CAPTURE procedure, 2-21, 12-2, 12-4

CREATE_EVALUATION_CONTEXT procedure, 24-5, 24-12, 24-21, 24-31

CREATE_PROPAGATION procedure, 13-8

CREATE_RULE procedure, 15-3

CREATE_RULE_SET procedure, 15-2

database links

Oracle Streams, 11-14

datatypes

applied, 4-9

captured, 2-6

heterogeneous environments, 9-6

DBA_APPLY view, 17-21, 17-24, 17-28, 17-33, 17-51, 18-10, 18-11

DBA_APPLY_CONFLICT_COLUMNS view, 17-26

DBA_APPLY_DML_HANDLERS view, 17-23

DBA_APPLY_ERROR view, 17-36, 17-37, 17-40, 17-41

DBA_APPLY_INSTANTIATED_OBJECTS view, 17-27

DBA_APPLY_KEY_COLUMNS view, 17-25

DBA_APPLY_PARAMETERS view, 17-22

DBA_APPLY_PROGRESS view, 17-31

DBA_CAPTURE view, 17-3, 17-7, 18-2

DBA_CAPTURE_PARAMETERS view, 17-6

DBA_CAPTURE_PREPARED_DATABASE view, 17-9

DBA_CAPTURE_PREPARED_SCHEMAS view, 17-9

DBA_CAPTURE_PREPARED_TABLES view, 17-9

DBA_EVALUATION_CONTEXT_TABLES view, 17-45

DBA_EVALUATION_CONTEXT_VARS view, 17-46

DBA_LOG_GROUPS view, 17-11

DBA_PROPAGATION view, 17-15, 17-16, 17-17, 17-19, 18-5, 18-6

DBA_QUEUE_SCHEDULES view, 17-17, 17-19, 18-6

DBA_QUEUE_TABLES view, 17-12

DBA_QUEUES view, 17-12

DBA_RULE_SET_RULES view, 17-47, 17-48, 17-49

DBA_RULE_SETS view, 17-45

DBA_RULES view, 17-47, 17-48, 17-49

DBA_STREAMS_GLOBAL_RULES view, 17-44, 18-19

DBA_STREAMS_SCHEMA_RULES view, 17-44, 18-19, 18-21

DBA_STREAMS_TABLE_RULES view, 17-44, 18-18, 18-19

DBID (database identifier)

capture process, 2-22

DBMS_APPLY_ADM package, 14-1

DBMS_CAPTURE_ADM package, 12-1

DBMS_PROPAGATION_ADM package, 13-1

DBMS_RULE package, 5-12, 24-1

DBMS_RULE_ADM package, 15-2, 24-1

DBMS_STREAMS package, 16-26

DBMS_STREAMS_ADM package, 6-3, 12-1, 13-1, 14-1

apply process creation, 4-32

capture process creation, 2-21

creating a capture process, 12-2

creating a propagation, 13-8

creating an apply process, 14-2

tags, 8-3

DBMS_TRANSFORM package, 13-26, 13-29

DBNAME

capture process, 2-22

DDL handlers, 4-4

creating, 14-19

monitoring, 17-24

removing, 14-21

setting, 14-20

DELETE_ALL_ERRORS procedure, 14-35

DELETE_ERROR procedure, 4-37, 14-34

DEQUEUE procedure, 13-22

example, 19-25, 20-18

destination queue, 3-2

direct path load

capture processes, 2-10

directed networks, 3-7

apply forwarding, 3-8

queue forwarding, 3-8

DISABLE_DB_ACCESS procedure, 13-5

DISABLE_PROPAGATION_SCHEDULE procedure, 13-17

DISCARD conflict resolution handler, 7-10

DML handlers, 4-4, 4-16

creating, 14-14, 20-16

monitoring, 17-23

removing, 14-18

setting, 14-16

DROP SUPPLEMENTAL LOG DATA clause, 12-10

DROP SUPPLEMENTAL LOG GROUP clause, 12-10

DROP_APPLY procedure, 14-7

DROP_CAPTURE procedure, 12-14

DROP_PROPAGATION procedure, 13-18

DROP_RULE procedure, 15-7

DROP_RULE_SET procedure, 15-8

ENABLE_DB_ACCESS procedure, 13-3

ENABLE_PROPAGATION_SCHEDULE procedure, 13-11

ENQUEUE procedure, 13-20, 16-4, 19-12, 20-16

error handlers, 4-16

creating, 14-21

monitoring, 17-23

removing, 14-27

setting, 14-26

EVALUATE procedure, 5-12, 24-8, 24-14, 24-24, 24-34

evaluation contexts, 5-5

association with rule sets, 5-8

association with rules, 5-8

creating, 19-19, 24-5, 24-12, 24-21, 24-31

evaluation function, 5-8

object privileges

granting, 15-9

revoking, 15-10

system privileges

granting, 15-9

revoking, 15-10

user-created, 6-19, 6-24

variables, 5-6

event contexts

system-created rules, 6-18

events

apply process, 4-3

captured, 3-3

propagating, 13-28

dequeue, 3-3

programmatic environments, 3-12

enqueue, 3-3

programmatic environments, 3-12

propagation, 3-4

user-enqueued, 3-3

propagating, 13-24

exception queues, 4-37

apply process, 18-13

deleting errors, 14-34

executing errors, 14-33

heterogeneous environments, 9-10

monitoring, 17-36, 17-37

EXECUTE member procedure, 14-15, 14-20, 14-24, 20-16

EXECUTE_ALL_ERRORS procedure, 14-34

EXECUTE_ERROR procedure, 4-37, 14-33

Export

OBJECT_CONSISTENT parameter, 11-9, 11-10, 21-14, 22-27, 23-48

Oracle Streams, 11-8, 14-36, 16-35

GET_ALL_NAMES member function, 24-8, 24-14, 24-24, 24-34

GET_BASE_TABLE_NAME member function, 14-20

GET_BASE_TABLE_OWNER member function, 14-20

GET_COMMAND_TYPE member function, 14-20, 14-24, 17-39, 20-16

GET_CURRENT_SCHEMA member function, 14-20

GET_DDL_TEXT member function, 17-39

GET_ERROR_MESSAGE function, 17-40, 17-41

GET_INFORMATION function, 14-24

GET_LOB_INFORMATION member function, 16-8

use_old parameter, 16-8

GET_LOGON_USER member function, 14-20

GET_OBJECT_NAME member function, 14-15, 14-20, 14-24, 15-12, 17-39, 22-34

GET_OBJECT_OWNER member function, 14-15, 14-20, 15-12, 17-39

GET_SCN member function, 14-15, 14-20

GET_SOURCE_DATABASE_NAME member function, 14-20, 17-39

GET_TAG function, 16-27, 17-50

GET_TAG member function, 14-15, 14-20

GET_TRANSACTION_ID member function, 14-15, 14-20

GET_VALUE member function

LCRs, 15-12, 16-9

use_old parameter, 16-8

rules, 24-8, 24-14, 24-24, 24-34

GET_VALUES member function, 14-15, 14-24, 16-10, 17-39, 20-16

use_old parameter, 16-8

GLOBAL_NAMES initialization parameter, 11-5, 19-4, 20-4, 21-3, 22-5

GLOBAL_NAMES view, 18-5

GRANT_OBJECT_PRIVILEGE procedure, 5-15

GRANT_SYSTEM_PRIVILEGE procedure, 5-15

heterogeneous information sharing, 9-1

non-Oracle to non-Oracle, 9-13

non-Oracle to Oracle, 9-10

apply process, 9-12

capturing changes, 9-11

instantiation, 9-12

user application, 9-11

Oracle to non-Oracle, 9-2

apply process, 9-3

capture process, 9-3

conflict handlers, 9-5

database links, 9-4

datatypes applied, 9-6

DML changes, 9-7

DML handlers, 9-5

error handlers, 9-5

errors, 9-10

instantiation, 9-7

message handlers, 9-5

parallelism, 9-5

staging, 9-3

substitute key columns, 9-4, 9-5

transformations, 9-9

high availability

Streams, 10-1

advantages, 10-3

apply, 10-11

best practices, 10-7

capture, 10-10

database links, 10-9

propagation, 10-11

high-watermark, 4-28

ignore SCN, 4-27

Import

Oracle Streams, 11-8, 14-36, 16-35

STREAMS_CONFIGURATION parameter, 11-10

STREAMS_INSTANTIATION parameter, 11-10, 21-15, 22-28, 23-49

initialization parameters

AQ_TM_PROCESSES, 11-5

ARCHIVE_LAG_TARGET, 11-5

COMPATIBLE, 11-5

GLOBAL_NAMES, 11-5

JOB_QUEUE_PROCESSES, 11-6

LOG_PARALLELISM, 11-6

LOGMNR_MAX_PERSISTENT_SESSIONS,

11-6

OPEN_LINKS, 11-6

Oracle Streams, 11-4

PARALLEL_MAX_SERVERS, 11-7

PROCESSES, 11-7

SESSIONS, 11-7

SGA_MAX_SIZE, 11-7

SHARED_POOL_SIZE, 11-8

instantiation

aborting preparation, 12-12

example, 21-14, 22-27, 22-48, 23-48

heterogeneous environments

non-Oracle to Oracle, 9-12

Oracle to non-Oracle, 9-7

Oracle Streams, 11-8, 14-36

preparing for, 2-13, 11-15, 12-11

setting an SCN, 11-15, 14-35

DDL LCRs, 14-38

export/import, 14-36

supplemental logging specifications, 2-15

instantiation SCN, 4-27

IS_NULL_TAG member function, 6-8, 17-39

IS_TRIGGER_FIRE_ONCE function, 4-25

JMS

Oracle Streams

example, 19-35

job queue processes

propagation jobs, 3-20

JOB_QUEUE_PROCESSES initialization parameter, 11-6, 21-3, 22-5

propagation, 18-7

LCR$_ROW_UNIT type

GET_LOB_INFORMATION member function, 16-8

LCRs. See logical change records

LOBs

Oracle Streams, 16-11

apply process, 16-13

constructing, 16-14

requirements, 16-12

LOG_PARALLELISM initialization parameter, 11-6, 20-4, 21-3, 22-5

capture process, 18-3

logical change records (LCRs), 2-2

apply process, 4-4

constructing, 16-2

example, 19-13

DDL LCRs, 2-4

current_schema, 4-23

rules, 6-9

determining if tag is NULL, 6-8

enqueuing, 16-2

getting constraint, 14-24

getting information about, 14-15, 14-20, 15-12, 17-39

getting sender, 14-24

row LCRs, 2-3

getting column value, 16-9

getting list of column values, 14-24, 16-10

rules, 6-7

setting list of column values, 14-24

XML schema, A-1

LogMiner

alternate tablespace for, 2-20, 11-13

capture process, 2-20

multiple sessions, 2-20

LOGMNR_MAX_PERSISTENT_SESSIONS initialization parameter, 2-20, 11-6

capture process, 18-4

low-watermark, 4-28

MAXIMUM conflict resolution handler, 7-10

latest time, 7-11

message handlers, 4-4

creating, 19-17

monitoring, 17-24

messaging

Oracle Streams, 19-1

propagation, 3-16

MINIMUM conflict resolution handler, 7-12

monitoring

AnyData datatype queues, 17-12

event consumers, 17-13

viewing event contents, 17-13

apply process, 17-20

apply handlers, 17-23

DDL handlers, 17-24

error handlers, 17-23

exception queue, 17-36, 17-37

message handlers, 17-24

capture process, 17-3

applied SCN, 17-7

latency, 17-7, 17-8

DML handlers, 17-23

Oracle Streams, 17-1

propagation jobs, 17-15

propagations, 17-15

rule-based transformations

procedures, 17-49

rules, 17-42

tags, 17-50

apply process value, 17-51

current session value, 17-50

NOLOGGING mode

capture process, 2-9

OBJECT_CONSISTENT parameter

for Export utility, 11-9, 11-10, 21-14, 22-27, 23-48

oldest SCN, 4-28

ON SCHEMA clause

of CREATE TRIGGER

apply process, 4-26

OPEN_LINKS initialization parameter, 11-6

ORA-01403 error, 18-14

ORA-24093 error, 18-8

ORA-25224 error, 18-9

ORA-26687 error, 18-15

ORA-26688 error, 18-15

ORA-26689 error, 18-16

Oracle Enterprise Manager

Streams tool, 1-23

Oracle Real Application Clusters

interoperation with Oracle Streams, 2-17, 3-18, 4-29

Oracle Streams

adding databases, 11-22, 11-35, 22-76

adding objects, 11-19, 11-30, 22-64

administrator

creating, 11-2

alert log, 18-24

AnyData queues, 13-18

apply process, 4-1

capture process, 2-1

configuring, 11-15

conflict resolution, 7-1

data dictionary, 2-22, 3-25, 4-33

data dictionary views, 17-1

database links, 11-14

directed networks, 3-7

example environments

messaging, 19-1

replication, 21-1, 22-1, 23-1

single database, 20-1

Export utility, 11-8, 14-36, 16-35

heterogeneous information sharing, 9-1

high availability, 10-1

Import utility, 11-8, 14-36, 16-35

initialization parameters, 11-4, 19-4, 20-4, 21-3, 22-5

instantiation, 11-8, 14-36

JMS, 3-12

example, 19-35

LOBs, 16-11

logical change records (LCRs), 2-2

XML schema, A-1

messaging, 13-18

monitoring, 17-1

network connectivity, 11-14

OCI, 3-12

overview, 1-2

packages, 1-21

point-in-time recovery, 16-29

preparing for, 11-1

propagation, 3-1

Oracle Real Application Clusters, 3-18

rules, 6-1

action context, 6-18

evaluation context, 6-5, 6-15

event context, 6-18

subset rules, 4-12, 6-5

system-created, 6-3

staging, 3-1

Oracle Real Application Clusters, 3-18

Streams tool, 1-23

supplemental logging, 2-11

tags, 8-1

trace files, 18-24

transformations

rule-based, 6-25

troubleshooting, 18-1

OVERWRITE conflict resolution handler, 7-10

PARALLEL_MAX_SERVERS initialization parameter, 11-7

point-in-time recovery

Oracle Streams, 16-29

PREPARE_GLOBAL_INSTANTIATION procedure, 2-13, 11-15, 12-11

PREPARE_SCHEMA_INSTANTIATION procedure, 2-13, 11-15, 12-11

PREPARE_TABLE_INSTANTIATION procedure, 2-13, 11-15, 12-11

privileges

Oracle Streams administrator, 11-2

rules, 5-15

PROCESSES initialization parameter, 11-7

propagation jobs, 3-20

altering, 13-12

disabling, 13-17

enabling, 13-11

job queue processes, 3-20

managing, 13-7

monitoring, 17-15

RESTRICTED SESSION, 3-22

scheduling, 3-21, 13-11

trace files, 18-25

troubleshooting, 18-4

checking status, 18-6

job queue processes, 18-7

unscheduling, 13-13

propagations, 3-1

architecture, 3-19

creating, 13-8

database links

creating, 21-7, 22-12

destination queue, 3-2

directed networks, 3-7

dropping, 13-18

ensured delivery, 3-6

managing, 13-7

monitoring, 17-15

queue buffers, 3-19

queues, 3-4

rule sets

removing, 13-16

specifying, 13-14

rules, 3-5, 6-2

adding, 13-14

removing, 13-16

source queue, 3-2

transformations

rule-based, 6-30

SYS.AnyData to typed queue, 13-24, 13-28

troubleshooting, 18-4

checking queues, 18-5

security, 18-8

queue buffers, 3-19

queue forwarding, 3-8

queues

AnyData, 3-11, 13-18

creating, 13-2

dequeuing, 19-25, 20-18

dropping, 13-7

enqueuing, 19-12, 20-16

user-defined types, 3-17

nontransactional, 3-24

propagation, 3-16

secure, 3-22

disabling user access, 13-5

enabling user access, 13-3

transactional, 3-24

RE$NAME_ARRAY type, 24-14, 24-24, 24-34

RE$NV_ARRAY type, 22-35

RE$NV_LIST type, 5-12, 22-35, 24-6, 24-13, 24-14, 24-24, 24-31, 24-34

ADD_PAIR member procedure, 15-16, 15-20

REMOVE_PAIR member procedure, 15-20, 15-21

RE$RULE_HIT_LIST type, 24-8, 24-14, 24-24, 24-34

RE$TABLE_ALIAS_LIST type, 24-12, 24-21, 24-31

RE$TABLE_VALUE type, 24-14, 24-24, 24-34

RE$TABLE_VALUE_LIST type, 24-14, 24-24, 24-34

RE$VARIABLE_TYPE_LIST type, 24-5, 24-21, 24-31

RE$VARIABLE_VALUE type, 24-8, 24-24

RE$VARIABLE_VALUE_LIST type, 24-8, 24-24

redo logs

capture process, 2-2

re-enqueue

captured events, 20-1

REMOVE_PAIR member procedure, 15-20, 15-21

REMOVE_RULE procedure, 12-6, 13-16, 14-9, 15-7

replication

Oracle Streams, 21-1, 22-1, 23-1

adding databases, 22-76

adding objects, 22-64

resolution columns, 7-14

RESTRICTED SESSION system privilege

apply processes, 4-29

capture processes, 2-16

propagation jobs, 3-22

REVOKE_OBJECT_PRIVILEGE procedure, 5-15

REVOKE_SYSTEM_PRIVILEGE procedure, 5-15

row migration, 4-12

rule sets, 5-2

adding rules to, 15-5

creating, 15-2

dropping, 15-8

evaluation, 5-12

partial, 5-14

object privileges

granting, 15-9

revoking, 15-10

removing rules from, 15-7

system privileges

granting, 15-9

revoking, 15-10

rule-based transformations, 6-25

rules, 5-1

action contexts, 5-9

adding name-value pairs, 15-16, 15-20

removing name-value pairs, 15-20, 15-21

transformations, 6-25

ADD_RULE procedure, 5-8

altering, 15-5

apply process, 4-2, 6-2

capture process, 2-5, 6-2

components, 5-2

creating, 15-3

DBMS_RULE package, 5-12

dropping, 15-7

EVALUATE procedure, 5-12

evaluation, 5-12

capture process, 2-27

partial, 5-14

evaluation contexts, 5-5

creating, 19-19, 24-5, 24-12, 24-21, 24-31

evaluation function, 5-8

user-created, 6-24

variables, 5-6

event context, 5-12

example applications, 24-1

explicit variables, 5-6

example, 24-3, 24-18

implicit variables, 5-6

example, 24-27

managing, 15-2

maybe_rules, 5-12

monitoring, 17-42

object privileges

granting, 15-9

revoking, 15-10

partial evaluation, 5-14

privileges, 5-15

managing, 15-8

propagations, 3-5, 6-2

rule conditions, 5-2, 6-6

complex, 6-20

explicit variables, 5-6

finding patterns in, 17-49

implicit variables, 5-6

types of operations, 6-22

undefined variables, 6-22

using NOT, 6-20

variables, 6-7

rule_hits, 5-12

simple rules, 5-3

subset

querying for action context of, 15-15

querying for names of, 15-15

system privileges

granting, 15-9

revoking, 15-10

system-created, 6-1, 6-3

action context, 6-18

DDL rules, 6-9

DML rules, 6-7

evaluation context, 6-5, 6-15

event context, 6-18

global, 6-14

modifying, 15-6

schema, 6-12

STREAMS$EVALUATION_CONTEXT, 6-5, 6-15

subset rules, 4-12, 6-5, 6-6

table, 6-6

tags, 6-8, 8-3

table data

example, 24-9, 24-18, 24-27

troubleshooting, 18-17

user-created, 6-19

variables, 5-6

SCHEDULE_PROPAGATION procedure, 13-11

secure queues, 3-22

disabling user access, 13-5

enabling user access, 13-3

propagation, 18-8

SESSIONS initialization parameter, 11-7

SET_COMMAND_TYPE member procedure, 20-16

SET_DML_HANDLER procedure, 4-6, 7-15

removing a DML handler, 14-18

removing an error handler, 14-27

setting a DML handler, 14-16

setting an error handler, 14-26

SET_GLOBAL_INSTANTIATION_SCN procedure, 11-15, 14-35, 14-38

SET_KEY_COLUMNS procedure, 4-11

removing substitute key columns, 14-29

setting substitute key columns, 14-28

SET_OBJECT_NAME member procedure, 20-16, 22-34

SET_PARAMETER procedure

apply process, 14-11, 18-12

capture process, 12-8

SET_SCHEMA_INSTANTIATION_SCN procedure, 11-15, 14-35, 14-38

SET_TABLE_INSTANTIATION_SCN procedure, 11-15, 14-35

SET_TAG procedure, 8-2, 16-26

SET_TRIGGER_FIRING_PROPERTY procedure, 4-25

SET_UP_QUEUE procedure, 13-2

SET_UPDATE_CONFLICT_HANDLER procedure, 7-8

modifying an update conflict handler, 14-31

removing an update conflict handler, 14-32

setting an update conflict handler, 14-30

SET_VALUE member procedure

LCRs, 15-12

SET_VALUES member procedure, 14-24, 20-16

SGA_MAX_SIZE initialization parameter, 11-7

SHARED_POOL_SIZE initialization parameter, 11-8

SOAP

Streams queues, 3-16

source queue, 3-2

SQL*Loader

capture processes, 2-10

staging, 3-1

architecture, 3-19

events, 3-3

heterogeneous environments, 9-3

management, 13-1

queue buffers, 3-19

secure queues, 3-22

disabling user access, 13-5

enabling user access, 13-3

start SCN, 2-15, 2-16

START_APPLY procedure, 14-7

START_CAPTURE procedure, 12-5

STOP_APPLY procedure, 14-7

STOP_CAPTURE procedure, 12-14

Streams. See Oracle Streams

Streams tool, 1-23

STREAMS$_EVALUATION_CONTEXT, 6-5, 6-15

STREAMS$_TRANSFORM_FUNCTION, 6-26

STREAMS_CONFIGURATION parameter

for Import utility, 11-10

STREAMS_INSTANTIATION parameter

for Import utility, 11-10, 21-15, 22-28, 23-49

supplemental logging

capture process, 2-11

column lists, 7-12

DBA_LOG_GROUPS view, 17-11

example, 20-12, 21-12, 22-23, 23-26

instantiation, 2-15

row subsetting, 4-14

specifying, 12-9

SYS.AnyData. See Also AnyData datatype

system change numbers (SCN)

applied SCN for a capture process, 2-16, 17-7

applied SCN for an apply process, 4-28

captured SCN for a capture process, 2-16

oldest SCN for an apply process, 4-28

start SCN for a capture process, 2-15, 2-16

system-generated names

apply process, 4-23

tags, 8-1

ALTER_APPLY procedure, 8-2, 8-6

apply process, 8-6

change cycling

avoidance, 8-8

CREATE_APPLY procedure, 8-2, 8-6

examples, 8-8

getting value for current session, 16-27

managing, 16-26

monitoring, 17-50

apply process value, 17-51

current session value, 17-50

online backups, 8-5

removing value for apply process, 16-28

rules, 6-8, 8-3

include_tagged_lcr parameter, 8-3

SET_TAG procedure, 8-2

setting value for apply process, 16-28

setting value for current session, 16-26

trace files

Oracle Streams, 18-24

transformations

heterogeneous environments

Oracle to non-Oracle, 9-9

Oracle Streams, 6-25

propagations, 13-24, 13-28

rule-based

action context, 6-25

altering, 15-18

apply errors, 6-34

apply process, 6-32

capture process, 6-28

creating, 15-11, 22-34

errors, 6-30, 6-32, 6-34

managing, 15-11

multiple, 6-34

propagations, 6-30

removing, 15-21

STREAMS$_TRANSFORM_FUNCTION, 6-26

troubleshooting, 18-23

triggers

firing property, 4-25

system triggers

on SCHEMA, 4-26

troubleshooting

apply process, 18-9

checking apply handlers, 18-12

checking event type, 18-11

checking status, 18-10

exception queue, 18-13

capture process, 18-2

checking progress, 18-3

checking status, 18-2

log parallelism, 18-3

persistent sessions, 18-4

Oracle Streams, 18-1

propagation jobs, 18-4

checking status, 18-6

job queue processes, 18-7

propagations, 18-4

checking queues, 18-5

security, 18-8

rule-based transformations, 18-23

rules, 18-17

UNRECOVERABLE

capture process, 2-9

UNRECOVERABLE clause

SQL*Loader

capture process, 2-10

UNSCHEDULE_PROPAGATION procedure, 13-13

use_old parameter

in row LCR member functions, 16-8

user-defined datatypes

AnyData queues, 3-17

V$SESSION view, 17-4, 17-28, 17-29, 17-30, 17-33

V$STREAMS_APPLY_COORDINATOR view, 17-30, 17-31

V$STREAMS_APPLY_READER view, 17-28, 17-29

V$STREAMS_APPLY_SERVER view, 17-33, 17-35

V$STREAMS_CAPTURE view, 17-4, 17-7, 17-8, 18-3

XML Schema

for LCRs, A-1