Oracle9i Streams -- Index

ABORT_GLOBAL_INSTANTIATION procedure, 11-13

ABORT_SCHEMA_INSTANTIATION procedure, 11-13

ABORT_TABLE_INSTANTIATION procedure, 11-13

action contexts, 5-7

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

creating

example, 19-35

querying, 14-14

removing name-value pairs, 14-20

system-created rules, 6-3

ADD SUPPLEMENTAL LOG DATA clause, 11-10, 19-23, 19-42

ADD SUPPLEMENTAL LOG GROUP clause, 11-9, 19-106, 19-129, 19-131

ADD_GLOBAL_RULES procedure, 6-14

ADD_PAIR member procedure, 14-16, 14-20, 19-35, 20-13

ADD_RULE procedure, 5-6, 14-4

example, 19-49

ADD_SCHEMA_PROPAGATION_RULES procedure, 6-13

example, 19-25, 19-126, 19-127

ADD_SCHEMA_RULES procedure

example, 19-25, 19-123

ADD_SUBSCRIBER procedure, 12-3, 18-25

ADD_SUBSET_RULES procedure, 4-11, 6-6, 6-7

row migration, 4-11

ADD_TABLE_PROPAGATION_RULES procedure

example, 19-61

ADD_TABLE_RULES procedure, 6-7

example, 19-29

alert log

Oracle Streams entries, 17-24

ALL_STREAMS_GLOBAL_RULES view, 16-42, 16-43

ALL_STREAMS_SCHEMA_RULES view, 16-42, 16-43

ALL_STREAMS_TABLE_RULES view, 16-42, 16-43

ALTER DATABASE statement

ADD SUPPLEMENTAL LOG DATA clause, 11-10, 19-23, 19-42

ALTER TABLE statement

ADD SUPPLEMENTAL LOG GROUP clause, 11-9, 19-106, 19-129, 19-131

ALTER_APPLY procedure

removing the DDL handler, 13-20

removing the message handler, 13-13

removing the rule set, 13-11

removing the tag value, 15-24

setting an apply user, 13-12

setting the DDL handler, 13-20

setting the message handler, 13-13

setting the tag value, 15-24

specifying the rule set, 13-8

tags, 8-2, 8-5

ALTER_CAPTURE procedure

removing the rule set, 11-7

setting the start SCN, 11-10

specifying a rule set, 11-5

ALTER_PROPAGATION procedure

removing the rule set, 12-16

specifying the rule set, 12-13

ALTER_PROPAGATION_SCHEDULE procedure, 12-12

ALTER_RULE procedure, 14-5

example, 19-35

AnyData datatype

message propagation, 3-17

queues, 3-12, 12-18

creating, 12-2, 18-7, 19-11

dequeuing, 12-21

enqueuing, 12-18

monitoring, 16-11

propagating to typed queues, 3-17

user-defined types, 3-18

wrapper for messages, 3-12, 12-18

apply forwarding, 3-9

apply process, 4-1

apply forwarding, 3-9

apply handlers, 4-15

apply servers, 4-27

apply user

setting, 13-12

architecture, 4-26

automatic restart, 4-32

conflict handlers, 4-15

heterogeneous environments, 9-5

conflict resolution, 4-14, 7-1

coordinator process, 4-27

creating, 13-2

example, 19-28, 19-49, 19-123

creation, 4-28

datatypes applied, 4-8

heterogeneous environments, 9-5

DDL changes, 4-19

CREATE TABLE AS SELECT, 4-22

current schema, 4-21

data structures, 4-21

ignored, 4-19

system-generated names, 4-22

DDL handlers, 4-3

creating, 13-18

monitoring, 16-23

removing, 13-20

setting, 13-20

dependent transactions, 17-12

DML changes, 4-9

heterogeneous environments, 9-6

DML handlers, 4-3

creating, 13-14

heterogeneous environments, 9-5

monitoring, 16-22

setting, 13-16

dropping, 13-7

error handlers

creating, 13-21

heterogeneous environments, 9-5

monitoring, 16-22

setting, 13-26

error queue, 4-33

monitoring, 16-35, 16-36

events, 4-3

captured, 4-3

user-enqueued, 4-3

heterogeneous environments, 9-3, 9-10

database links, 9-4

example, 19-37

key columns, 4-9

LOBs, 15-9

logical change records (LCRs), 4-4

managing, 13-1

message handlers, 4-3

creating, 18-17

heterogeneous environments, 9-5

monitoring, 16-23

removing, 13-13

setting, 13-13

monitoring, 16-19

apply handlers, 16-22

latency, 16-28, 16-30

non-LCR events, 4-6

oldest SCN, 4-25

options, 4-3

Oracle Real Application Clusters, 4-25

parallelism, 16-34

parameters, 4-30

commit_serialization, 4-31, 17-12

disable_on_error, 4-32

disable_on_limit, 4-32

heterogeneous environments, 9-4

parallelism, 4-30, 17-12

setting, 13-11

time_limit, 4-32

transaction_limit, 4-32

persistent state, 4-32

reader server, 4-27

row migration, 4-11

row subsetting, 4-11, 6-6

supplemental logging, 4-12

rule set

removing, 13-11

specifying, 13-8

rules, 4-2, 6-2

adding, 13-8

removing, 13-10

starting, 13-7

example, 18-22, 19-31

stopping, 13-7

substitute key columns, 4-10

heterogeneous environments, 9-4

removing, 13-29

setting, 13-27

tables, 4-9

apply handlers, 4-15

column discrepancies, 4-13

tags, 8-5

monitoring, 16-50

removing, 15-24

setting, 15-24

trace files, 17-25

transformations

rule-based, 6-30

triggers

firing property, 4-23

troubleshooting, 17-9

checking apply handlers, 17-12

checking event type, 17-11

checking status, 17-10

error queue, 17-13

AQ_TM_PROCESSES initialization parameter, 10-5

ARCHIVE_LAG_TARGET initialization parameter, 10-5

ARCHIVELOG mode, 10-10, 19-6

capture process, 2-19

capture process, 2-1

architecture, 2-12

ARCHIVELOG mode, 2-19, 10-10, 19-6

automatic restart, 2-20

builder server, 2-13

captured events, 3-3

changes captured, 2-7

DDL changes, 2-8

DML changes, 2-7

creating, 11-2

data dictionary duplication, 2-16

example, 19-25, 19-45

creation, 2-15

data dictionary duplication, 2-16

datatypes captured, 2-6

dropping, 11-14

heterogeneous environments, 9-3

LogMiner, 2-14

alternate tablespace for, 2-14, 2-15, 10-10

multiple sessions, 2-14

LOGMNR_MAX_PERSISTENT_SESSIONS initialization parameter, 2-14

managing, 11-1

monitoring, 16-3

latency, 16-6, 16-8

Oracle Real Application Clusters, 2-11

parameters, 2-19

disable_on_limit, 2-20

message_limit, 2-20

parallelism, 2-20

setting, 11-8

time_limit, 2-20

persistent state, 2-24

preparer servers, 2-13

preparing for, 10-9

reader server, 2-13

redo logs, 2-2

switching files, 11-10

rule evaluation, 2-21

rule set

removing, 11-7

specifying, 11-5

rules, 2-5, 6-2

adding, 11-5

removing, 11-6

start SCN, 2-21

setting, 11-10

starting, 11-5

example, 19-39

stopping, 11-14

supplemental logging, 2-9

specifying, 11-9

SYS schema, 2-6, 2-7

SYSTEM schema, 2-6, 2-7

trace files, 17-25

transformations

rule-based, 6-26

troubleshooting, 17-2

checking progress, 17-3

checking status, 17-2

log parallelism, 17-3

persistent sessions, 17-4

CERATE_EVALUATION_CONTEXT procedure, 20-5

change cycling

avoidance

tags, 8-7

column lists, 7-11

COMPATIBLE initialization parameter, 10-5, 18-4, 19-5

conditions

rules, 5-2

conflict resolution, 7-1

column lists, 7-11

conflict handlers, 7-7

custom, 7-13

interaction with apply handlers, 4-15

modifying, 13-31

prebuilt, 7-7

removing, 13-32

setting, 13-29

data convergence, 7-13

DISCARD handler, 7-9

MAXIMUM handler, 7-9

example, 19-110

latest time, 7-9

MINIMUM handler, 7-10

OVERWRITE handler, 7-9

resolution columns, 7-12

time-based, 7-9

example, 19-110

preparing for, 19-91

conflicts

avoidance, 7-5

delete, 7-6

primary database ownership, 7-5

uniqueness, 7-5

update, 7-6

delete, 7-3

detection, 7-4

identifying rows, 7-5

DML conflicts, 7-2

transaction ordering, 7-3

types of, 7-2

uniqueness, 7-3

update, 7-3

CONVERT_ANYDATA_TO_LCR_DDL function, 12-26

CONVERT_ANYDATA_TO_LCR_ROW function, 12-26

CREATE TABLE statement

AS SELECT

apply process, 4-22

CREATE_APPLY procedure, 4-28, 13-2

example, 19-49

tags, 8-2, 8-5

CREATE_CAPTURE procedure, 2-15, 11-4

example, 11-2

CREATE_EVALUATION_CONTEXT procedure, 20-12, 20-21, 20-31

CREATE_PROPAGATION procedure, 12-8

example, 19-52

CREATE_RULE procedure, 14-3

example, 19-49

CREATE_RULE_SET procedure, 14-2

example, 19-49

database links

creating, 19-7, 19-85

Oracle Streams, 10-11

datatypes

applied, 4-8

captured, 2-6

heterogeneous environments, 9-5

DBA_APPLY view, 16-20, 16-23, 16-27, 16-32, 16-50, 17-10, 17-11

DBA_APPLY_CONFLICT_COLUMNS view, 16-25

DBA_APPLY_DML_HANDLERS view, 16-22

DBA_APPLY_ERROR view, 16-35, 16-36, 16-39, 16-40

DBA_APPLY_INSTANTIATED_OBJECTS view, 16-26

DBA_APPLY_KEY_COLUMNS view, 16-24

DBA_APPLY_PARAMETERS view, 16-21

DBA_APPLY_PROGRESS view, 16-30

DBA_CAPTURE view, 16-3, 17-2

DBA_CAPTURE_PARAMETERS view, 16-5

DBA_CAPTURE_PREPARED_DATABASE view, 16-9

DBA_CAPTURE_PREPARED_SCHEMAS view, 16-9

DBA_CAPTURE_PREPARED_TABLES view, 16-9

DBA_EVALUATION_CONTEXT_TABLES view, 16-44

DBA_EVALUATION_CONTEXT_VARS view, 16-45

DBA_LOG_GROUPS view, 16-10

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

DBA_QUEUE_SCHEDULES view, 16-16, 16-18, 17-6

DBA_QUEUE_TABLES view, 16-11

DBA_QUEUES view, 16-11

DBA_RULE_SET_RULES view, 16-46, 16-47, 16-48

DBA_RULE_SETS view, 16-44

DBA_RULES view, 16-46, 16-47, 16-48

DBA_STREAMS_GLOBAL_RULES view, 16-42, 16-43, 17-19

DBA_STREAMS_SCHEMA_RULES view, 16-42, 16-43, 17-19, 17-21

DBA_STREAMS_TABLE_RULES view, 16-42, 16-43, 17-18, 17-19

DBMS_APPLY_ADM package, 13-1, 19-40

DBMS_CAPTURE_ADM package, 11-1, 19-40

DBMS_PROPAGATION_ADM package, 12-1, 19-40

DBMS_RULE package, 5-9, 20-1

DBMS_RULE_ADM package, 14-2, 19-40, 20-1

DBMS_STREAMS package, 15-22

DBMS_STREAMS_ADM package, 6-4, 11-1, 12-1, 13-1

apply process creation, 4-28

capture process creation, 2-15

creating a capture process, 11-2

creating a propagation job, 12-8

creating an apply process, 13-2

example, 19-21

tags, 8-3

DBMS_TRANSFORM package, 12-24, 12-27

DDL handlers, 4-3

creating, 13-18

monitoring, 16-23

removing, 13-20

setting, 13-20

DELETE_ALL_ERRORS procedure, 13-34

DELETE_ERROR procedure, 13-34

DEQUEUE procedure, 12-21, 18-25

destination queue, 3-2

directed networks, 3-8

apply forwarding, 3-9

example, 19-2

queue forwarding, 3-9

DISABLE_DB_ACCESS procedure, 12-5

DISABLE_PROPAGATION_SCHEDULE procedure, 12-16

DISCARD conflict resolution handler, 7-9

DML handlers, 4-3, 4-15

creating, 13-14

monitoring, 16-22

removing, 13-17

setting, 13-16

DROP_APPLY procedure, 13-7

DROP_CAPTURE procedure, 11-14

DROP_PROPAGATION procedure, 12-17

DROP_RULE procedure, 14-7

DROP_RULE_SET procedure, 14-7

ENABLE_DB_ACCESS procedure, 12-3

ENABLE_PROPAGATION_SCHEDULE procedure, 12-11

ENQUEUE procedure, 12-19, 15-4, 18-12

error handlers, 4-15

creating, 13-21

monitoring, 16-22

removing, 13-27

setting, 13-26

error queue, 4-33

apply process, 17-13

deleting errors, 13-34

executing errors, 13-33

heterogeneous environments, 9-8

monitoring, 16-35, 16-36

EVALUATE procedure, 5-9

evaluation contexts, 5-3

association with rule sets, 5-6

association with rules, 5-6

creating, 18-18

evaluation function, 5-6

object privileges

granting, 14-9

revoking, 14-10

system privileges

granting, 14-8

revoking, 14-9

user-created, 6-18, 6-22

variables, 5-4

events

apply process, 4-3

captured, 3-3

propagating, 12-26

dequeue, 3-3

programmatic environments, 3-13

enqueue, 3-3

programmatic environments, 3-13

propagation, 3-4

user-enqueued, 3-3

propagating, 12-23

EXECUTE member procedure, 13-15, 13-19, 13-24

EXECUTE_ALL_ERRORS procedure, 13-33

EXECUTE_ERROR procedure, 13-33

Export

OBJECT_CONSISTENT parameter, 10-8, 19-27, 19-127

Oracle Streams, 10-8, 13-36

GET_BASE_TABLE_NAME member function, 13-19

GET_BASE_TABLE_OWNER member function, 13-19

GET_COMMAND_TYPE member function, 13-19, 13-24, 16-37

GET_CURRENT_SCHEMA member function, 13-19

GET_DDL_TEXT member function, 16-37

GET_ERROR_MESSAGE function, 16-39, 16-40

GET_INFORMATION function, 13-24

GET_LOGON_USER member function, 13-19

GET_OBJECT_NAME member function, 13-15, 13-19, 13-24, 14-12, 16-37

GET_OBJECT_OWNER member function, 13-15, 13-19, 14-12, 16-37

GET_SCN member function, 13-15, 13-19

GET_SOURCE_DATABASE_NAME member function, 13-19, 16-37

GET_TAG member function, 13-15, 13-19

GET_TAG procedure, 15-23, 16-49

GET_TRANSACTION_ID member function, 13-15, 13-19

GET_VALUES member function, 13-15, 13-24, 16-37

GLOBAL_NAMES initialization parameter, 10-5, 18-4, 19-5

GLOBAL_NAMES view, 17-5

GRANT_OBJECT_PRIVILEGE procedure, 5-11

example, 18-6, 19-9

GRANT_SYSTEM_PRIVILEGE procedure, 5-11

example, 18-6, 19-9

heterogeneous information sharing, 9-1

non-Oracle to non-Oracle, 9-11

non-Oracle to Oracle, 9-9

apply process, 9-10

capturing changes, 9-10

instantiation, 9-11

user application, 9-10

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-5

DML changes, 9-6

DML handlers, 9-5

error handlers, 9-5

error handling, 9-8

example, 19-2

instantiation, 9-7

message handlers, 9-5

parallelism, 9-4

staging, 9-3

substitute key columns, 9-4

transformations, 9-7

Import

Oracle Streams, 10-8, 13-36

STREAMS_CONFIGURATION parameter, 10-9

STREAMS_INSTANTIATION parameter, 10-9, 19-28, 19-128

initialization parameters

AQ_TM_PROCESSES, 10-5

ARCHIVE_LAG_TARGET, 10-5

COMPATIBLE, 10-5

GLOBAL_NAMES, 10-5

JOB_QUEUE_PROCESSES, 10-6

LOG_PARALLELISM, 10-6

LOGMNR_MAX_PERSISTENT_SESSIONS,

10-6

OPEN_LINKS, 10-6

Oracle Streams, 10-4

PARALLEL_MAX_SERVERS, 10-7

PROCESSES, 10-7

SGA_MAX_SIZE, 10-7

SHARED_POOL_SIZE, 10-7

instantiation

aborting preparation, 11-13

example, 19-27, 19-47, 19-127

heterogeneous environments

non-Oracle to Oracle, 9-11

Oracle to non-Oracle, 9-7

Oracle Streams, 10-8, 13-36

preparing for, 10-12, 11-11

setting an SCN, 10-12, 13-35

DDL LCRs, 13-38

export/import, 13-36

IS_NULL_TAG member function, 6-8, 16-37

IS_TRIGGER_FIRE_ONCE function, 4-23

JMS

Oracle Streams, 18-35

JOB_QUEUE_PROCESSES initialization parameter, 10-6, 18-4, 19-5

propagation, 17-7

LCRs. See logical change records

LOBs

Oracle Streams, 15-8

apply process, 15-9

constructing, 15-10

requirements, 15-8

LOG_PARALLELISM initialization parameter, 10-6

capture process, 17-3

logical change records (LCRs), 2-2

apply process, 4-4

constructing, 15-2, 18-13

DDL LCRs, 2-4

current_schema, 4-21

rules, 6-9

DELETE_ERROR procedure, 4-33

determining if tag is NULL, 6-8

enqueuing, 15-2

EXECUTE_ERROR procedure, 4-33

getting constraint, 13-24

getting information about, 13-15, 13-19, 14-12, 16-37

getting sender, 13-24

row LCRs, 2-3

getting list of column values, 13-24

rules, 6-8

setting list of column values, 13-24

XML schema, A-1

LogMiner

alternate tablespace for, 2-14, 2-15, 10-10

capture process, 2-14

multiple sessions, 2-14

LOGMNR_MAX_PERSISTENT_SESSIONS initialization parameter, 2-14, 10-6

capture process, 17-4

MAXIMUM conflict resolution handler, 7-9

latest time, 7-9

maybe_rules, 6-21

message handlers, 4-3

creating, 18-17

monitoring, 16-23

messages

propagation, 3-17

messaging

Oracle Streams, 18-1

MINIMUM conflict resolution handler, 7-10

monitoring

AnyData datatype queues, 16-11

event consumers, 16-12

viewing event contents, 16-13

apply process, 16-19

apply handlers, 16-22

DML handlers, 16-22

error handlers, 16-22

error queue, 16-35, 16-36

capture process, 16-3

latency, 16-6, 16-8

DDL handlers, 16-23

message handlers, 16-23

Oracle Streams, 16-1

propagation jobs, 16-15

rule-based transformations

procedures, 16-48

rules, 16-41

tags, 16-49

apply process value, 16-50

current session value, 16-49

OBJECT_CONSISTENT parameter

for Export utility, 10-8, 19-27, 19-127

oldest SCN, 4-25

OPEN_LINKS initialization parameter, 10-6

ORA-01403 error, 17-14

ORA-24093 error, 17-8

ORA-25224 error, 17-9

ORA-26687 error, 17-15

ORA-26688 error, 17-15

ORA-26689 error, 17-16

Oracle Enterprise Manager

Streams tool, 1-23

Oracle Real Application Clusters

interoperation with Oracle Streams, 2-11, 3-19, 4-25

Oracle Streams

adding databases, 10-19, 10-34, 19-69

adding objects, 10-16, 10-28, 19-59

administrator

creating, 10-2, 18-6, 19-9

alert log, 17-24

AnyData queues, 12-18

apply process, 4-1

capture process, 2-1

configuring, 10-12

example, 19-7, 19-85

conflict resolution, 7-1

data dictionary, 2-16, 3-24, 4-29

data dictionary views, 16-1

database links, 10-11

directed networks, 3-8

example, 19-2

example environments

messaging, 18-1

replication, 19-1

Export utility, 10-8, 13-36

heterogeneous information sharing, 9-1

example, 19-2

Import utility, 10-8, 13-36

initialization parameters, 10-4, 18-4, 19-5

instantiation, 10-8, 13-36

JMS, 3-13, 18-35

LOBs, 15-8

logical change records (LCRs), 2-2

XML schema, A-1

messaging, 12-18

monitoring, 16-1

multiple source databases, 19-82

network connectivity, 10-11

OCI, 3-13

overview, 1-2

packages, 1-21

point-in-time recovery, 13-41

preparing for, 10-1

privileges, 19-7, 19-85

propagation, 3-1

Oracle Real Application Clusters, 3-19

rules, 6-1

action context, 6-3

evaluation context, 6-3, 6-6, 6-16

subset rules, 4-11, 6-6

system-created, 6-4

single source database, 19-2

staging, 3-1

Oracle Real Application Clusters, 3-19

Streams tool, 1-23

supplemental logging, 2-9

tags, 8-1

trace files, 17-24

transformations

rule-based, 6-23

troubleshooting, 17-1

OVERWRITE conflict resolution handler, 7-9

PARALLEL_MAX_SERVERS initialization parameter, 10-7

point-in-time recovery

Oracle Streams, 13-41

PREPARE_GLOBAL_INSTANTIATION procedure, 10-12, 11-11

PREPARE_SCHEMA_INSTANTIATION procedure, 10-12, 11-11

PREPARE_TABLE_INSTANTIATION procedure, 10-12, 11-11

example, 19-47

privileges, 18-6, 19-9

Oracle Streams administrator, 10-2

rules, 5-11

PROCESSES initialization parameter, 10-7

propagation jobs, 3-1, 3-4

altering, 12-12

architecture, 3-20

creating, 12-8

example, 19-52

database links

creating, 19-12, 19-15

destination queue, 3-2

directed networks, 3-8

example, 19-2

disabling, 12-16

dropping, 12-17

enabling, 12-11

ensured delivery, 3-7

managing, 12-7

monitoring, 16-15

queue buffers, 3-20

rule sets

removing, 12-16

specifying, 12-13

rules, 3-5, 6-2

adding, 12-14

removing, 12-15

scheduling, 3-6, 12-11

source queue, 3-2

trace files, 17-25

transformations

rule-based, 6-28

SYS.AnyData to typed queue, 12-23, 12-26

troubleshooting, 17-4

checking queues, 17-5

checking status, 17-6

job queue processes, 17-7

security, 17-8

unscheduling, 12-13

queue buffers, 3-20

queue forwarding, 3-9

queues

AnyData, 3-12, 12-18

creating, 12-2, 18-7, 19-7, 19-11, 19-85

dequeuing, 18-25

enqueuing, 18-12

user-defined types, 3-18

nontransactional, 3-23

propagation, 3-17

secure, 3-21

disabling user access, 12-5

enabling user access, 12-3

transactional, 3-23

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

RE$NV_ARRAY type, 19-35

RE$NV_LIST type, 5-9, 19-35, 20-6, 20-13, 20-14, 20-24, 20-34

ADD_PAIR member procedure, 14-16, 14-20

REMOVE_PAIR member procedure, 14-20, 14-21

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

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

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

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

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

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

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

redo logs

capture process, 2-2

switching files, 11-10

REMOVE_PAIR member procedure, 14-20, 14-21

REMOVE_RULE procedure, 11-6, 12-15, 13-10, 14-6

replication

Oracle Streams, 19-1

adding databases, 19-69

adding objects, 19-59

multiple source databases, 19-82

single source database, 19-2

resolution columns, 7-12

REVOKE_OBJECT_PRIVILEGE procedure, 5-11

REVOKE_SYSTEM_PRIVILEGE procedure, 5-11

row migration, 4-11

rule sets, 5-2

adding rules to, 14-4

creating, 14-2

dropping, 14-7

evaluation, 5-9

example, 19-49

object privileges

granting, 14-9

revoking, 14-10

removing rules from, 14-6

system privileges

granting, 14-8

revoking, 14-9

rule-based transformations, 6-23

rules, 5-1

action contexts, 5-7

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

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

transformations, 6-23

ADD_RULE procedure, 5-6

altering, 14-5

apply process, 4-2, 6-2

capture process, 2-5, 6-2

components, 5-2

creating, 14-3

example, 19-49

DBMS_RULE package, 5-9

dropping, 14-7

EVALUATE procedure, 5-9

evaluation, 5-9

capture process, 2-21

evaluation contexts, 5-3

creating, 18-18, 20-5, 20-12, 20-21, 20-31

evaluation function, 5-6

user-created, 6-22

variables, 5-4

event context, 5-9

example applications, 20-1

explicit variables

example, 20-3, 20-18

implicit variables

example, 20-27

managing, 14-2

maybe_rules, 5-9, 6-21

monitoring, 16-41

object privileges

granting, 14-9

revoking, 14-10

privileges, 5-11

managing, 14-8

propagation jobs, 3-5, 6-2

rule conditions, 5-2, 6-7

complex, 6-18

explicit variables, 5-4

implicit variables, 5-4

types of operations, 6-20

using NOT, 6-19

variables, 6-8

rule_hits, 5-9

subset

querying for action context of, 14-14

querying for names of, 14-14

system privileges

granting, 14-8

revoking, 14-9

system-created, 6-1, 6-4

action context, 6-3

DDL rules, 6-9

DML rules, 6-8

evaluation context, 6-3, 6-6, 6-16

global, 6-14

modifying, 14-6

schema, 6-13

STREAMS$EVALUATION_CONTEXT, 6-3, 6-6, 6-16

subset rules, 4-11, 6-6, 6-7

table, 6-7

tags, 6-8, 8-3

table data

example, 20-9, 20-18, 20-27

troubleshooting, 17-17

user-created, 6-18

variables, 5-4

SCHEDULE_PROPAGATION procedure, 12-11

secure queues, 3-21

disabling user access, 12-5

enabling user access, 12-3

propagation, 17-8

SET_DML_HANDLER procedure, 4-6, 7-13

removing a DML handler, 13-17

removing an error handler, 13-27

setting a DML handler, 13-16

setting an error handler, 13-26

SET_GLOBAL_INSTANTIATION_SCN procedure, 10-12, 13-35, 13-38

SET_KEY_COLUMNS procedure, 4-10

removing substitute key columns, 13-29

setting substitute key columns, 13-27

SET_PARAMETER procedure, 11-8, 13-11

apply process, 17-12

SET_SCHEMA_INSTANTIATION_SCN procedure, 10-12, 13-35, 13-38

SET_TABLE_INSTANTIATION_SCN procedure, 10-12, 13-35

SET_TAG procedure, 8-2, 15-22

SET_TRIGGER_FIRING_PROPERTY procedure, 4-23

SET_UP_QUEUE procedure, 18-7, 19-11

SET_UPDATE_CONFLICT_HANDLER procedure, 7-7

modifying an update conflict handler, 13-31

removing an update conflict handler, 13-32

setting an update conflict handler, 13-29

SET_VALUE member procedure, 14-12

SET_VALUES member procedure, 13-24

SGA_MAX_SIZE initialization parameter, 10-7

SHARED_POOL_SIZE initialization parameter, 10-7

source queue, 3-2

staging, 3-1

architecture, 3-20

events, 3-3

heterogeneous environments, 9-3

management, 12-1

queue buffers, 3-20

secure queues, 3-21

disabling user access, 12-5

enabling user access, 12-3

start SCN, 2-21

START_APPLY procedure, 13-7

example, 18-22, 19-31

START_CAPTURE procedure, 11-5

STOP_APPLY procedure, 13-7

STOP_CAPTURE procedure, 11-14

Streams. See Oracle Streams

Streams tool, 1-23

STREAMS$_EVALUATION_CONTEXT, 6-3, 6-6, 6-16

STREAMS$_TRANSFORM_FUNCTION, 6-23

STREAMS_CONFIGURATION parameter

for Import utility, 10-9

STREAMS_INSTANTIATION parameter

for Import utility, 10-9, 19-28, 19-128

supplemental logging

capture process, 2-9

DBA_LOG_GROUPS view, 16-10

example, 19-22, 19-42, 19-94, 19-98, 19-131

row subsetting, 4-12

specifying, 11-9

SYS.AnyData. See Also AnyData datatype

system change numbers (SCN)

oldest for an apply process, 4-25

start SCN for a capture process, 2-21

system-generated names

apply process, 4-22

tags, 8-1

ALTER_APPLY procedure, 8-2, 8-5

apply process, 8-5

change cycling

avoidance, 8-7

CREATE_APPLY procedure, 8-2, 8-5

examples, 8-7

getting value for current session, 15-23

managing, 15-22

monitoring, 16-49

apply process value, 16-50

current session value, 16-49

removing value for apply process, 15-24

rules, 6-8, 8-3

include_tagged_lcr parameter, 8-3

SET_TAG procedure, 8-2

setting value for apply process, 15-24

setting value for current session, 15-22

trace files

Oracle Streams, 17-24

transformations

heterogeneous environments

Oracle to non-Oracle, 9-7

Oracle Streams, 6-23

propagation jobs, 12-23, 12-26

rule-based

action context, 6-23

altering, 14-18

apply errors, 6-32

apply process, 6-30

capture process, 6-26

creating, 14-11, 19-33, 19-54

errors, 6-28, 6-30, 6-32

managing, 14-10

multiple, 6-32

propagation jobs, 6-28

removing, 14-21

STREAMS$_TRANSFORM_FUNCTION,

6-23

troubleshooting, 17-23

triggers

firing property, 4-23

troubleshooting

apply process, 17-9

checking apply handlers, 17-12

checking event type, 17-11

checking status, 17-10

error queue, 17-13

capture process, 17-2

checking progress, 17-3

checking status, 17-2

log parallelism, 17-3

persistent sessions, 17-4

Oracle Streams, 17-1

propagation jobs, 17-4

checking queues, 17-5

checking status, 17-6

job queue processes, 17-7

security, 17-8

rule-based transformations, 17-23

rules, 17-17

UNSCHEDULE_PROPAGATION procedure, 12-13

user-defined datatypes

AnyData queues, 3-18

V$SESSION view, 16-4, 16-27, 16-28, 16-29, 16-32

V$STREAMS_APPLY_COORDINATOR view, 16-29, 16-30

V$STREAMS_APPLY_READER view, 16-27, 16-28

V$STREAMS_APPLY_SERVER view, 16-32, 16-34

V$STREAMS_CAPTURE view, 16-4, 16-6, 16-8, 17-3

XML Schema

for LCRs, A-1