Index

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_SCHEDULE procedure 16.2.3
ALTER_PROPAGATION procedure
- removing the rule set 16.2.7
- specifying the rule set 16.2.4
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
  - 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
- rules 4.2.2, 5.1
  - adding 17.3.2
  - removing 17.3.3
- rule sets
  - removing 17.3.4
  - specifying 17.3.1
- 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
captured LCRs 4.1.2.1
captured SCN 2.5.7.1
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
- captured LCRs 4.1.1
- captured SCN 2.5.7.1
- capture user 2.5.10
  - secure queues 8.1.2
  - setting 15.1.5
- 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
- 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
- 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, 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
- rules 2.5.2, 5.1
  - adding 15.1.3.2
  - removing 15.1.3.3
- rule sets
  - removing 15.1.3.4
  - specifying 15.1.3.1
- session information 24.1.2
- SGA_MAX_SIZE initialization parameter 7.1
- starting 15.1.1
- start SCN 2.5.7.2, 2.5.7.2.4
- 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
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_APPLY procedure 10.1
CREATE_CAPTURE procedure 7.5
CREATE_RULE_SET procedure 18.1.1
CREATE_RULE procedure 18.2.1
CREATE TABLE statement
- AS SELECT
  - apply process 10.4.2

D

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
data types
- applied 4.2.6
  - automatic conversion 4.2.7
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
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_APPLY view 26.1, 26.2, 26.4.2, 26.4.4, 26.6, 26.12, 33.1, 33.3
DBA_CAPTURE_EXTRA_ATTRIBUTES view 24.3
DBA_CAPTURE_PARAMETERS view 24.1.11
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_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_TABLESPACES view 37.2.1
DBA_FILE_GROUP_TABLES view 37.2.2
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_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_COMPONENT view 23.2.1, 23.6.1.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_TABLES view 24.2.2
DBA_SYNC_CAPTURE view 24.2.1
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_ADM package 14.1.6, 18, 18.1
DBMS_RULE package 11.2, 14.1.5
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
DBMS_STREAMS package 14.1.7
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
directed networks 3.3.4
- apply forwarding 3.3.4.1
- queue forwarding 3.3.4.1
direct path load
- capture processes B.1.2.6
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
- 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_SET procedure 18.1.4
DROP_RULE procedure 18.2.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 rules 11.1.2.2
- association with rule sets 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_ALL_ERRORS procedure 17.13.1.2
EXECUTE_ERROR procedure 4.2.14, 17.13.1.1
EXECUTE member procedure 17.7.1, 17.12.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
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 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
MAX_COMPATIBLE function 11.7.1.2
maximum checkpoint SCN 7.5.1.2
MERGE_STREAMS_JOB procedure 30.3
merge streams 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, 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
online redefinition
- capture process B.1.2.4
- synchronous capture B.2.3.3
ON SCHEMA clause
- of CREATE TRIGGER
  - apply process 10.8.2
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 Database Vault
- Oracle Streams A.6
Oracle Data Pump
- information provisioning 35.2.1
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
- database maintenance D
- data dictionary 9.2, 10.9, 22
- 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
- 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, 25.3.1
  - Oracle Real Application Clusters A.1.4
  - propagation job 9.1
  - schedule 16.2.3.1
- rules 3.3.1, 5.1
  - adding 16.2.5
  - removing 16.2.6
- rule sets
  - removing 16.2.7
  - specifying 16.2.4
- 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, 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.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
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_ADM package 18
- DBMS_RULE package 11.2
- 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_hits 11.2
- 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
- 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-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
- system privileges
  - granting 18.3.1
  - revoking 18.3.3
- troubleshooting 34
- TRUE rules 11.2
- user-created 11.7
- variables 11.1.2.1
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

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
- 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
SGA_MAX_SIZE initialization parameter 7.1
source queue 3.1
SPLIT_STREAMS procedure 30.3
split streams 30.3
SQL*Loader
- capture processes B.1.2.6
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
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_APPLY procedure 17.1
START_CAPTURE procedure 15.1.1
START_PROPAGATION procedure 16.2.1
start SCN 2.5.7.2
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
- See: Oracle Streams
STREAMS$_EVALUATION_CONTEXT 5.3, 11.4
STREAMS$_TRANSFORM_FUNCTION 6.2.1
Streams data dictionary 7.6, 9.2, 10.9
streams paths
- statistics 23.6.2.4
Streams pool
- monitoring 29.2
Streams tool 14.3
Streams topology
- DBMS_STREAMS_ADVISOR_ADM package
  - gathering information 23.5
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
- rules 2.6.3
  - adding 15.2.1.2
  - modifying 2.6.3, 18.2.2.1
- rule sets
  - specifying 15.2.1.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
  - without shared file system 36.1.3
  - with shared file system 36.1.2
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_SET_AGGREGATE_STATS view 27.11
V$RULE_SET view 27.12, 27.13
V$RULE view 27.14
V$SESSION view 24.1.2, 24.1.3, 25.3.8, 26.5, 26.6, 26.12, 26.8, 26.9
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.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