Index

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

A

  • ABORT_GLOBAL_INSTANTIATION procedure 1
  • ABORT_SCHEMA_INSTANTIATION procedure 1
  • ABORT_SYNC_INSTANTIATION procedure 1
  • ABORT_TABLE_INSTANTIATION procedure 1
  • ADD_TABLE_PROPAGATION_RULES procedure 1
  • ADD_TABLE_RULES procedure 1
  • ADD SUPPLEMENTAL LOG 1
  • ADD SUPPLEMENTAL LOG DATA 1
  • ADD SUPPLEMENTAL LOG DATA clause of ALTER DATABASE 1
  • ADD SUPPLEMENTAL LOG GROUP clause of ALTER TABLE
    • conditional log groups 1
    • unconditional log groups 1
  • alert log
    • Streams best practices 1
  • ALTER_APPLY procedure
    • removing the tag value 1
    • setting the tag value 1 , 2 , 3
  • ALTER DATABASE statement
    • ADD SUPPLEMENTAL LOG DATA clause 1
    • DROP SUPPLEMENTAL LOG DATA clause 1
  • ALTER TABLE statement
    • ADD SUPPLEMENTAL LOG DATA clause
      • conditional log groups 1
      • unconditional log groups 1
    • ADD SUPPLEMENTAL LOG GROUP clause
      • conditional log groups 1
      • unconditional log groups 1
    • DROP SUPPLEMENTAL LOG GROUP clause 1
  • ANYDATA data type
    • queues
      • creating 1
  • apply process
    • apply handlers 1
    • apply user
      • best practices 1
    • best practices
      • configuration 1
      • operation 1
    • conflict resolution 1
    • creating 1
    • data types applied
      • heterogeneous environments 1
    • DML changes
      • heterogeneous environments 1
    • DML handlers
      • heterogeneous environments 1
    • error handlers
      • heterogeneous 1
    • errors
      • best practices 1 , 2
    • heterogeneous environments
      • database links 1
      • Oracle Database Gateways 1
    • LOBs 1
    • message handlers
      • heterogeneous environments 1
    • oldest SCN
      • point-in-time recovery 1
    • parallelism
      • best practices 1
    • substitute key columns
      • heterogeneous environments 1 , 2 , 3 , 4 , 5
    • tags
      • monitoring 1
      • removing 1
      • setting 1
    • update conflict handlers
      • monitoring 1
  • ARCHIVELOG mode
    • capture process 1

B

  • backups
    • online
      • Streams 1
    • Streams best practices 1
  • batch processing
    • capture process best practices 1
  • best practices
    • Streams replication
      • alert log 1
      • apply 1
      • apply errors 1 , 2
      • apply process configuration 1
      • apply process operation 1
      • apply process parallelism 1
      • apply user 1
      • archive log threads 1
      • automate configuration 1
      • backups 1
      • batch processing 1
      • capture 1
      • capture process configuration 1
      • capture process operation 1
      • capture process parallelism 1
      • capture process’s queue 1
      • capture user 1
      • checkpoint retention 1
      • conflict resolution 1
      • database configuration 1
      • database operation 1
      • data dictionary build 1
      • DDL replication 1
      • destination database 1
      • global name 1
      • heartbeat table 1
      • instantiation SCN 1
      • Oracle Real Application Clusters (Oracle RAC) databases 1
      • performance 1
      • prepare for instantiation 1
      • propagation 1
      • propagation latency 1
      • queue-to-queue propagation 1
      • removing 1
      • restarting propagation 1
      • SDU 1
      • statistics collection 1
      • synchronous capture configuration 1
  • bi-directional replication 1 , 2

C

  • capture process
    • ARCHIVELOG mode 1
    • best practices
      • batch processing 1
      • configuration 1
      • data dictionary build 1
      • operation 1
      • prepare for instantiation 1
    • capture user
      • best practices 1
    • configuring 1
    • creating 1
    • DBID
      • changing 1
    • downstream capture
      • creating 1
    • global name
      • changing 1
    • heterogeneous environments 1
    • local capture 1 , 2
    • log sequence number
      • resetting 1
    • parallelism
      • best practices 1
    • parameters
      • merge_threshold 1
      • message_tracking_frequency 1
      • split_threshold 1
    • preparing for 1
    • supplemental logging 1 , 2
  • change cycling
    • avoidance
      • tags 1
  • checkpoint retention
    • best practices 1
  • column lists 1
  • COMPARE_OLD_VALUES procedure 1 , 2
  • COMPARE function
    • perform_row_dif parameter 1
  • comparing database objects 1
  • conflict resolution
    • best practices 1
    • column lists 1
    • conflict handlers
      • custom 1
      • modifying 1
      • prebuilt 1
      • removing 1
      • setting 1
    • data convergence 1
    • DISCARD handler 1
    • MAXIMUM handler
      • latest time 1
    • MINIMUM handler 1
    • OVERWRITE handler 1
    • resolution columns 1
    • time-based 1
  • conflicts
    • avoidance
      • delete 1
      • primary database ownership 1
      • sequences 1
      • uniqueness 1
      • update 1
    • delete 1
    • detection
      • identifying rows 1
      • monitoring 1
      • stopping 1 , 2
    • DML conflicts 1
    • foreign key 1
    • transaction ordering 1
    • types of 1
    • uniqueness 1
    • update 1 , 2 , 3 , 4
  • CONVERGE procedure 1 , 2
  • CREATE_APPLY procedure
    • tags 1 , 2
  • CREATE_CAPTURE procedure 1 , 2
  • CREATE_COMPARISON procedure 1 , 2
  • CREATE_PROPAGATION procedure 1
  • CREATE_SYNC_CAPTURE procedure 1

D

  • data
    • comparing
      • custom 1
      • cyclic 1
      • purging results 1
      • random 1
      • rechecking 1
      • subset of columns 1
    • converging
      • session tags 1
      • tags 1
  • database links 1
  • databases
    • adding for replication 1 , 2
  • data types
    • heterogeneous environments 1
  • DBA_APPLY_CONFLICT_COLUMNS view 1
  • DBA_APPLY_INSTANTIATED_OBJECTS view 1
  • DBA_APPLY_TABLE_COLUMNS view 1
  • DBA_APPLY view 1
  • DBA_CAPTURE_PREPARED_DATABASE view 1
  • DBA_CAPTURE_PREPARED_SCHEMAS view 1
  • DBA_CAPTURE_PREPARED_TABLES view 1
  • DBA_COMPARISON_COLUMNS view 1 , 2
  • DBA_COMPARISON_ROW_DIF view 1
  • DBA_COMPARISON_SCAN_VALUES view 1
  • DBA_COMPARISON_SCAN view 1 , 3 , 4 , 5
  • DBA_COMPARISON view 1 , 2 , 3 , 4
  • DBA_RECOVERABLE_SCRIPT_BLOCKS view 1
  • DBA_RECOVERABLE_SCRIPT_ERRORS view 1
  • DBA_RECOVERABLE_SCRIPT_PARAMS view 1
  • DBA_RECOVERABLE_SCRIPT view 1
  • DBA_SYNC_CAPTURE_PREPARED_TABS view 1
  • DBID (database identifier)
    • capture process
      • changing 1
  • DBMS_APPLY_ADM package 1 , 2
  • DBMS_CAPTURE_ADM package 1 , 2 , 3
  • DBMS_COMPARISON package
    • buckets 1
    • comparing database objects
      • custom 1
      • cyclic 1
      • purging results 1
      • random 1
      • rechecking 1
      • subset of columns 1
    • converging database objects
      • session tags 1
    • monitoring 1
    • parent scans 1
    • preparation 1
    • root scans 1
    • scans 1
    • Streams replication 1
    • using 1
  • DBMS_PROPAGATION_ADM package 1
  • DBMS_STREAMS_ADM package
    • creating a capture process 1
    • creating an apply process 1
    • creating a propagation 1
    • preparation for instantiation 1
    • tags 1
  • DBMS_STREAMS package 1
  • DDL replication
    • best practices 1
  • directory objects
    • creating 1
  • DISCARD conflict resolution handler 1
  • DML handlers
    • LOB assembly 1
  • downstream capture
    • archived-log 1
    • configuring 1
    • log file transfer 1
    • real-time 1 , 2
    • standby redo logs 1
  • DROP_COMPARISON procedure 1
  • DROP SUPPLEMENTAL LOG DATA clause of ALTER DATABASE 1
  • DROP SUPPLEMENTAL LOG GROUP clause 1

E

  • ENQUEUE procedure 1
  • error handlers
    • LOB assembly 1
  • error queue
    • heterogeneous environments 1
  • Export
    • Oracle Streams 1

F

  • flashback queries
    • Streams replication 1

G

  • GET_MESSAGE_TRACKING function 1
  • GET_SCN_MAPPING procedure 1 , 2
  • GET_TAG function 1 , 2
  • global name
    • best practices 1
    • capture process
      • changing 1
  • GRANT_REMOTE_ADMIN_ACCESS procedure 1

H

  • heartbeat table
    • Streams best practices 1
  • heterogeneous information sharing
    • non-Oracle to non-Oracle 1
    • non-Oracle to Oracle
      • apply process 1
      • capturing changes 1
      • instantiation 1
      • user application 1
    • Oracle to non-Oracle
      • apply process 1
      • capture process 1
      • database links 1
      • data types applied 1
      • DML changes 1
      • DML handlers 1
      • error handlers 1
      • errors 1
      • instantiation 1
      • message handlers 1
      • staging 1
      • substitute key columns 1 , 2 , 3 , 4 , 5
      • transformations 1
  • hub-and-spoke replication
    • configuring 1

I

  • Import
    • Oracle Streams 1
    • STREAMS_CONFIGURATION parameter 1
  • initialization parameters
    • LOG_ARCHIVE_DEST_n 1
    • LOG_ARCHIVE_DEST_STATE_n 1
  • instantiation
    • aborting preparation 1
    • database 1
    • Data Pump 1
    • example
      • Data Pump export/import 1
      • RMAN CONVERT DATABASE 1
      • RMAN DUPLICATE 1
      • RMAN TRANSPORT TABLESPACE 1
      • transportable tablespace 1
    • heterogeneous environments
      • non-Oracle to Oracle 1
      • Oracle to non-Oracle 1
    • monitoring 1
    • Oracle Streams 1
    • preparation for 1
    • preparing for 1 , 2
    • RMAN 1
    • setting an SCN
      • DDL LCRs 1
      • export/import 1
    • supplemental logging specifications 1
  • instantiation SCN
    • best practices 1
    • setting 1

L

  • LCRs
    • See: logical change records
  • LOB assembly 1
  • LOBs
    • Oracle Streams
      • apply process 1
  • LOG_ARCHIVE_DEST_n initialization parameter 1
  • LOG_ARCHIVE_DEST_STATE_n initialization parameter 1
  • logical change records (LCRs)
    • constructing 1
    • enqueuing 1
    • executing
      • DDL LCRs 1
      • row LCRs 1
    • LOB columns
      • apply process 1
      • requirements 1
    • LONG columns
      • requirements 1
    • LONG RAW columns
      • requirements 1
    • managing 1
    • requirements 1
    • tracking 1
    • XMLType 1
  • log sequence number
    • Streams capture process 1
  • LONG data type
    • Oracle Streams 1
  • LONG RAW data type
    • Oracle 1

M

  • MAINTAIN_GLOBAL procedure 1 , 2
  • MAINTAIN_SCHEMAS procedure 1 , 2 , 3 , 4 , 5
  • MAINTAIN_SIMPLE_TTS procedure 1 , 2
  • MAINTAIN_TABLES procedure 1 , 2
  • MAINTAIN_TTS procedure 1 , 2
  • MAXIMUM conflict resolution handler
    • latest time 1
  • MEMORY_MAX_TARGET initialization parameter 1
  • MEMORY_TARGET initialization parameter 1
  • MERGE_STREAMS_JOB procedure 1
  • MERGE_STREAMS procedure 1
  • merge streams 1
  • message_tracking_frequency capture process parameter 1
  • message tracking 1
  • MINIMUM conflict resolution handler 1
  • monitoring
    • apply process
      • update conflict handlers 1
    • comparisons 1
    • conflict detection 1
    • instantiation 1
    • tags
      • apply process value 1
      • current session value 1

N

  • n-way replication 1 , 2 , 3 , 4

O

  • objects
    • adding for replication 1 , 2 , 3
  • oldest SCN
    • point-in-time recovery 1
  • one-way replication 1
  • optimizer
    • statistics collection
      • best practices 1
  • Oracle Database Gateways
    • Oracle Streams 1
  • Oracle Data Pump
    • Import utility
      • STREAMS_CONFIGURATION parameter 1
    • instantiations 1
    • Streams instantiation 1
  • Oracle Real Application Clusters
    • Streams best practices
      • archive log threads 1
      • global name 1
      • propagations 1
      • queue ownership 1
  • Oracle Streams
    • conflict resolution 1
    • DBMS_COMPARISON package 1
    • Export utility 1
    • heterogeneous information sharing 1
    • Import utility 1
    • instantiation 1 , 2
    • LOBs 1
    • logical change records (LCRs)
      • managing 1
    • LONG data type 1
    • Oracle Database Gateways 1
    • point-in-time recovery 1
    • replication
      • adding databases 1 , 2
      • adding objects 1 , 2 , 3
      • adding to 1
      • best practices 1
      • configuring 1 , 2
      • managing 1
      • sequences 1
    • rules 1
    • sequences 1
    • tags 1
    • XMLType 1
  • Oracle Streams Performance Advisor 1
  • OVERWRITE conflict resolution handler 1

P

  • performance
    • Oracle Streams 1
  • point-in-time recovery
    • Oracle Streams 1
  • POST_INSTANTIATION_SETUP procedure 1 , 2 , 3
  • PRE_INSTANTIATION_SETUP procedure 1 , 2 , 3
  • PREPARE_GLOBAL_INSTANTIATION procedure 1 , 2
  • PREPARE_SCHEMA_INSTANTIATION procedure 1 , 2
  • PREPARE_SYNC_INSTANTIATION function 1 , 2
  • PREPARE_TABLE_INSTANTIATION procedure 1 , 2
  • propagation
    • best practices
      • broken propagations 1
      • configuration 1
      • propagation latency 1
      • propagation operation 1
      • queue-to-queue propagation 1
      • restarting propagation 1
      • SDU 1
  • propagation jobs
    • managing 1
  • propagations
    • creating 1 , 2
    • managing 1
  • PURGE_COMPARISON procedure 1

Q

  • queues
    • ANYDATA
      • creating 1
    • commit-time 1
    • creating 1
    • size
      • best practices 1
    • transactional 1
  • queue-to-queue propagation
    • best practices 1

R

  • RECHECK function 1
  • RECOVER_OPERATION procedure 1
  • Recovery Manager
    • CONVERT DATABASE command
      • Streams instantiation 1
    • DUPLICATE command
      • Streams instantiation 1
    • Streams instantiation 1
    • TRANSPORT TABLESPACE command
      • Streams instantiation 1
  • replication
    • adding databases 1 , 2
    • adding objects 1 , 2 , 3
    • adding to 1
    • bi-directional 1 , 2
    • configuration errors
      • recovering 1
    • configuring
      • apply handlers 1
      • ARCHIVELOG mode 1
      • bi-directional 1 , 2
      • database 1
      • database links 1
      • DBMS_STREAMS_ADM package 1
      • DDL changes 1
      • directory objects 1
      • downstream capture 1 , 2 , 3
      • hub-and-spoke 1 , 2 , 3
      • initialization parameters 1
      • instantiation 1
      • local capture 1 , 2
      • log file transfer 1
      • multiple-source environment 1
      • n-way 1 , 2
      • one-way 1
      • Oracle Enterprise Manager Cloud Control 1
      • Oracle Streams pool 1
      • preparation 1
      • schemas 1 , 2 , 3 , 4
      • scripts 1
      • single-source environment 1
      • standby redo logs 1
      • supplemental logging 1
      • tables 1
      • tablespace 1
      • tablespaces 1
      • tags 1
    • hub-and-spoke 1 , 2
    • managing 1
    • n-way 1 , 2
    • one-way 1 , 2
    • Oracle Streams
      • best practices 1
      • configuring 1
      • hub-and-spoke 1
      • managing 1
      • n-way 1
      • two-database 1 , 2
    • sequences 1
    • split and merge 1
  • resolution columns 1
  • rule-based transformations 1
  • rules
    • system-created
      • tags 1

S

  • SDU
    • Streams best practices 1
  • sequences
    • replication 1
  • SET_DML_HANDLER procedure 1
  • SET_GLOBAL_INSTANTIATION_SCN procedure 1 , 2
  • SET_MESSAGE_TRACKING procedure 1
  • SET_SCHEMA_INSTANTIATION_SCN procedure 1 , 2
  • SET_TABLE_INSTANTIATION_SCN procedure 1 , 2
  • SET_TAG procedure 1 , 2
  • SET_UP_QUEUE procedure 1
  • SET_UPDATE_CONFLICT_HANDLER procedure
    • modifying an update conflict handler 1
    • removing an update conflict handler 1
    • setting an update conflict handler 1
  • SGA_TARGET initialization parameter 1
  • SPLIT_STREAMS procedure 1
  • split streams 1
  • staging
    • heterogeneous environments 1
  • START_APPLY procedure 1
  • statistics
    • Oracle Streams 1
  • STREAMS_CONFIGURATION parameter
    • Data Pump Import utility 1
    • Import utility 1
  • Streams pool
    • MEMORY_MAX_TARGET initialization parameter 1
    • MEMORY_TARGET initialization parameter 1
    • SGA_TARGET initialization parameter 1
  • STRMMON 1
  • supplemental logging
    • column lists 1
    • instantiation 1
    • preparation for instantiation 1 , 2
  • synchronous capture
    • best practices
      • configuration 1
    • configuring 1 , 2
    • preparing for 1
  • system change numbers (SCN)
    • oldest SCN for an apply process
      • point-in-time recovery 1

T

  • tags
    • ALTER_APPLY procedure 1 , 2
    • apply process 1
    • avoiding change cycling 1
    • change cycling
      • avoidance 1
    • CONVERGE procedure 1
    • converging data 1
    • CREATE_APPLY procedure 1 , 2
    • examples 1
    • getting value for current session 1
    • hub-and-spoke replication 1
    • managing 1
    • monitoring
      • apply process value 1
      • current session value 1
    • n-way replication 1
    • online backups 1
    • removing value for apply process 1
    • rules
      • include_tagged_lcr parameter 1
    • SET_TAG procedure 1
    • setting value for apply process 1
    • setting value for current session 1
  • tracking LCRs 1
  • transformations
    • heterogeneous environments
      • Oracle to non-Oracle 1
    • rule-based 1
  • transportable tablespace
    • Streams instantiation 1
  • two-database replication
    • configuring
      • synchronous capture 1

V

  • V$STREAMS_MESSAGE_TRACKING view 1
  • V$STREAMS_POOL_ADVICE view 1
  • V$STREAMS_TRANSACTION view 1

X

  • XMLType
    • logical change records (LCRs) 1