Index

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

A

action contexts, 11.1.3
name-value pairs
adding, 18.2.2.3, 19.2.1, 19.2.2
altering, 18.2.2.2
removing, 18.2.2.4, 19.2.2
querying, 19.2.1
system-created rules, 11.6
ADD_COLUMN procedure, 6.1, 19.1.1.2
ADD_GLOBAL_RULES procedure, 5.3.1
ADD_PAIR member procedure, 18.2.2.2, 18.2.2.3, 19.2.1, 19.2.2
ADD_RULE procedure, 11.1.2.2, 18.1.2
ADD_SCHEMA_PROPAGATION_RULES procedure, 5.3.2
ADD_SUBSCRIBER procedure, 16.1.1
ADD_SUBSET_PROPAGATION_RULES procedure
row migration, 5.3.4.2
ADD_SUBSET_RULES procedure, 5.3, 5.3.4
row migration, 5.3.4.2
ADD_TABLE_RULES procedure, 5.3.3
alert log
Oracle Streams entries, 30.4
alerts, 30.1
ALTER_APPLY procedure
removing a rule set, 17.3.4
removing the DDL handler, 17.7.3
setting an apply user, 17.5
setting the DDL handler, 17.7.2
setting the message handler, 17.8.1
setting the precommit handler, 17.9.2
specifying a rule set, 17.3.1
unsetting the message handler, 17.8.2
unsetting the precommit handler, 17.9.3
ALTER_CAPTURE procedure
removing a rule set, 15.1.3.4
setting a capture user, 15.1.5
setting the first SCN, 15.1.8, 15.1.9
specifying a rule set, 15.1.3.1, 15.2.1.1
specifying database link use, 15.1.10
ALTER_PROPAGATION procedure
removing the rule set, 16.2.7
specifying the rule set, 16.2.4
ALTER_PROPAGATION_SCHEDULE procedure, 16.2.3
ALTER_RULE procedure, 18.2.2
ALTER_SYNC_CAPTURE procedure
setting a capture user, 15.2.2
ANALYZE_CURRENT_PERFORMANCE procedure, 23.5
ANALYZE_CURRENT_STATISTICS procedure, 23.2
ANYDATA data type
queues, 3.2.1
monitoring, 25.1
removing, 16.1.3
wrapper for messages, 3.2.1
applications
upgrading
using Streams, D.3
applied SCN, 2.5.7.1, 10.7, 24.1.12
apply forwarding, 3.3.4.1
apply process, 4, 10
applied SCN, 10.7
apply forwarding, 3.3.4.1
apply handlers, 4.2.4, 10.3.5
Java stored procedures, 4.2.4.6
apply servers, 4.2.10
states, 4.2.10.3
troubleshooting, 33.10
apply user, 4.2.1
privileges, 33.7
secure queues, 8.1.2
setting, 17.5
architecture, 4.2.10
combined capture and apply, 12.1
query to determine, 26.16
conflict handlers, 10.3.5
conflict resolution, 10.3.4
constraints, 10.3.1
contention, 33.8, 33.9
coordinator process, 4.2.10
states, 4.2.10.2
creating, 10.1
data type conversion, 4.2.7
data types, B.5.1
data types applied, 4.2.6
automatic conversion, 4.2.7
DDL changes, 10.4
containing DML changes, 10.4.3
CREATE TABLE AS SELECT, 10.4.2
current schema, B.5.5
data structures, B.5.4
derived values in DML, 10.4.3.1
DML triggers, 10.4.3.2
ignored, B.5.3
system-generated names, 10.4.1
DDL handlers, 4.2.4, 4.2.4.3
managing, 17.7
monitoring, 26.4.2
dependencies, 10.2
barrier transactions, 10.2.6
troubleshooting, 33.9
virtual dependency definitions, 10.2.5, 17.15, 26.18
DML changes, 10.3
DML handlers, 4.2.4, 4.2.4.1, 26.4.1
change handlers, 20
dropping, 17.16
enqueuing messages, 17.10
monitoring, 26.14
error handlers
managing, 17.12
monitoring, 26.4.3
error queue, 4.2.14
monitoring, 26.19, 26.20
high-watermark, 10.7
ignore SCN, 10.5
index-organized tables, B.5.1
instantiation SCN, 10.5
interoperation with capture processes, B.1.6, B.5.7
key columns, 10.3.1
low-watermark, 10.7
managing, 17
message handlers, 4.2.4, 4.2.4.4
managing, 17.8
monitoring, 26.4.4
messages
captured LCRs, 4.2.3
persistent LCRs, 4.2.3
user messages, 4.2.3
monitoring, 26
apply handlers, 26.4
compatible columns, 29.3.3.1
latency, 26.8, 26.11, 26.11
transactions, 26.10
non-LCR messages, 4.2.4.4
oldest SCN, 10.6
options, 4.2.4
Oracle Label Security (OLS), B.5.6
Oracle Real Application Clusters, A.1.6
parallelism, 26.13
parameters, 4.2.12
commit_serialization, 33.9
parallelism, 33.9
preserve_encryption, A.2.6
setting, 17.4
txn_lcr_spill_threshold, 26.7
performance, 33.10
persistent status, 4.2.13
precommit handlers, 4.2.4.5
managing, 17.9
monitoring, 26.4.5
reader server, 4.2.10
states, 4.2.10.1
RESTRICTED SESSION, 4.2.9
row subsetting, 5.3
rule sets
removing, 17.3.4
specifying, 17.3.1
rules, 4.2.2, 5.1
adding, 17.3.2
removing, 17.3.3
session information, 26.5
specifying execution, 17.11
monitoring, 26.15
spilled messages, 26.7
SQL generation, 4.2.8
starting, 17.1
stopping, 17.2
substitute key columns, 10.3.2
removing, 17.14.2
setting, 17.14.1
tables, 10.3
apply handlers, 10.3.5
column discrepancies, 10.3.3
trace files, 30.4.3
transformations
rule-based, 6.3.4
Transparent Data Encryption, A.2.6
triggers
firing property, 10.8.1
ON SCHEMA clause, 10.8.2
troubleshooting, 33
checking apply handlers, 33.5
checking message type, 33.3
checking status, 33.1
error queue, 33.11
approximate CSCN, 8.3.2
AQ_TM_PROCESSES initialization parameter
Streams apply process, 33.6
ARCHIVELOG mode
capture process, 7.4
Recovery Manager, A.4.2
ATTACH_TABLESPACES procedure, 36.1

B

buffered messaging, 3.2.2.1
buffered queues, 3.2.2
monitoring, 25.2
apply processes, 25.2.8
capture processes, 25.2.2
propagations, 25.2.3, 25.2.4, 25.2.5, 25.2.6, 25.2.7
Transparent Data Encryption, A.2.4
BUILD procedure, 2.5.7.2, 7.5.1
troubleshooting, 31.1.1

C

capture
explicit, 2.7
capture process, 2, 2.5, 2.6, 7
applied SCN, 2.5.7.1, 24.1.12
architecture, 2.5.9
ARCHIVELOG mode, 7.4
automatically filtered changes, 29.3.1.1
builder server, 2.5.9
capture user, 2.5.10
secure queues, 8.1.2
setting, 15.1.5
captured LCRs, 4.1.1
captured SCN, 2.5.7.1
changes captured
DDL changes, B.1.2.3
DML changes, 2.5.4
NOLOGGING keyword, B.1.2.5
UNRECOVERABLE clause for SQL*Loader, B.1.2.6
UNRECOVERABLE SQL keyword, B.1.2.5
checkpoints, 7.2
managing retention time, 15.1.6
maximum checkpoint SCN, 7.2.2
required checkpoint SCN, 7.2.1, 7.4
retention time, 7.2.3
combined capture and apply, 12.1
query to determine, 24.1.16
creating, 7.5
data type restrictions, B.1.2.1
data types captured, 2.5.3
DBID, 7.5
downstream capture, 2.5.6
advantages, 2.5.6.2.4
database link, 2.5.6.2.5, 15.1.10
monitoring, 24.1.6
monitoring remote access, 29.1.2
operational requirements, 2.5.6.2.6
dropping, 15.1.11
fast recovery area, A.4.2
first SCN, 2.5.7.2
setting, 15.1.8, 15.1.9
global name, 7.5
index-organized tables, B.1.2.1, B.1.2.2
interoperation with apply processes, B.1.6, B.5.7
latency
capture to apply, 26.11
redo log scanning, 24.1.13
local capture, 2.5.6
advantages, 2.5.6.1.2
LogMiner, 7.1
data dictionary, 7.5.1
multiple sessions, 7.1
managing, 15.1
maximum checkpoint SCN, 7.2.2, 7.5.1.2
monitoring, 24.1
applied SCN, 24.1.12
compatible tables, 29.3.1.1
downstream capture, 24.1.6
elapsed time, 24.1.5
last redo entry, 24.1.10
latency, 24.1.13, 24.1.14, 24.1.14, 26.11
message creation time, 24.1.4
old log files, 24.1.9
registered log files, 24.1.7, 24.1.9
required log files, 24.1.8
rule evaluations, 24.1.15
state change time, 24.1.4
online redefinition, B.1.2.4
Oracle Label Security (OLS), B.1.5
Oracle Real Application Clusters, A.1.1
parameters, 2.5.12
parallelism, 2.5.12
set_autofiltered_table_ddl, 29.3.1.1
setting, 15.1.4
time_limit, 2.5.12
PAUSED FOR FLOW CONTROL state, 2.5.11
persistent status, 2.5.13
preparer servers, 2.5.9
reader server, 2.5.9
Recovery Manager, A.4.2
fast recovery area, 31.1.6
redo logs, 2.5.1
adding manually, 15.1.7
missing files, 31.1.6
redo transport services, 2.5.6
required checkpoint SCN, 7.2.1
RESTRICTED SESSION, 2.5.8
rule evaluation, 7.7
rule sets
removing, 15.1.3.4
specifying, 15.1.3.1
rules, 2.5.2, 5.1
adding, 15.1.3.2
removing, 15.1.3.3
session information, 24.1.2
SGA_MAX_SIZE initialization parameter, 7.1
start SCN, 2.5.7.2, 2.5.7.2.4
starting, 15.1.1
states, 2.5.11
stopping, 15.1.2
supplemental logging, 2.5.5
switching to, 15.5
SYS schema, 2.5.2
SYSTEM schema, 2.5.2
table type restrictions, B.1.2.2
trace files, 30.4.1
transformations
rule-based, 6.3.1
Transparent Data Encryption, A.2.1
troubleshooting, 31, 31.1
checking progress, 31.1.5
checking status, 31.1.2
creation, 31.1.1
capture user
capture process, 2.5.10
synchronous capture, 2.6.6
captured LCRs, 4.1.2.1
captured SCN, 2.5.7.1
change handlers, 4.2.4.1.1, 20
about, 20.1
change tables, 20.1
maintaining, 20.4.3
monitoring, 20.5.1
configuration options, 20.2.1.1
configuring, 20.3
KEEP_COLUMNS transformations, 20.2.1.5
managing, 20.4
monitoring, 20.5
preparing for, 20.2
prerequisites, 20.2.2
replication, 20.2.1.8
setting, 20.4.1
unsetting, 20.4.1
using existing components, 20.4.2
character sets
migrating
using Streams, D.3
checkpoints, 7.2
retention time, 7.2.3
managing, 15.1.6
CLONE_TABLESPACES procedure, 36.1
combined capture and apply, 12.1
apply process
query to determine, 26.16
capture process
query to determine, 24.1.16
propagation
query to determine, 25.3.6, 25.3.7
stream paths, 23.3.1
topology, 23.3.1
COMPATIBLE_10_1 function, 11.7.1.2
COMPATIBLE_10_2 function, 11.7.1.2
COMPATIBLE_11_1 function, 11.7.1.2
COMPATIBLE_11_2 function, 11.7.1.2
COMPATIBLE_9_2 function, 11.7.1.2
conditions
rules, 11.1.1
configuration report script
Oracle Streams, 30.2
conflict resolution
conflict handlers
interaction with apply handlers, 10.3.5
CONTROL_FILE_RECORD_KEEP_TIME parameter, 31.1.6
CREATE TABLE statement
AS SELECT
apply process, 10.4.2
CREATE_APPLY procedure, 10.1
CREATE_CAPTURE procedure, 7.5
CREATE_RULE procedure, 18.2.1
CREATE_RULE_SET procedure, 18.1.1

D

data types
applied, 4.2.6
automatic conversion, 4.2.7
database maintenance
using Streams, D
assumptions, D.1.2
capture database, D.1.1
instantiation, D.2.5
job slaves, D.1.3
logical dependencies, D.2.3.2
PL/SQL package subprograms, D.1.3
user-created applications, D.2.3
user-defined types, D.2.2
DBA_APPLY view, 26.1, 26.2, 26.4.2, 26.4.2, 26.4.4, 26.6, 26.12, 33.1, 33.3
DBA_APPLY_CHANGE_HANDLERS view, 20.4.1, 20.5.2
DBA_APPLY_DML_HANDLERS view, 26.4.1, 26.4.3
DBA_APPLY_ENQUEUE view, 26.14
DBA_APPLY_ERROR view, 26.19, 26.20, 26.20, 26.20
DBA_APPLY_EXECUTE view, 26.15
DBA_APPLY_KEY_COLUMNS view, 26.17
DBA_APPLY_PARAMETERS view, 26.3
DBA_APPLY_PROGRESS view, 26.11
DBA_APPLY_SPILL_TXN view, 26.7
DBA_CAPTURE view, 24.1.1, 24.1.6, 24.1.7, 24.1.8, 24.1.9, 24.1.12, 31.1.2
DBA_CAPTURE_EXTRA_ATTRIBUTES view, 24.3
DBA_CAPTURE_PARAMETERS view, 24.1.11
DBA_EVALUATION_CONTEXT_TABLES view, 27.6
DBA_EVALUATION_CONTEXT_VARS view, 27.7
DBA_FILE_GROUP_EXPORT_INFO view, 37.2.3
DBA_FILE_GROUP_FILES view, 37.1.3
DBA_FILE_GROUP_TABLES view, 37.2.2
DBA_FILE_GROUP_TABLESPACES view, 37.2.1
DBA_FILE_GROUP_VERSOINS view, 37.1.2
DBA_FILE_GROUPS view, 37.1.1
DBA_LOG_GROUPS view, 24.1.18.1
DBA_LOGMNR_PURGED_LOG view, 2.5.7.2.3, 7.4
DBA_PROPAGATION view, 25.2.3, 25.2.4, 25.2.5, 25.2.6, 25.3.1, 25.3.2, 25.3.3, 25.3.4, 25.3.5, 32.1, 32.2
DBA_QUEUE_SCHEDULES view, 25.3.4, 25.3.5
DBA_QUEUE_TABLES view, 25.1.1
DBA_QUEUES view, 25.1.1
DBA_REGISTERED_ARCHIVED_LOG view, 24.1.7, 24.1.8, 24.1.9
DBA_RULE_SET_RULES view, 27.8, 27.9
DBA_RULE_SETS view, 27.5
DBA_RULES view, 27.8, 27.9, 27.10
DBA_STREAMS_ADD_COLUMN view, 28.2.1
DBA_STREAMS_COLUMNS view, 29.3.2, 29.3.3.1
DBA_STREAMS_NEWLY_SUPPORTED view, 29.3.1.2
DBA_STREAMS_RENAME_TABLE view, 28.2.2
DBA_STREAMS_RULES view, 27.3, 34.1
DBA_STREAMS_TABLE_RULES view, 24.2.2
DBA_STREAMS_TP_COMPONENT view, 23.2.1, 23.6.1.2
DBA_STREAMS_TP_COMPONENT_LINK view, 23.2.1, 23.6.1.3
DBA_STREAMS_TP_COMPONENT_STAT view, 23.2.1, 23.6.2.2
DBA_STREAMS_TP_DATABASE view, 23.2.1, 23.6.1.1
DBA_STREAMS_TP_PATH_BOTTLENECK view, 23.2.1, 23.6.2.1
DBA_STREAMS_TP_PATH_STAT view, 23.2.1, 23.6.2.4
DBA_STREAMS_TRANSFORM_FUNCTION view, 28.3
DBA_STREAMS_TRANSFORMATIONS view, 28.1, 28.2
DBA_STREAMS_UNSUPPORTED view, 29.3.1.1
DBA_SYNC_CAPTURE view, 24.2.1
DBA_SYNC_CAPTURE_TABLES view, 24.2.2
DBID (database identifier)
capture process, 7.5
DBMS_APPLY_ADM package, 14.1.1, 17
DBMS_CAPTURE_ADM package, 14.1.2, 15.1
DBMS_COMPARISON package, 14.1.3
DBMS_PROPAGATION_ADM package, 14.1.4, 16
starting a propagation, 16.2.1
stopping a propagation, 16.2.2
DBMS_RULE package, 11.2, 14.1.5
DBMS_RULE_ADM package, 14.1.6, 18, 18.1
DBMS_STREAMS package, 14.1.7
DBMS_STREAMS_ADM package, 5.3, 14.1.8, 15.1, 16, 17
creating a capture process, 7.5
creating an apply process, 10.1
DBMS_STREAMS_ADVISOR_ADM package, 14.1.9, 23.2
gathering information, 23.5
DBMS_STREAMS_AUTH package, 14.1.10
DBMS_STREAMS_HANDLER_ADM package, 14.1.11
DBMS_STREAMS_MESSAGING package, 14.1.12
DBMS_STREAMS_TABLESPACE_ADM package, 14.1.13, 36.1
information provisioning, 35.2.3
platform conversion, 35.2.3.4
DDL handlers, 4.2.4, 4.2.4.3
creating, 17.7.1
managing, 17.7
monitoring, 26.4.2
removing, 17.7.3
setting, 17.7.2
DELETE_ALL_ERRORS procedure, 17.13.2.2
DELETE_COLUMN procedure, 6.1
DELETE_ERROR procedure, 4.2.14, 17.13.2.1
dependencies
apply processes, 10.2
queues, 8.3.1
dequeue high-watermark, 8.3.2
destination queue, 3.1
DETACH_TABLESPACES procedure, 36.1
direct path load
capture processes, B.1.2.6
directed networks, 3.3.4
apply forwarding, 3.3.4.1
queue forwarding, 3.3.4.1
DISABLE_DB_ACCESS procedure, 16.1.2
DML handlers, 4.2.4, 4.2.4.1, 10.3.5
change handlers, 4.2.4.1.1, 20
managing, 17.6
monitoring, 26.4.1, 26.4.1
procedure DML handlers, 4.2.4.1.2
managing, 17.6.2
monitoring, 26.4.1.3
statement DML handlers, 4.2.4.1.1
managing, 17.6.1
monitoring, 26.4.1.2
unsetting, 17.6.2.3
documentation
Oracle Streams, 1.5
DROP_APPLY procedure, 17.16
DROP_CAPTURE procedure, 15.1.11, 15.2.3
DROP_PROPAGATION procedure, 16.2.8
DROP_RULE procedure, 18.2.4
DROP_RULE_SET procedure, 18.1.4

E

ENABLE_DB_ACCESS procedure, 16.1.1
error handlers, 10.3.5
creating, 17.12.1
managing, 17.12
monitoring, 26.4.3
setting, 17.12.2
unsetting, 17.12.3
error queue, 4.2.14
apply process, 33.11
deleting errors, 17.13.2
executing errors, 17.13.1
monitoring, 26.19, 26.20
Transparent Data Encryption, A.2.6
EVALUATE procedure, 11.2
evaluation contexts, 11.1.2
association with rule sets, 11.1.2.2
association with rules, 11.1.2.2
evaluation function, 11.1.2.3
object privileges
granting, 18.3.2
revoking, 18.3.4
system privileges
granting, 18.3.1
revoking, 18.3.3
user-created, 11.7, 11.7.2
variables, 11.1.2.1
event contexts
system-created rules, 11.5
EXECUTE member procedure, 17.7.1, 17.12.1
EXECUTE_ALL_ERRORS procedure, 17.13.1.2
EXECUTE_ERROR procedure, 4.2.14, 17.13.1.1
explicit capture, 1.2.1, 2.7
features, 2.7.2
message types, 2.7.1
Transparent Data Encryption, A.2.3
explicit consumption
dequeue, 4.4
Export
database maintenance, D.2.5
database upgrade, E.2.2
Oracle Streams, 21.1

F

fast recovery area
capture processes, A.4.2
archived redo log files, 31.1.6
file group repositories, 35.2.3.1
monitoring, 37, 37.1
using, 36.2
first SCN, 2.5.7.2
flashback data archive
Oracle Streams, A.3
flow control, 2.5.11

G

GET_BASE_TABLE_NAME member function, 17.7.1
GET_COMMA, 26.20
GET_COMMAND_TY, 17.7.1
GET_COMMAND_TYPE member function, 17.12.1, 17.13.1.1.2
GET_COMPATIBLE member function, 11.7.1.2
GET_DDL_TEXT member function, 26.20
GET_ERROR_MESSAGE function, 26.20, 26.20
GET_INFORMATION function, 17.12.1
GET_NEXT_HIT function, 11.2
GET_OBJECT_NAME member function, 17.12.1, 17.13.1.1.2, 19.2.1, 26.20
GET_OBJECT_OWNER member function, 17.13.1.1.2, 19.2.1, 26.20
GET_SCN member function, 17.7.1
GET_SOURCE_DATABASE_NAME member function, 17.7.1, 26.20
GET_STREAMS_NAME function, 17.12.1
GET_TAG member function, 17.7.1
GET_TRANSACTION_ID member function, 17.7.1
GET_VALUE member function, 17.13.1.1.2
LCRs, 19.2.1
GET_VALUES member function, 17.12.1, 26.20
global name
capture process, 7.5
GLOBAL_NAME view, 24.1.6, 32.1
GRANT_OBJECT_PRIVILEGE procedure, 11.3
GRANT_SYSTEM_PRIVILEGE procedure, 11.3
grids
information provisioning, 35

H

health check script
Oracle Streams, 30.2
high availability
Streams, 13
advantages, 13.2.1
apply, 13.3.2.4
best practices, 13.3
capture, 13.3.2.1
database links, 13.3.2.2
propagation, 13.3.2.3
high-watermark, 10.7

I

ignore SCN, 10.5
implicit capture, 1.2.1
managing, 15
switching mechanisms, 15.4, 15.5
Import
database maintenance, D.2.5
database upgrade, E.2.2
Oracle Streams, 21.1
INCLUDE_EXTRA_ATTRIBUTE procedure, 2.2.1.3, 15.3
index-organized tables
apply process, B.5.1
capture process, B.1.2.1, B.1.2.2
synchronous capture, 2.6.5, B.2.3.1
in-flight transactions, 31.1.1
information provisioning, 35
bulk provisioning, 35.2
Data Pump, 35.2.1
DBMS_STREAMS_TABLESPACE_ADM package, 35.2.3
file group repositories, 35.2.3.1
incremental provisioning, 35.3
on-demand information access, 35.4
RMAN
transportable tablespace from backup, 35.2.2
tablespace repositories, 35.2.3.2
using, 36
initialization parameters
AQ_TM_PROCESSES
Streams apply process, 33.6
instantiation
example
RMAN CONVERT DATABASE, D.3.3.3
RMAN DUPLICATE, D.3.3.2, E.3.3.2
export/import, D.2.5, E.2.2
in Streams, 2.4
RMAN CONVERT DATABASE, D.2.5
RMAN DUPLICATE, D.2.5, E.2.2
instantiation SCN, 10.5
interoperability
compatibility, 29.3
Streams, 29.3.1.2
IS_NULL_TAG member function, 26.20
IS_TRIGGER_FIRE_ONCE function, 10.8.1

K

KEEP_COLUMNS procedure, 6.1
keystores
Oracle Streams, A.2.4

L

LCRs. See logical change records
logical change records (LCRs), 2.2.1, 17.12.1
DDL LCRs, 2.2.1.2
current_schema, B.5.5
rules, 5.3.3.1.2, 5.3.6.1.2
extra attributes, 2.2.1.3
managing, 15.3
monitoring, 24.3
getting information about, 17.7.1, 19.2.1, 26.20
compatibility, 11.7.1.2
row LCRs, 2.2.1.1
rules, 5.3.1.1
XML schema, C
LogMiner
capture process, 7.1
multiple sessions, 7.1
low-watermark, 10.7

M

MAINTAIN_CHANGE_TABLE procedure
examples, 20.3
preparing for, 20.2
prerequisites, 20.2.2
MAINTAIN_GLOBAL procedure, 35.3
MAINTAIN_SCHEMAS procedure, 35.3
MAINTAIN_SIMPLE_TTS procedure, 35.3
MAINTAIN_TABLES procedure, 35.3
MAINTAIN_TTS procedure, 35.3
MAX_COMPATIBLE function, 11.7.1.2
maximum checkpoint SCN, 7.5.1.2
merge streams, 30.3
MERGE_STREAMS_JOB procedure, 30.3
message handlers, 4.2.4, 4.2.4.4
managing, 17.8
monitoring, 26.4.4
setting, 17.8.1
unsetting, 17.8.2
messages
captured, 4.1.2.1
captured LCRs, 4.1.1
dequeue, 4.1.1
enqueue, 2.7
persistent LCRs, 4.1.1, 4.1.2.2
persistent user messages, 4.1.2.4
propagation, 3.3
user messages, 4.1.1, 4.1.2.4
messaging, 3.2.1
buffered messaging, 3.2.2.1
dequeue, 4.4
Transparent Data Encryption, A.2.8
enqueue, 2.7
messaging client, 4.3
messaging client user
secure queues, 8.1.2
transformations
rule-based, 6.3.5
messaging clients
transparent data encryption, A.2.8
Transparent Data Encryption, A.2.7
migrating
to different character set
using Streams, D.3
to different operating system
using Streams, D.3
monitoring
ANYDATA data type queues, 25.1
message consumers, 25.1.4
viewing event contents, 25.1.5
apply process, 26
apply handlers, 26.4
compatible columns, 29.3.3.1
DDL handlers, 26.4.2
error handlers, 26.4.3
error queue, 26.19, 26.20
message handlers, 26.4.4
capture process, 24.1
applied SCN, 24.1.12
compatible tables, 29.3.1.1
elapsed time, 24.1.5
latency, 24.1.13, 24.1.14, 24.1.14, 26.11
message creation time, 24.1.4
rule evaluations, 24.1.15
state change time, 24.1.4
compatibility, 29.3
DML handlers, 26.4.1
file group repositories, 37
Oracle Streams, 22
performance, 23.2, 29.4
propagation jobs, 25.3
propagations, 25, 25.3
queues, 25
rule-based transformations, 28
rules, 27
supplemental logging, 24.1.18
synchronous capture, 24.2
compatible columns, 29.3.2
latency, 26.11
tablespace repositories, 37
multitenant container databases (CDBs), B.9
multi-version data dictionary
missing, 34.1.5

N

NOLOGGING mode
capture process, B.1.2.5

O

oldest SCN, 10.6
ON SCHEMA clause
of CREATE TRIGGER
apply process, 10.8.2
online redefinition
capture process, B.1.2.4
synchronous capture, B.2.3.3
operating systems
migrating
using Streams, D.3
ORA-01291 error, 31.1.6
ORA-01403 error, 33.11.2.2
ORA-06550 error, 33.7
ORA-23605 error, 33.11.2.3
ORA-23607 error, 33.11.2.4
ORA-24031 error, 33.11.2.5
ORA-24093 error, 32.3.1
ORA-25224 error, 32.3.2
ORA-26666 error, 33.1
ORA-26678 error, 31.1.8
ORA-26687 error, 33.11.2.6
ORA-26688 error, 33.11.2.7
ORA-26689 error, 33.11.2.8
Oracle Data Pump
information provisioning, 35.2.1
Oracle Database Vault
Oracle Streams, A.6
Oracle Enterprise Manager Cloud Control
Streams tool, 14.3
Oracle Label Security (OLS)
apply processes, B.5.6
capture processes, B.1.5
synchronous captures, B.2.5
Oracle Real Application Clusters
interoperation with Oracle Streams, A.1, A.1.1, A.1.2, A.1.4, A.1.6
queues, A.1.4
Oracle Scheduler
propagation jobs, 9.1
Oracle Streams
administrator
monitoring, 29.1.1
alert log, 30.4
alerts, 30.1
apply process, 4, 10
capture process, 2, 2.5, 2.6, 7
compatibility, 11.7.1.2, 29.3
data dictionary, 9.2, 10.9, 22
database maintenance, D
directed networks, 3.3.4
documentation roadmap, 1.5
Export utility, 21.1
flashback data archive, A.3
health check script, 30.2
high availability, 13
Import utility, 21.1
information provisioning, 35.3
instantiation, 2.4
interoperability, 29.3.1.2
interoperation with Oracle Real Application Clusters, A.1
interoperation with Transparent Data Encryption, A.2
logical change records (LCRs), 2.2.1
XML schema, C
LogMiner data dictionary, 7.5.1
messaging, 3.2.1
messaging clients, 4.3
monitoring, 22
Oracle Database Vault, A.6
overview, 1.1
packages, 14.1
propagation, 3, 9
Oracle Real Application Clusters, A.1.4
queues, 8
Oracle Real Application Clusters, A.1.4
restrictions, B
rules, 5
action context, 11.6
evaluation context, 5.3, 11.4
event context, 11.5
subset rules, 5.3, 5.3.4
system-created, 5.3
staging, 3
Oracle Real Application Clusters, A.1.4
Streams data dictionary, 7.6
Streams pool
monitoring, 29.2
Streams tool, 14.3
supplemental logging, 2.5.5
synchronous capture, 2.6
tags, 1.2.7
topology, 23.1
trace files, 30.4
transformations
rule-based, 6
Transparent Data Encryption, A.2.4
troubleshooting, 30, 31, 32, 33, 34
upgrading online, D, E
user messages, 3.1
Oracle Streams Performance Advisor, 23.2
gathering information, 23.5
Streams components, 23.2.2
viewing statistics, 23.6.2
bottleneck components, 23.6.2.1
component-level, 23.6.2.2
latency, 23.6.2.2
rates, 23.6.2.2
session-level, 23.6.2.3
stream paths, 23.6.2.4

P

patches
applying
using Streams, D.3
performance
Oracle Streams Performance Advisor, 23.2
gathering information, 23.5
Streams components, 23.2.2
viewing statistics, 23.6.2
persistent LCRs, 4.1.2.2
persistent user messages, 4.1.2.4
pluggable databases (PDBs), B.9
POST_INSTANTIATION_SETUP procedure, 35.3
PRE_INSTANTIATION_SETUP procedure, 35.3
precommit handlers, 4.2.4.5
creating, 17.9.1
managing, 17.9
monitoring, 26.4.5
setting, 17.9.2
unsetting, 17.9.3
prepare SCN, 2.5.7.2.4
privileges
Oracle Streams administrator
monitoring, 29.1.1
rules, 11.3
procedure DML handlers, 4.2.4.1.2
creating, 17.6.2.1
managing, 17.6.2
monitoring, 26.4.1.3
setting, 17.6.2.2, 17.6.2.2
SQL generation, 17.6.2.1
unsetting, 17.6.2.3
propagation
combined capture and apply, 12.1
query to determine, 25.3.6, 25.3.7
propagation receivers, 25.3.7
propagation senders, 25.3.6
propagation jobs, 9.1
altering, 16.2.3
managing, 16.2
monitoring, 25.3
Oracle Scheduler, 9.1
RESTRICTED SESSION, 9.1.2
scheduling, 9.1.1
trace files, 30.4.2
troubleshooting, 32
propagations, 3, 3.3, 9
binary files, 9.3
buffered queues, 3.2.2
destination queue, 3.1
directed networks, 3.3.4
dropping, 16.2.8
ensured delivery, 3.3.3
managing, 16.2
monitoring, 25, 25.3
queue-to-queue, 3.3.2, 3.3.2, 25.3.1
Oracle Real Application Clusters, A.1.4
propagation job, 9.1
schedule, 16.2.3.1
rule sets
removing, 16.2.7
specifying, 16.2.4
rules, 3.3.1, 5.1
adding, 16.2.5
removing, 16.2.6
session information, 25.3.8
source queue, 3.1
starting, 16.2.1
stopping, 16.2.2
transformations
rule-based, 6.3.3
Transparent Data Encryption, A.2.5
troubleshooting, 32
checking queues, 32.1
checking status, 32.2
security, 32.3

Q

queue forwarding, 3.3.4.1
queues
ANYDATA, 3.2.1
removing, 16.1.3
browsing, 8.3.1.2
buffered, 3.2.2
commit-time, 8.3
dependencies, 8.3.1
dequeue high-watermark, 8.3.2
monitoring, 25
nontransactional, 8.2
Oracle Real Application Clusters, A.1.4
queue tables, 3.2.2
triggers, 3.2.2
secure, 8.1
disabling user access, 16.1.2
enabling user access, 16.1.1
users, 8.1.2
synchronous capture, 2.6.2
transactional, 8.2
typed, 3.2.1
queue-to-queue propagations, 3.3.2, 3.3.2, 25.3.1
schedule, 16.2.3.1

R

RE$NV_LIST type, 11.2
ADD_PAIR member procedure, 18.2.2.2, 18.2.2.3, 19.2.1, 19.2.2
REMOVE_PAIR member procedure, 18.2.2.2, 18.2.2.4, 19.2.2, 19.2.3
Recovery Manager
capture processes
archived redo log files, A.4.2
fast recovery area, 31.1.6
CONVERT DATABASE command
Streams instantiation, D.2.5, D.3.3.3
DUPLICATE command
Streams instantiation, D.2.5, D.3.3.2, E.2.2, E.3.3.2
information provisioning, 35.2.2
redo logs
capture process, 2.5.1
REMOVE_PAIR member procedure, 18.2.2.2, 18.2.2.4, 19.2.2, 19.2.2, 19.2.3
REMOVE_QUEUE procedure, 16.1.3
REMOVE_RULE procedure, 15.1.3.3, 16.2.6, 17.3.3, 18.1.3
RENAME_COLUMN procedure, 6.1, 19.1.2
RENAME_SCHEMA procedure, 6.1
RENAME_TABLE procedure, 6.1, 19.1.1.1, 19.1.3
replication
split and merge, 30.3
required checkpoint SCN, 7.4
RESTRICTED SESSION system privilege
apply processes, 4.2.9
capture processes, 2.5.8
propagation jobs, 9.1.2
REVOKE_OBJECT_PRIVILEGE procedure, 11.3
REVOKE_SYSTEM_PRIVILEGE procedure, 11.3
RMAN. See Recovery Manager
row migration, 5.3.4.2, 5.3.4.2
rule sets, 11.1
adding rules to, 18.1.2
creating, 18.1.1
dropping, 18.1.4
evaluation, 11.2
partial, 11.2.2
negative, 5.2
object privileges
granting, 18.3.2
revoking, 18.3.4
positive, 5.2
removing rules from, 18.1.3
system privileges
granting, 18.3.1
revoking, 18.3.3
rule-based transformations, 6
custom, 6.2
action contexts, 6.2.1
altering, 19.2.2
creating, 19.2.1
managing, 19.2
monitoring, 28.3
privileges, 6.2.2
removing, 19.2.3
declarative, 6.1
adding, 19.1.1
managing, 19.1
monitoring, 28.2
removing, 19.1.3
step number, 6.4.1
troubleshooting, 34.2
managing, 19
monitoring, 28
ordering, 6.4
rules, 11
action contexts, 11.1.3
adding name-value pairs, 18.2.2.2, 18.2.2.3, 19.2.1, 19.2.2
altering, 18.2.2.2
removing name-value pairs, 18.2.2.4, 19.2.2, 19.2.3
transformations, 6.2.1
ADD_RULE procedure, 11.1.2.2
altering, 18.2.2
apply process, 4.2.2, 5.1
capture process, 2.5.2, 5.1
components, 11.1
creating, 18.2.1
DBMS_RULE package, 11.2
DBMS_RULE_ADM package, 18
dropping, 18.2.4
EVALUATE procedure, 11.2
evaluation, 11.2
capture process, 7.7
iterators, 11.2
partial, 11.2.2
evaluation contexts, 11.1.2
evaluation function, 11.1.2.3
user-created, 11.7.2
variables, 11.1.2.1
event context, 11.2
explicit variables, 11.1.2.1
implicit variables, 11.1.2.1
iterative results, 11.2
managing, 18.1
MAYBE rules, 11.2
monitoring, 27
object privileges
granting, 18.3.2
revoking, 18.3.4
partial evaluation, 11.2.2
privileges, 11.3
managing, 18.3
propagations, 3.3.1, 5.1
rule conditions, 5.3.3, 5.3.4, 11.1.1
complex, 11.7.1.3
explicit variables, 11.1.2.1
finding patterns in, 27.10
implicit variables, 11.1.2.1
Streams compatibility, 11.7.1.2
types of operations, 11.7.1.1
undefined variables, 11.7.1.4
using NOT, 11.7.1.3.1
variables, 5.3.1.1
rule_hits, 11.2
simple rules, 11.1.1.2
subset, 5.3.4
querying for action context of, 19.2.1
querying for names of, 19.2.1
synchronous capture, 2.6.3
system privileges
granting, 18.3.1
revoking, 18.3.3
system-created, 5, 5.3
action context, 11.6
and_condition parameter, 5.3.7
DDL rules, 5.3.3.1.2, 5.3.6.1.2
DML rules, 5.3.1.1
evaluation context, 5.3, 11.4
event context, 11.5
global, 5.3.1
modifying, 18.2.3
row migration, 5.3.4.2
schema, 5.3.2
STREAMS$EVALUATION_CONTEXT, 5.3, 11.4
subset, 5.3, 5.3.4
table, 5.3.3
troubleshooting, 34
TRUE rules, 11.2
user-created, 11.7
variables, 11.1.2.1

S

scripts
Oracle Streams, 30.2
secure queues, 8.1
disabling user access, 16.1.2
enabling user access, 16.1.1
propagation, 32.3
Streams clients
users, 8.1.2
SET_CHANGE_HANDLER procedure, 20.4.1
SET_DML_HANDLER procedure, 4.2.4.1.1, 4.2.4.1.2
setting a DML handler, 17.6.2.2
setting an error handler, 17.12.2
unsetting a DML handler, 17.6.2.3, 17.6.2.3
unsetting an error handler, 17.12.3
SET_ENQUEUE_DESTINATION procedure, 17.10
SET_EXECUTE procedure, 17.11
SET_KEY_COLUMNS procedure, 10.3.2
removing substitute key columns, 17.14.2
setting substitute key columns, 17.14.1
SET_PARAMETER procedure
apply process, 17.4, 33.9
capture process, 15.1.4
SET_RULE_TRANSFORM_FUNCTION procedure, 19.2
SET_TRIGGER_FIRING_PROPERTY procedure, 10.8.1
SET_VALUE member procedure, 17.13.1.1.2, 19.2.1
SET_VALUES member procedure, 17.12.1, 17.12.1
SGA_MAX_SIZE initialization parameter, 7.1
source queue, 3.1
split streams, 30.3
SPLIT_STREAMS procedure, 30.3
SQL generation, 4.2.8
character sets, 4.2.8.4
data types supported, 4.2.8.3
examples, 4.2.8.5, 17.6.2.1
formats, 4.2.8.2
interfaces, 4.2.8.1
procedure DML handlers, 17.6.2.1
SQL*Loader
capture processes, B.1.2.6
staging, 3
approximate CSCN, 8.3.2
buffered queues, 3.2.2
monitoring, 25.2
management, 16
messages, 4.1.1
secure queues, 8.1
disabling user access, 16.1.2
enabling user access, 16.1.1
start SCN, 2.5.7.2
START_APPLY procedure, 17.1
START_CAPTURE procedure, 15.1.1
START_PROPAGATION procedure, 16.2.1
statement DML handlers, 4.2.4.1.1
adding statements to, 17.6.1.2
creating, 17.6.1.1
dropping, 17.6.1.6
managing, 17.6.1
modifying, 17.6.1.3
monitoring, 26.4.1.2
removing from apply process, 17.6.1.5
removing statements from, 17.6.1.4
Statspack
Oracle Streams, 29.4
STOP_APPLY procedure, 17.2
STOP_CAPTURE procedure, 15.1.2
STOP_PROPAGATION procedure, 16.2.2
stream paths, 23.3
combined capture and apply, 23.3.1
Streams data dictionary, 7.6, 9.2, 10.9
streams paths
statistics, 23.6.2.4
Streams pool
monitoring, 29.2
Streams. See Oracle Streams
Streams tool, 14.3
Streams topology
DBMS_STREAMS_ADVISOR_ADM package
gathering information, 23.5
STREAMS$_EVALUATION_CONTEXT, 5.3, 11.4
STREAMS$_TRANSFORM_FUNCTION, 6.2.1
supplemental logging, 2.5.5
conditional log groups, 2.5.5
DBA_LOG_GROUPS view, 24.1.18.1
monitoring, 24.1.18
unconditional log groups, 2.5.5
synchronous capture, 2.6
capture user, 2.6.6
setting, 15.2.2
changes captured
DML changes, 2.6.5
data type restrictions, B.2.3.1
data types captured, 2.6.4
dropping, 15.2.3
index-organized tables, 2.6.5, B.2.3.1
latency
capture to apply, 26.11
managing, 15.2
monitoring, 24.2
compatible columns, 29.3.2
online redefinition, B.2.3.3
Oracle Label Security (OLS), B.2.5
Oracle Real Application Clusters, A.1.2
queues, 2.6.2
rule sets
specifying, 15.2.1.1
rules, 2.6.3
adding, 15.2.1.2
modifying, 2.6.3, 18.2.2.1
switching to, 15.4
SYS schema, 2.6.3
SYSTEM schema, 2.6.3
table type restrictions, B.2.3.2
transformations
rule-based, 6.3.2
Transparent Data Encryption, A.2.2
SYS.AnyData. See ANYDATA data type
system change numbers (SCN)
applied SCN for a capture process, 2.5.7.1, 24.1.12
applied SCN for an apply process, 10.7
captured SCN for a capture process, 2.5.7.1
first SCN for a capture process, 2.5.7.2
maximum checkpoint SCN for a capture process, 7.2.2
oldest SCN for an apply process, 10.6
required checkpoint SCN for a capture process, 7.2.1
start SCN for a capture process, 2.5.7.2
system-generated names
apply process, 10.4.1

T

tables
index-organized
capture process, B.1.2.2
tablespace repositories, 35.2.3.2
creating, 36.1.1
monitoring, 37, 37.2
using, 36.1
with shared file system, 36.1.2
without shared file system, 36.1.3
tags, 1.2.7
topology
component IDs, 23.3
DBMS_STREAMS_ADVISOR_ADM package
gathering information, 23.5
gathering information, 23.5
Oracle Streams, 23.1
stream paths, 23.3
combined capture and apply, 23.3.1
statistics, 23.6.2.4
viewing, 23.6.1.3
viewing, 23.6.1
trace files
Oracle Streams, 30.4
transformations
custom rule-based, 6.2
action context, 6.2.1
altering, 19.2.2
creating, 19.2.1
monitoring, 28.3
removing, 19.2.3
STREAMS$_TRANSFORM_FUNCTION, 6.2.1
troubleshooting, 34.3
declarative rule-based, 6.1
monitoring, 28.2
troubleshooting, 34.2
Oracle Streams, 6
rule-based, 6
apply process, 6.3.4
capture process, 6.3.1
errors during apply, 6.3.4.1
errors during capture, 6.3.1.1
errors during dequeue, 6.3.5.1
errors during propagation, 6.3.3.1
managing, 19
messaging client, 6.3.5
monitoring, 28
multiple, 6.3.6
propagations, 6.3.3
synchronous capture, 6.3.2
transparent data encryption
messaging clients, A.2.8
Transparent Data Encryption
apply processes, A.2.6
buffered queues, A.2.4
capture processes, A.2.1
dequeue, A.2.8
error queue, A.2.6
explicit capture, A.2.3
interoperation with Oracle Streams, A.2
messaging clients, A.2.7
propagations, A.2.5
synchronous capture, A.2.2
triggers
firing property, 10.8.1
queue tables, 3.2.2
system triggers
on SCHEMA, 10.8.2
troubleshooting
alerts, 30.1
apply process, 33
checking apply handlers, 33.5
checking message type, 33.3
checking status, 33.1
error queue, 33.11
performance, 33.10
capture process, 31, 31.1
checking progress, 31.1.5
checking status, 31.1.2
creation, 31.1.1
custom rule-based transformations, 34.3
missing multi-version data dictionary, 34.1.5
Oracle Streams, 30, 31, 32, 33, 34
propagation jobs, 32
propagations, 32
checking queues, 32.1
checking status, 32.2
security, 32.3
rules, 34

U

UNRECOVERABLE clause
SQL*Loader
capture process, B.1.2.6
UNRECOVERABLE SQL keyword
capture process, B.1.2.5
upgrading
online using Streams, D, E
assumptions, E.1.2
capture database, E.1.1
instantiation, E.2.2
job queue processes, E.1.3
PL/SQL package subprograms, E.1.3
user-defined types, E.2.1
user messages, 3.1, 4.1.2.4
UTL_SPADV package, 14.1.14

V

V$ARCHIVE_DEST view, 24.1.6
V$ARCHIVED_LOG view, 2.5.7.2
V$BUFFERED_PUBLISHERS view, 25.2.2
V$BUFFERED_QUEUES view, 25.2.1, 25.2.6, 25.2.8
V$BUFFERED_SUBSCRIBERS view, 25.2.6, 25.2.8
V$DATABASE view
supplemental logging, 24.1.18.2
V$PROPAGATION_RECEIVER view, 25.2.7, 25.3.7
V$PROPAGATION_SENDER view, 25.2.3, 25.2.4, 25.2.5, 25.3.6
V$RULE view, 27.14
V$RULE_SET view, 27.12, 27.13
V$RULE_SET_AGGREGATE_STATS view, 27.11
V$SESSION view, 24.1.2, 24.1.3, 25.3.8, 26.5, 26.6, 26.8, 26.9, 26.12
V$STREAMS_APPLY_COORDINATOR view, 4.2.10.2, 26.9, 26.10, 26.11
V$STREAMS_APPLY_READER view, 4.2.10.1, 26.6, 26.7, 26.8, 26.16
V$STREAMS_APPLY_SERVER view, 4.2.10.3, 26.12, 26.13, 33.10
V$STREAMS_CAPTURE view, 2.5.11, 24.1.3, 24.1.4, 24.1.5, 24.1.10, 24.1.13, 24.1.14, 24.1.14, 24.1.15, 24.1.16, 31.1.5
V$STREAMS_POOL_ADVICE view, 29.2
virtual dependency definitions, 10.2.5
object dependencies, 10.2.5.2
managing, 17.15.2
monitoring, 26.18.2
value dependencies, 10.2.5.1
managing, 17.15.1
monitoring, 26.18.1

X

XML Schema
for LCRs, C