Index
A C D E G H I J L M O P Q R S T U V X
A
- 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
C
- 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
D
- 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
E
- 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
G
- 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
H
- 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
I
- 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
J
- JMS
- Oracle Streams, 18-35
- JOB_QUEUE_PROCESSES initialization parameter, 10-6, 18-4, 19-5
- propagation, 17-7
L
- 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
M
- 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
O
- 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
P
- 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
Q
- 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
R
- 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
S
- 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
T
- 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
U
- UNSCHEDULE_PROPAGATION procedure, 12-13
- user-defined datatypes
- AnyData queues, 3-18
V
- 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
X
- XML Schema
- for LCRs, A-1