Index
A
- ABORT_GLOBAL_INSTANTIATION procedure 8.2.5
- ABORT_SCHEMA_INSTANTIATION procedure 8.2.5
- ABORT_SYNC_INSTANTIATION procedure 8.2.5
- ABORT_TABLE_INSTANTIATION procedure 8.2.5
- ADD_TABLE_PROPAGATION_RULES procedure 2.2.6
- ADD_TABLE_RULES procedure 2.2.6
- ADD SUPPLEMENTAL LOG 1.3.6.2
- ADD SUPPLEMENTAL LOG DATA 1.3.6.3
- ADD SUPPLEMENTAL LOG DATA clause of ALTER DATABASE 1.3.6.5
- ADD SUPPLEMENTAL LOG GROUP clause of ALTER TABLE
- alert log
- Streams best practices 15.2.6
- ALTER_APPLY procedure 2.2.6
- ALTER DATABASE statement
- ALTER TABLE statement
- ANYDATA data type
- queues
- creating 6.1
- queues
- apply process
- apply handlers 1.2.5
- apply user
- best practices 18.1.1
- best practices
- conflict resolution 9
- creating 7.1
- data types applied
- heterogeneous environments 11.1.2.2
- DML changes
- heterogeneous environments 11.1.2.3
- DML handlers
- heterogeneous environments 11.1.2.1.5
- error handlers
- heterogeneous 11.1.2.1.7
- errors
- heterogeneous environments 11.1.2, 11.2.3
- database links 11.1.2.1.1
- Oracle Database Gateways 11.1.2.1.1
- LOBs 14.4.1
- message handlers
- heterogeneous environments 11.1.2.1.6
- oldest SCN
- point-in-time recovery 12.6.3
- parallelism
- best practices 18.2.1
- substitute key columns
- heterogeneous environments 11.1.2.1.3, 11.1.2.1.4, 11.1.2.1.5, 11.1.2.1.6, 11.1.2.1.7
- tags 10.4
- update conflict handlers
- monitoring 9.8.2
- ARCHIVELOG mode 1.3.3
- capture process 5.1.1
B
- backups
- batch processing
- capture process best practices 16.2.3
- best practices
- Streams replication
- alert log 15.2.6
- apply 18
- apply errors 18.2.2, 18.3.1
- apply process configuration 18.2
- apply process operation 18.3
- apply process parallelism 18.2.1
- apply user 18.1.1
- archive log threads 15.3.1
- automate configuration 15.1.2
- backups 15.2.4
- batch processing 16.2.3
- capture 16
- capture process configuration 16.1
- capture process operation 16.2
- capture process parallelism 16.1.2
- capture process’s queue 15.2.3
- capture user 16.1.1
- checkpoint retention 16.1.3
- conflict resolution 18.1.3
- database configuration 15.1
- database operation 15.2
- data dictionary build 16.2.2
- DDL replication 1.2.6
- destination database 18.1
- global name 15.2.1
- heartbeat table 16.2.1
- instantiation SCN 18.1.2
- Oracle Real Application Clusters (Oracle RAC) databases 15.3
- performance 15.2.2
- prepare for instantiation 16.2.2
- propagation 17
- propagation latency 17.1.2
- queue-to-queue propagation 17.1.1
- removing 15.2.7
- restarting propagation 17.2.1
- SDU 17.1.3
- statistics collection 15.2.5
- synchronous capture configuration 16.3
- Streams replication
- bi-directional replication 1.2.3, 1.2.7
C
- capture process
- ARCHIVELOG mode 5.1.1
- best practices
- capture user
- best practices 16.1.1
- configuring 5
- creating 5.1
- DBID
- changing 12.4
- downstream capture 1.2.2, 2.2.2.1
- creating 5.1
- global name
- changing 12.4
- heterogeneous environments 11.1.1
- local capture 1.2.2, 2.2.2.1
- log sequence number
- resetting 12.6.1
- parallelism
- best practices 16.1.2
- parameters
- preparing for 5.1.1
- supplemental logging 1.3.6, 8.2.3
- change cycling
- avoidance
- tags 10.5
- avoidance
- checkpoint retention
- best practices 16.1.3
- column lists 9.6.1.2
- COMPARE_OLD_VALUES procedure 9.4.1, 9.7.4
- COMPARE function 13.3.2, 13.6
- perform_row_dif parameter 13.6.2
- comparing database objects 13.6
- conflict resolution 9
- conflicts
- CONVERGE procedure 13.3.3, 13.8
- CREATE_APPLY procedure 2.2.6, 7.1
- CREATE_CAPTURE procedure 5.1, 5.1.2.2
- CREATE_COMPARISON procedure 13.3.2, 13.6
- CREATE_PROPAGATION procedure 6.2
- CREATE_SYNC_CAPTURE procedure 5.2.3
D
- data
- database links 1.3.2
- databases
- data types
- heterogeneous environments 11.1.2.2
- DBA_APPLY_CONFLICT_COLUMNS view 9.8.2
- DBA_APPLY_INSTANTIATED_OBJECTS view 8.6.2
- DBA_APPLY_TABLE_COLUMNS view 9.8.1
- DBA_APPLY view 10.7.2
- DBA_CAPTURE_PREPARED_DATABASE view 8.6.1
- DBA_CAPTURE_PREPARED_SCHEMAS view 8.6.1
- DBA_CAPTURE_PREPARED_TABLES view 8.6.1
- DBA_COMPARISON_COLUMNS view 13.3.2, 13.7.3
- DBA_COMPARISON_ROW_DIF view 13.3.2
- DBA_COMPARISON_SCAN_VALUES view 13.7.7
- DBA_COMPARISON_SCAN view 13.3.2, 13.7.4, 13.7.5, 13.7.6
- DBA_COMPARISON view 13.3.2, 13.7, 13.7.5, 13.7.6
- DBA_RECOVERABLE_SCRIPT_BLOCKS view 12.8
- DBA_RECOVERABLE_SCRIPT_ERRORS view 12.8
- DBA_RECOVERABLE_SCRIPT_PARAMS view 12.8
- DBA_RECOVERABLE_SCRIPT view 12.8
- DBA_SYNC_CAPTURE_PREPARED_TABS view 8.6.1
- DBID (database identifier)
- capture process
- changing 12.4
- capture process
- DBMS_APPLY_ADM package 1.2.1.3, 2.2.6
- DBMS_CAPTURE_ADM package 1.2.1.3, 2.2.6, 5
- DBMS_COMPARISON package 13.3.2, 13.3.3
- DBMS_PROPAGATION_ADM package 6
- DBMS_STREAMS_ADM package 1.1.2, 1.2.1.3, 2.2.6, 5, 6
- DBMS_STREAMS package 10.6
- DDL replication
- best practices 1.2.6
- directory objects 2.2.3
- creating 4.2.2
- DISCARD conflict resolution handler 9.6.1.1.2
- DML handlers
- LOB assembly 14.4.2
- downstream capture 1.2.2, 2.2.2.1
- DROP_COMPARISON procedure 13.11
- DROP SUPPLEMENTAL LOG DATA clause of ALTER DATABASE 1.3.6.6
- DROP SUPPLEMENTAL LOG GROUP clause 1.3.6.4
H
- heartbeat table
- Streams best practices 16.2.1
- heterogeneous information sharing 11
- non-Oracle to non-Oracle 11.3
- non-Oracle to Oracle 11.2
- Oracle to non-Oracle 11.1
- apply process 11.1.2
- capture process 11.1.1
- database links 11.1.2.1.1
- data types applied 11.1.2.2
- DML changes 11.1.2.3
- DML handlers 11.1.2.1.5
- error handlers 11.1.2.1.7
- errors 11.1.5
- instantiation 11.1.2.4
- message handlers 11.1.2.1.6
- staging 11.1.1
- substitute key columns 11.1.2.1.3, 11.1.2.1.4, 11.1.2.1.5, 11.1.2.1.6, 11.1.2.1.7
- transformations 11.1.3
- hub-and-spoke replication 1.2.1.2, 1.2.3, 1.2.7, 10.5.2
- configuring 2.2.7
I
- Import
- initialization parameters
- instantiation 2.2.2.6, 8
- instantiation SCN
L
- LCRs
- See: logical change records
- LOB assembly 14.4.2
- LOBs
- LOG_ARCHIVE_DEST_n initialization parameter 1.3.4
- LOG_ARCHIVE_DEST_STATE_n initialization parameter 1.3.4
- logical change records (LCRs)
- log sequence number
- Streams capture process 12.6.1
- LONG data type
- Oracle Streams 14.5
- LONG RAW data type
- Oracle 14.5
M
- MAINTAIN_GLOBAL procedure 2.2, 2.2.4.1
- MAINTAIN_SCHEMAS procedure 2.2, 2.2.4.2, 2.2.5.2, 2.2.5.3, 2.2.7
- MAINTAIN_SIMPLE_TTS procedure 2.2, 2.2.5.1
- MAINTAIN_TABLES procedure 2.2, 2.2.4.3
- MAINTAIN_TTS procedure 2.2, 2.2.5.1
- MAXIMUM conflict resolution handler 9.6.1.1.3
- latest time 9.6.1.1.3
- MEMORY_MAX_TARGET initialization parameter 1.3.5.1
- MEMORY_TARGET initialization parameter 1.3.5.1
- MERGE_STREAMS_JOB procedure 12.3.2.2
- MERGE_STREAMS procedure 12.3.2.2
- merge streams 12.3
- message_tracking_frequency capture process parameter 12.2
- message tracking 12.2
- MINIMUM conflict resolution handler 9.6.1.1.4
- monitoring
O
- objects
- oldest SCN
- point-in-time recovery 12.6.3
- one-way replication 1.2.7
- optimizer
- statistics collection
- best practices 15.2.5
- statistics collection
- Oracle Database Gateways
- Oracle Streams 11.1.2.1.1
- Oracle Data Pump
- Oracle Real Application Clusters
- Oracle Streams
- conflict resolution 9
- DBMS_COMPARISON package 13.12
- Export utility 8.5.1
- heterogeneous information sharing 11
- Import utility 8.5.1
- instantiation 8.1, 8.5.1
- LOBs 14.4
- logical change records (LCRs)
- managing 14
- LONG data type 14.5
- Oracle Database Gateways 11.1.2.1.1
- point-in-time recovery 12.6
- replication 1
- rules 1.1.2
- sequences 9.5.2.1
- tags 10
- XMLType 14.4
- Oracle Streams Performance Advisor 15.2.2
- OVERWRITE conflict resolution handler 9.6.1.1.1
P
- performance
- Oracle Streams 15.2.2
- point-in-time recovery
- Oracle Streams 12.6
- POST_INSTANTIATION_SETUP procedure 2.2, 2.2.4.1, 2.2.5.1
- PRE_INSTANTIATION_SETUP procedure 2.2, 2.2.4.1, 2.2.5.1
- PREPARE_GLOBAL_INSTANTIATION procedure 8.2, 8.2.4
- PREPARE_SCHEMA_INSTANTIATION procedure 8.2, 8.2.4
- PREPARE_SYNC_INSTANTIATION function 8.2, 8.2.4
- PREPARE_TABLE_INSTANTIATION procedure 8.2, 8.2.4
- propagation
- propagation jobs
- managing 6.2
- propagations
- PURGE_COMPARISON procedure 13.10
R
- RECHECK function 13.9
- RECOVER_OPERATION procedure 12.8
- Recovery Manager
- replication
- adding databases 4.2.2, 4.3.2, 4.3.4
- adding objects 4.2.1, 4.3.1, 4.3.3
- adding to 4
- bi-directional 1.2.1, 2.2.2.4
- configuration errors
- recovering 12.8
- configuring 2, 3
- apply handlers 1.2.5
- ARCHIVELOG mode 1.3.3
- bi-directional 1.2.3, 1.2.7
- database 2.2.4.1
- database links 1.3.2
- DBMS_STREAMS_ADM package 2.2
- DDL changes 1.2.6, 2.2.2.5
- directory objects 2.2.3
- downstream capture 1.2.2, 2.2.2.1, 2.2.5
- hub-and-spoke 1.2.3, 1.2.7, 2.2.7
- initialization parameters 1.3.4
- instantiation 2.2.2.6
- local capture 1.2.2, 2.2.2.1
- log file transfer 1.3.7
- multiple-source environment 3.2
- n-way 1.2.3, 1.2.7
- one-way 1.2.7
- Oracle Enterprise Manager Cloud Control 2.1
- Oracle Streams pool 1.3.5
- preparation 1
- schemas 2.2.4.2, 2.2.5.2, 2.2.5.3, 2.2.7
- scripts 2.2.2.2
- single-source environment 3.1
- standby redo logs 1.3.8
- supplemental logging 1.3.6
- tables 2.2.4.3
- tablespace 2.2.5.1
- tablespaces 2.2.5.1
- tags 2.2.2.4.1
- hub-and-spoke 1.2.1, 10.5.2
- managing 12
- n-way 1.2.1, 10.5.1
- one-way 1.2.1, 2.2.2.4
- Oracle Streams 1
- sequences 9.5.2.1
- split and merge 12.3
- resolution columns 9.6.1.3
- rule-based transformations 1.2.4
- rules 1.1.2
- system-created
- tags 10.2
- system-created
S
- SDU
- Streams best practices 17.1.3
- sequences 9.5.2.1
- replication 9.5.2.1
- SET_DML_HANDLER procedure 9.6.2
- SET_GLOBAL_INSTANTIATION_SCN procedure 8.5, 8.5.2
- SET_MESSAGE_TRACKING procedure 12.2
- SET_SCHEMA_INSTANTIATION_SCN procedure 8.5, 8.5.2
- SET_TABLE_INSTANTIATION_SCN procedure 2.2.6, 8.5
- SET_TAG procedure 10.1, 10.6.1.1
- SET_UP_QUEUE procedure 6.1
- SET_UPDATE_CONFLICT_HANDLER procedure 9.6.1
- SGA_TARGET initialization parameter 1.3.5.2
- SPLIT_STREAMS procedure 12.3.2.2
- split streams 12.3
- staging
- heterogeneous environments 11.1.1
- START_APPLY procedure 2.2.6
- statistics
- Oracle Streams 15.2.2
- STREAMS_CONFIGURATION parameter
- Streams pool
- STRMMON 15.2.2
- supplemental logging 1.3.6
- synchronous capture
- system change numbers (SCN)
- oldest SCN for an apply process
- point-in-time recovery 12.6.3
- oldest SCN for an apply process
T
- tags 2.2.2.4.1, 10
- ALTER_APPLY procedure 10.1, 10.4
- apply process 10.4
- avoiding change cycling 2.2.6
- change cycling
- avoidance 10.5
- CONVERGE procedure 13.8.3
- converging data 13.3.3
- CREATE_APPLY procedure 10.1, 10.4
- examples 10.5
- getting value for current session 10.6.1.2
- hub-and-spoke replication 10.5
- managing 10.6
- monitoring 10.7
- n-way replication 10.5
- online backups 10.3
- removing value for apply process 10.6.2.2
- rules 10.2
- include_tagged_lcr parameter 10.2
- SET_TAG procedure 10.1
- setting value for apply process 10.6.2.1
- setting value for current session 10.6.1.1
- tracking LCRs 12.2
- transformations
- transportable tablespace
- Streams instantiation 8.4.1
- two-database replication 1.2.1.1
- configuring
- synchronous capture 2.2.6
- configuring