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
    • name-value pairs
      • adding 1 , 2 , 3
      • altering 1
      • removing 1 , 2
    • querying 1
    • system-created rules 1
  • ADD_COLUMN procedure 1 , 2
  • ADD_GLOBAL_RULES procedure 1
  • ADD_PAIR member procedure 1 , 2 , 3 , 4
  • ADD_RULE procedure 1 , 2
  • ADD_SCHEMA_PROPAGATION_RULES procedure 1
  • ADD_SUBSCRIBER procedure 1
  • ADD_SUBSET_PROPAGATION_RULES procedure
    • row migration 1
  • ADD_SUBSET_RULES procedure
    • row migration 1
  • ADD_TABLE_RULES procedure 1
  • alert log
    • Oracle Streams entries 1
  • alerts 1
  • ALTER_APPLY procedure
    • removing a rule set 1
    • removing the DDL handler 1
    • setting an apply user 1
    • setting the DDL handler 1
    • setting the message handler 1
    • setting the precommit handler 1
    • specifying a rule set 1
    • unsetting the message handler 1
    • unsetting the precommit handler 1
  • ALTER_CAPTURE procedure
    • removing a rule set 1
    • setting a capture user 1
    • setting the first SCN 1
    • specifying a rule set 1 , 2
    • specifying database link use 1
  • ALTER_PROPAGATION_SCHEDULE procedure 1
  • ALTER_PROPAGATION procedure
    • removing the rule set 1
    • specifying the rule set 1
  • ALTER_RULE procedure 1
  • ALTER_SYNC_CAPTURE procedure
    • setting a capture user 1
  • ANALYZE_CURRENT_PERFORMANCE procedure 1
  • ANALYZE_CURRENT_STATISTICS procedure 1
  • ANYDATA data type
    • queues
      • monitoring 1
      • removing 1
    • wrapper for messages 1
  • applications
    • upgrading
      • using Streams 1
  • applied SCN 1 , 2 , 3
  • apply forwarding 1
  • apply process
    • applied SCN 1
    • apply forwarding 1
    • apply handlers
      • Java stored procedures 1
    • apply servers
      • states 1
      • troubleshooting 1
    • apply user
      • privileges 1
      • secure queues 1
      • setting 1
    • architecture 1
    • combined capture and apply
      • query to determine 1
    • conflict handlers 1
    • conflict resolution 1
    • constraints 1
    • contention 1 , 2
    • coordinator process
      • states 1
    • creating 1
    • data type conversion 1
    • data types 1
    • data types applied
      • automatic conversion 1
    • DDL changes
      • containing DML changes 1
      • CREATE TABLE AS SELECT 1
      • current schema 1
      • data structures 1
      • derived values in DML 1
      • DML triggers 1
      • ignored 1
      • system-generated names 1
    • DDL handlers
      • managing 1
      • monitoring 1
    • dependencies
      • barrier transactions 1
      • troubleshooting 1
      • virtual dependency definitions 1 , 2 , 3
    • DML changes 1
    • DML handlers
      • change handlers 1
    • dropping 1
    • enqueuing messages
      • monitoring 1
    • error handlers
      • managing 1
      • monitoring 1
    • error queue
      • monitoring 1 , 2
    • high-watermark 1
    • ignore SCN 1
    • index-organized tables 1
    • instantiation SCN 1
    • interoperation with capture processes 1 , 2
    • key columns 1
    • low-watermark 1
    • managing 1
    • message handlers
      • managing 1
      • monitoring 1
    • messages
      • captured LCRs 1
      • persistent LCRs 1
      • user messages 1
    • monitoring
      • apply handlers 1
      • compatible columns 1
      • latency 1 , 2
      • transactions 1
    • non-LCR messages 1
    • oldest SCN 1
    • options 1
    • Oracle Label Security (OLS) 1
    • Oracle Real Application Clusters 1
    • parallelism 1
    • parameters
      • commit_serialization 1
      • parallelism 1
      • preserve_encryption 1
      • setting 1
      • txn_lcr_spill_threshold 1
    • performance 1
    • persistent status 1
    • precommit handlers
      • managing 1
      • monitoring 1
    • reader server
      • states 1
    • RESTRICTED SESSION 1
    • row subsetting 1
    • rules
      • adding 1
      • removing 1
    • rule sets
      • removing 1
      • specifying 1
    • session information 1
    • specifying execution
      • monitoring 1
    • spilled messages 1
    • SQL generation 1
    • starting 1
    • stopping 1
    • substitute key columns
      • removing 1
      • setting 1
    • tables
      • apply handlers 1
      • column discrepancies 1
    • trace files 1
    • transformations
      • rule-based 1
    • Transparent Data Encryption 1
    • triggers
      • firing property 1
      • ON SCHEMA clause 1
    • troubleshooting
      • checking apply handlers 1
      • checking message type 1
      • checking status 1
      • error queue 1
  • approximate CSCN 1
  • AQ_TM_PROCESSES initialization parameter
    • Streams apply process 1
  • ARCHIVELOG mode
    • capture process
      • Recovery Manager 1
  • ATTACH_TABLESPACES procedure 1

B

  • buffered messaging 1
  • buffered queues
    • monitoring
      • apply processes 1
      • capture processes 1
      • propagations 1 , 2 , 3 , 4 , 5
    • Transparent Data Encryption 1
  • BUILD procedure
    • troubleshooting 1

C

  • capture
    • explicit 1
  • captured LCRs 1
  • captured SCN 1
  • capture process
    • applied SCN 1 , 2
    • architecture 1
    • ARCHIVELOG mode 1
    • automatically filtered changes 1
    • builder server 1
    • captured LCRs 1
    • captured SCN 1
    • capture user
      • secure queues 1
      • setting 1
    • changes captured
      • DDL changes 1
      • DML changes 1
      • NOLOGGING keyword 1
      • UNRECOVERABLE clause for SQL*Loader 1
      • UNRECOVERABLE SQL keyword 1
    • checkpoints
      • managing retention time 1
      • maximum checkpoint SCN 1
      • required checkpoint SCN 1 , 2
      • retention time 1
    • combined capture and apply
      • query to determine 1
    • creating 1
    • data type restrictions 1
    • data types captured 1
    • downstream capture
      • advantages 1
      • database link 1 , 2
      • monitoring 1
      • monitoring remote access 1
      • operational requirements 1
    • dropping 1
    • fast recovery area 1
    • first SCN
      • setting 1
    • index-organized tables 1 , 2
    • interoperation with apply processes 1 , 2
    • latency
      • capture to apply 1
      • redo log scanning 1
    • local capture
      • advantages 1
    • LogMiner
      • data dictionary 1
      • multiple sessions 1
    • managing 1
    • maximum checkpoint SCN 1 , 2
    • monitoring
      • applied SCN 1
      • compatible tables 1
      • downstream capture 1
      • elapsed time 1
      • last redo entry 1
      • latency 1 , 2 , 3
      • message creation time 1
      • old log files 1
      • registered log files 1 , 2
      • required log files 1
      • rule evaluations 1
      • state change time 1
    • online redefinition 1
    • Oracle Label Security (OLS) 1
    • Oracle Real Application Clusters 1
    • parameters
      • parallelism 1
      • set_autofiltered_table_ddl 1
      • setting 1
      • time_limit 1
    • PAUSED FOR FLOW CONTROL state 1
    • persistent status 1
    • preparer servers 1
    • reader server 1
    • Recovery Manager
      • fast recovery area 1
    • redo logs
      • adding manually 1
      • missing files 1
    • redo transport services 1
    • required checkpoint SCN 1
    • RESTRICTED SESSION 1
    • rule evaluation 1
    • rules
      • adding 1
      • removing 1
    • rule sets
      • removing 1
      • specifying 1
    • session information 1
    • SGA_MAX_SIZE initialization parameter 1
    • starting 1
    • start SCN 1 , 2
    • states 1
    • stopping 1
    • supplemental logging 1
    • switching to 1
    • SYS schema 1
    • SYSTEM schema 1
    • table type restrictions 1
    • trace files 1
    • transformations
      • rule-based 1
    • Transparent Data Encryption 1
    • troubleshooting
      • checking progress 1
      • checking status 1
      • creation 1
  • capture user
    • capture process 1
    • synchronous capture 1
  • change handlers
    • about 1
    • change tables
      • maintaining 1
      • monitoring 1
    • configuration options 1
    • configuring 1
    • KEEP_COLUMNS transformations 1
    • managing 1
    • monitoring 1
    • preparing for 1
    • prerequisites 1
    • replication 1
    • setting 1
    • unsetting 1
    • using existing components 1
  • character sets
    • migrating
      • using Streams 1
  • checkpoints
    • retention time
      • managing 1
  • CLONE_TABLESPACES procedure 1
  • combined capture and apply
    • apply process
      • query to determine 1
    • capture process
      • query to determine 1
    • propagation
      • query to determine 1 , 2
    • stream paths 1
    • topology 1
  • COMPATIBLE_10_1 function 1
  • COMPATIBLE_10_2 function 1
  • COMPATIBLE_11_1 function 1
  • COMPATIBLE_11_2 function 1
  • COMPATIBLE_9_2 function 1
  • conditions
    • rules 1
  • configuration report script
    • Oracle Streams 1
  • conflict resolution
    • conflict handlers
      • interaction with apply handlers 1
  • CONTROL_FILE_RECORD_KEEP_TIME parameter 1
  • CREATE_APPLY procedure 1
  • CREATE_CAPTURE procedure 1
  • CREATE_RULE_SET procedure 1
  • CREATE_RULE procedure 1
  • CREATE TABLE statement
    • AS SELECT
      • apply process 1

D

  • database maintenance
    • using Streams
      • assumptions 1
      • capture database 1
      • instantiation 1
      • job slaves 1
      • logical dependencies 1
      • PL/SQL package subprograms 1
      • user-created applications 1
      • user-defined types 1
  • data types
    • applied
      • automatic conversion 1
  • DBA_APPLY_CHANGE_HANDLERS view 1 , 2
  • DBA_APPLY_DML_HANDLERS view 1 , 2
  • DBA_APPLY_ENQUEUE view 1
  • DBA_APPLY_ERROR view 1 , 2
  • DBA_APPLY_EXECUTE view 1
  • DBA_APPLY_KEY_COLUMNS view 1
  • DBA_APPLY_PARAMETERS view 1
  • DBA_APPLY_PROGRESS view 1
  • DBA_APPLY_SPILL_TXN view 1
  • DBA_APPLY view 1 , 2 , 3 , 5 , 6 , 7 , 8
  • DBA_CAPTURE_EXTRA_ATTRIBUTES view 1
  • DBA_CAPTURE_PARAMETERS view 1
  • DBA_CAPTURE view 1 , 2 , 3 , 4 , 5 , 6 , 7
  • DBA_EVALUATION_CONTEXT_TABLES view 1
  • DBA_EVALUATION_CONTEXT_VARS view 1
  • DBA_FILE_GROUP_EXPORT_INFO view 1
  • DBA_FILE_GROUP_FILES view 1
  • DBA_FILE_GROUP_TABLESPACES view 1
  • DBA_FILE_GROUP_TABLES view 1
  • DBA_FILE_GROUP_VERSOINS view 1
  • DBA_FILE_GROUPS view 1
  • DBA_LOG_GROUPS view 1
  • DBA_LOGMNR_PURGED_LOG view 1 , 2
  • DBA_PROPAGATION view 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11
  • DBA_QUEUE_SCHEDULES view 1 , 2
  • DBA_QUEUE_TABLES view 1
  • DBA_QUEUES view 1
  • DBA_REGISTERED_ARCHIVED_LOG view 1 , 2 , 3
  • DBA_RULE_SET_RULES view 1 , 2
  • DBA_RULE_SETS view 1
  • DBA_RULES view 1 , 2 , 3
  • DBA_STREAMS_ADD_COLUMN view 1
  • DBA_STREAMS_COLUMNS view 1 , 2
  • DBA_STREAMS_NEWLY_SUPPORTED view 1
  • DBA_STREAMS_RENAME_TABLE view 1
  • DBA_STREAMS_RULES view 1 , 2
  • DBA_STREAMS_TABLE_RULES view 1
  • DBA_STREAMS_TP_COMPONENT_LINK view 1 , 2
  • DBA_STREAMS_TP_COMPONENT_STAT view 1 , 2
  • DBA_STREAMS_TP_COMPONENT view 1 , 2
  • DBA_STREAMS_TP_DATABASE view 1 , 2
  • DBA_STREAMS_TP_PATH_BOTTLENECK view 1 , 2
  • DBA_STREAMS_TP_PATH_STAT view 1 , 2
  • DBA_STREAMS_TRANSFORM_FUNCTION view 1
  • DBA_STREAMS_TRANSFORMATIONS view 1 , 2
  • DBA_STREAMS_UNSUPPORTED view 1
  • DBA_SYNC_CAPTURE_TABLES view 1
  • DBA_SYNC_CAPTURE view 1
  • DBMS_APPLY_ADM package 1 , 2
  • DBMS_CAPTURE_ADM package 1 , 2
  • DBMS_COMPARISON package 1
  • DBMS_PROPAGATION_ADM package
    • starting a propagation 1
    • stopping a propagation 1
  • DBMS_RULE_ADM package 1 , 2
  • DBMS_RULE package 1 , 2
  • DBMS_STREAMS_ADM package
    • creating a capture process 1
    • creating an apply process 1
  • DBMS_STREAMS_ADVISOR_ADM package
    • gathering information 1
  • DBMS_STREAMS_AUTH package 1
  • DBMS_STREAMS_HANDLER_ADM package 1
  • DBMS_STREAMS_MESSAGING package 1
  • DBMS_STREAMS_TABLESPACE_ADM package
    • information provisioning
      • platform conversion 1
  • DBMS_STREAMS package 1
  • DDL handlers
    • creating 1
    • managing 1
    • monitoring 1
    • removing 1
    • setting 1
  • DELETE_ALL_ERRORS procedure 1
  • DELETE_COLUMN procedure 1
  • DELETE_ERROR procedure 1 , 2
  • dependencies
    • apply processes 1
    • queues 1
  • dequeue high-watermark 1
  • destination queue 1
  • DETACH_TABLESPACES procedure 1
  • directed networks
    • apply forwarding 1
    • queue forwarding 1
  • direct path load
    • capture processes 1
  • DISABLE_DB_ACCESS procedure 1
  • DML handlers
    • change handlers 1 , 2
    • managing 1
    • monitoring 1
    • procedure DML handlers
      • managing 1
      • monitoring 1
    • statement DML handlers
      • managing 1
      • monitoring 1
    • unsetting 1
  • documentation
    • Oracle Streams 1
  • DROP_APPLY procedure 1
  • DROP_CAPTURE procedure 1 , 2
  • DROP_PROPAGATION procedure 1
  • DROP_RULE_SET procedure 1
  • DROP_RULE procedure 1

E

  • ENABLE_DB_ACCESS procedure 1
  • error handlers
    • creating 1
    • managing 1
    • monitoring 1
    • setting 1
    • unsetting 1
  • error queue
    • apply process 1
    • deleting errors 1
    • executing errors 1
    • monitoring 1 , 2
    • Transparent Data Encryption 1
  • EVALUATE procedure 1
  • evaluation contexts
    • association with rules 1
    • association with rule sets 1
    • evaluation function 1
    • object privileges
      • granting 1
      • revoking 1
    • system privileges
      • granting 1
      • revoking 1
    • user-created 1 , 2
    • variables 1
  • event contexts
    • system-created rules 1
  • EXECUTE_ALL_ERRORS procedure 1
  • EXECUTE_ERROR procedure 1 , 2
  • EXECUTE member procedure 1 , 2
  • explicit capture
    • features 1
    • message types 1
    • Transparent Data Encryption 1
  • explicit consumption
    • dequeue 1
  • Export
    • database maintenance 1
    • database upgrade 1
    • Oracle Streams 1

F

  • fast recovery area
    • capture processes
      • archived redo log files 1
  • file group repositories
    • monitoring 1 , 2
    • using 1
  • first SCN 1
  • flashback data archive
    • Oracle Streams 1
  • flow control 1

G

  • GET_BASE_TABLE_NAME member function 1
  • GET_COMMA 1
  • GET_COMMAND_TY 1
  • GET_COMMAND_TYPE member function 1 , 2
  • GET_COMPATIBLE member function 1
  • GET_DDL_TEXT member function 1
  • GET_ERROR_MESSAGE function 1
  • GET_INFORMATION function 1
  • GET_NEXT_HIT function 1
  • GET_OBJECT_NAME member function 1 , 2 , 3 , 4
  • GET_OBJECT_OWNER member function 1 , 2 , 3
  • GET_SCN member function 1
  • GET_SOURCE_DATABASE_NAME member function 1 , 2
  • GET_STREAMS_NAME function 1
  • GET_TAG member function 1
  • GET_TRANSACTION_ID member function 1
  • GET_VALUE member function
    • LCRs 1
  • GET_VALUES member function 1 , 2
  • GLOBAL_NAME view 1 , 2
  • GRANT_OBJECT_PRIVILEGE procedure 1
  • GRANT_SYSTEM_PRIVILEGE procedure 1
  • grids
    • information provisioning 1

H

  • health check script
    • Oracle Streams 1
  • high availability
    • Streams
      • advantages 1
      • apply 1
      • best practices 1
      • capture 1
      • database links 1
      • propagation 1
  • high-watermark 1

I

  • ignore SCN 1
  • implicit capture
    • managing 1
    • switching mechanisms 1 , 2
  • Import
    • database maintenance 1
    • database upgrade 1
    • Oracle Streams 1
  • INCLUDE_EXTRA_ATTRIBUTE procedure 1 , 2
  • index-organized tables
    • apply process 1
    • capture process 1 , 2
    • synchronous capture 1 , 2
  • in-flight transactions 1
  • information provisioning
    • bulk provisioning
      • Data Pump 1
    • DBMS_STREAMS_TABLESPACE_ADM package 1
    • file group repositories 1
    • incremental provisioning 1
    • on-demand information access 1
    • RMAN
      • transportable tablespace from backup 1
    • tablespace repositories 1
    • using 1
  • initialization parameters
    • AQ_TM_PROCESSES
      • Streams apply process 1
  • instantiation
    • example
      • RMAN CONVERT DATABASE 1
      • RMAN DUPLICATE 1 , 2
    • export/import 1 , 2
    • in Streams 1
    • RMAN CONVERT DATABASE 1
    • RMAN DUPLICATE 1 , 2
  • instantiation SCN 1
  • interoperability
    • compatibility 1
    • Streams 1
  • IS_NULL_TAG member function 1
  • IS_TRIGGER_FIRE_ONCE function 1

K

  • KEEP_COLUMNS procedure 1
  • keystores
    • Oracle Streams 1

L

  • LCRs
    • See: logical change records
  • logical change records (LCRs)
    • DDL LCRs
      • current_schema 1
      • rules 1 , 2
    • extra attributes
      • managing 1
      • monitoring 1
    • getting information about
      • compatibility 1
    • row LCRs
      • rules 1
    • XML schema 1
  • LogMiner
    • capture process 1
    • multiple sessions 1
  • low-watermark 1

M

  • MAINTAIN_CHANGE_TABLE procedure
    • examples 1
    • preparing for 1
    • prerequisites 1
  • MAX_COMPATIBLE function 1
  • maximum checkpoint SCN 1
  • MERGE_STREAMS_JOB procedure 1
  • merge streams 1
  • message handlers
    • managing 1
    • monitoring 1
    • setting 1
    • unsetting 1
  • messages
    • captured 1
    • captured LCRs 1
    • dequeue 1
    • enqueue 1
    • persistent LCRs 1 , 2
    • persistent user messages 1
    • propagation 1
    • user messages 1 , 2
  • messaging
    • buffered messaging 1
    • dequeue
      • Transparent Data Encryption 1
    • enqueue 1
  • messaging client
    • messaging client user
      • secure queues 1
    • transformations
      • rule-based 1
  • messaging clients
    • transparent data encryption 1
    • Transparent Data Encryption 1
  • migrating
    • to different character set
      • using Streams 1
    • to different operating system
      • using Streams 1
  • monitoring
    • ANYDATA data type queues
      • message consumers 1
      • viewing event contents 1
    • apply process
      • apply handlers 1
      • compatible columns 1
      • DDL handlers 1
      • error handlers 1
      • error queue 1 , 2
      • message handlers 1
    • capture process
      • applied SCN 1
      • compatible tables 1
      • elapsed time 1
      • latency 1 , 2 , 3
      • message creation time 1
      • rule evaluations 1
      • state change time 1
    • compatibility 1
    • DML handlers 1
    • file group repositories 1
    • Oracle Streams
      • performance 1 , 2
    • propagation jobs 1
    • propagations 1 , 2
    • queues 1
    • rule-based transformations 1
    • rules 1
    • supplemental logging 1
    • synchronous capture
      • compatible columns 1
      • latency 1
    • tablespace repositories 1
  • multitenant container databases (CDBs) 1
  • multi-version data dictionary
    • missing 1

N

  • NOLOGGING mode
    • capture process 1

O

  • oldest SCN 1
  • online redefinition
    • capture process 1
    • synchronous capture 1
  • ON SCHEMA clause
    • of CREATE TRIGGER
      • apply process 1
  • operating systems
    • migrating
      • using Streams 1
  • ORA-01291 error 1
  • ORA-01403 error 1
  • ORA-06550 error 1
  • ORA-23605 error 1
  • ORA-23607 error 1
  • ORA-24031 error 1
  • ORA-24093 error 1
  • ORA-25224 error 1
  • ORA-26666 error 1
  • ORA-26678 error 1
  • ORA-26687 error 1
  • ORA-26688 error 1
  • ORA-26689 error 1
  • Oracle Database Vault
    • Oracle Streams 1
  • Oracle Data Pump
    • information provisioning 1
  • Oracle Enterprise Manager Cloud Control
    • Streams tool 1
  • Oracle Label Security (OLS)
    • apply processes 1
    • capture processes 1
    • synchronous captures 1
  • Oracle Real Application Clusters
    • interoperation with Oracle Streams 1 , 2 , 3 , 4 , 5
    • queues 1
  • Oracle Scheduler
    • propagation jobs 1
  • Oracle Streams
    • administrator
      • monitoring 1
    • alert log 1
    • alerts 1
    • apply process 1 , 2
    • capture process 1 , 2 , 3 , 4
    • compatibility 1 , 2
    • database maintenance 1
    • data dictionary 1 , 2 , 3
    • directed networks 1
    • documentation roadmap 1
    • Export utility 1
    • flashback data archive 1
    • health check script 1
    • high availability 1
    • Import utility 1
    • information provisioning 1
    • instantiation 1
    • interoperability 1
    • interoperation with Oracle Real Application Clusters 1
    • interoperation with Transparent Data Encryption 1
    • logical change records (LCRs)
      • XML schema 1
    • LogMiner data dictionary 1
    • messaging 1
    • messaging clients 1
    • monitoring 1
    • Oracle Database Vault 1
    • overview 1
    • packages 1
    • propagation
      • Oracle Real Application Clusters 1
    • queues
      • Oracle Real Application Clusters 1
    • restrictions 1
    • rules
      • action context 1
      • evaluation context 1 , 2
      • event context 1
      • subset rules 1 , 2
      • system-created 1
    • staging
      • Oracle Real Application Clusters 1
    • Streams data dictionary 1
    • Streams pool
      • monitoring 1
    • Streams tool 1
    • supplemental logging 1
    • synchronous capture 1
    • tags 1
    • topology 1
    • trace files 1
    • transformations
      • rule-based 1
    • Transparent Data Encryption 1
    • troubleshooting 1 , 2 , 3 , 4 , 5
    • upgrading online 1 , 2
    • user messages 1
  • Oracle Streams Performance Advisor
    • gathering information 1
    • Streams components 1
    • viewing statistics
      • bottleneck components 1
      • component-level 1
      • latency 1
      • rates 1
      • session-level 1
      • stream paths 1

P

  • patches
    • applying
      • using Streams 1
  • performance
    • Oracle Streams Performance Advisor
      • gathering information 1
      • Streams components 1
      • viewing statistics 1
  • persistent LCRs 1
  • persistent user messages 1
  • pluggable databases (PDBs) 1
  • POST_INSTANTIATION_SETUP procedure 1
  • PRE_INSTANTIATION_SETUP procedure 1
  • precommit handlers
    • creating 1
    • managing 1
    • monitoring 1
    • setting 1
    • unsetting 1
  • prepare SCN 1
  • privileges
    • Oracle Streams administrator
      • monitoring 1
    • rules 1
  • procedure DML handlers
    • creating 1
    • managing 1
    • monitoring 1
    • setting 1
    • SQL generation 1
    • unsetting 1
  • propagation
    • combined capture and apply
      • query to determine 1 , 2
    • propagation receivers 1
    • propagation senders 1
  • propagation jobs
    • altering 1
    • managing 1
    • monitoring 1
    • Oracle Scheduler 1
    • RESTRICTED SESSION 1
    • scheduling 1
    • trace files 1
    • troubleshooting 1
  • propagations
    • binary files 1
    • buffered queues 1
    • destination queue 1
    • directed networks 1
    • dropping 1
    • ensured delivery 1
    • managing 1
    • monitoring 1 , 2
    • queue-to-queue
      • Oracle Real Application Clusters 1
      • propagation job 1
      • schedule 1
    • rules
      • adding 1
      • removing 1
    • rule sets
      • removing 1
      • specifying 1
    • session information 1
    • source queue 1
    • starting 1
    • stopping 1
    • transformations
      • rule-based 1
    • Transparent Data Encryption 1
    • troubleshooting
      • checking queues 1
      • checking status 1
      • security 1

Q

  • queue forwarding 1
  • queues
    • ANYDATA
      • removing 1
    • browsing 1
    • buffered 1
    • commit-time 1
    • dependencies 1
    • dequeue high-watermark 1
    • monitoring 1
    • nontransactional 1
    • Oracle Real Application Clusters 1
    • queue tables
      • triggers 1
    • secure
      • disabling user access 1
      • enabling user access 1
      • users 1
    • synchronous capture 1
    • transactional 1
    • typed 1
  • queue-to-queue propagations
    • schedule 1

R

  • RE$NV_LIST type
    • ADD_PAIR member procedure 1 , 2 , 3 , 4
    • REMOVE_PAIR member procedure 1 , 2 , 3 , 4
  • Recovery Manager
    • capture processes
      • archived redo log files 1
      • fast recovery area 1
    • CONVERT DATABASE command
      • Streams instantiation 1 , 2
    • DUPLICATE command
      • Streams instantiation 1 , 2 , 3 , 4
    • information provisioning 1
  • redo logs
    • capture process 1
  • REMOVE_PAIR member procedure 1 , 2 , 3 , 5
  • REMOVE_QUEUE procedure 1
  • REMOVE_RULE procedure 1 , 2 , 3 , 4
  • RENAME_COLUMN procedure 1 , 2
  • RENAME_SCHEMA procedure 1
  • RENAME_TABLE procedure 1 , 2 , 3
  • replication
    • split and merge 1
  • required checkpoint SCN 1
  • RESTRICTED SESSION system privilege
    • apply processes 1
    • capture processes 1
    • propagation jobs 1
  • REVOKE_OBJECT_PRIVILEGE procedure 1
  • REVOKE_SYSTEM_PRIVILEGE procedure 1
  • RMAN
    • See: Recovery Manager
  • row migration 1
  • rule-based transformations
    • custom
      • action contexts 1
      • altering 1
      • creating 1
      • managing 1
      • monitoring 1
      • privileges 1
      • removing 1
    • declarative
      • adding 1
      • managing 1
      • monitoring 1
      • removing 1
      • step number 1
      • troubleshooting 1
    • managing 1
    • monitoring 1
    • ordering 1
  • rules
    • action contexts
      • adding name-value pairs 1 , 2 , 3 , 4
      • altering 1
      • removing name-value pairs 1 , 2 , 3
      • transformations 1
    • ADD_RULE procedure 1
    • altering 1
    • apply process 1 , 2
    • capture process 1 , 2
    • components 1
    • creating 1
    • DBMS_RULE_ADM package 1
    • DBMS_RULE package 1
    • dropping 1
    • EVALUATE procedure 1
    • evaluation
      • capture process 1
      • iterators 1
      • partial 1
    • evaluation contexts
      • evaluation function 1
      • user-created 1
      • variables 1
    • event context 1
    • explicit variables 1
    • implicit variables 1
    • iterative results 1
    • managing 1
    • MAYBE rules 1
    • monitoring 1
    • object privileges
      • granting 1
      • revoking 1
    • partial evaluation 1
    • privileges
      • managing 1
    • propagations 1 , 2
    • rule_hits 1
    • rule conditions
      • complex 1
      • explicit variables 1
      • finding patterns in 1
      • implicit variables 1
      • Streams compatibility 1
      • types of operations 1
      • undefined variables 1
      • using NOT 1
      • variables 1
    • simple rules 1
    • subset
      • querying for action context of 1
      • querying for names of 1
    • synchronous capture 1
    • system-created
      • action context 1
      • and_condition parameter 1
      • DDL rules 1 , 2
      • DML rules 1
      • evaluation context 1 , 2
      • event context 1
      • global 1
      • modifying 1
      • row migration 1
      • schema 1
      • STREAMS$EVALUATION_CONTEXT 1 , 2
      • subset 1 , 2
      • table 1
    • system privileges
      • granting 1
      • revoking 1
    • troubleshooting 1
    • TRUE rules 1
    • user-created 1
    • variables 1
  • rule sets
    • adding rules to 1
    • creating 1
    • dropping 1
    • evaluation
      • partial 1
    • negative 1
    • object privileges
      • granting 1
      • revoking 1
    • positive 1
    • removing rules from 1
    • system privileges
      • granting 1
      • revoking 1

S

  • scripts
    • Oracle Streams 1
  • secure queues
    • disabling user access 1
    • enabling user access 1
    • propagation 1
    • Streams clients
      • users 1
  • SET_CHANGE_HANDLER procedure 1
  • SET_DML_HANDLER procedure
    • setting a DML handler 1
    • setting an error handler 1
    • unsetting a DML handler 1
    • unsetting an error handler 1
  • SET_ENQUEUE_DESTINATION procedure 1
  • SET_EXECUTE procedure 1
  • SET_KEY_COLUMNS procedure
    • removing substitute key columns 1
    • setting substitute key columns 1
  • SET_PARAMETER procedure
    • apply process 1 , 2
    • capture process 1
  • SET_RULE_TRANSFORM_FUNCTION procedure 1
  • SET_TRIGGER_FIRING_PROPERTY procedure 1
  • SET_VALUE member procedure 1 , 2
  • SET_VALUES member procedure 1
  • SGA_MAX_SIZE initialization parameter 1
  • source queue 1
  • SPLIT_STREAMS procedure 1
  • split streams 1
  • SQL*Loader
    • capture processes 1
  • SQL generation
    • character sets 1
    • data types supported 1
    • examples 1 , 2
    • formats 1
    • interfaces 1
    • procedure DML handlers 1
  • staging
    • approximate CSCN 1
    • buffered queues
      • monitoring 1
    • management 1
    • messages 1
    • secure queues
      • disabling user access 1
      • enabling user access 1
  • START_APPLY procedure 1
  • START_CAPTURE procedure 1
  • START_PROPAGATION procedure 1
  • start SCN 1
  • statement DML handlers
    • adding statements to 1
    • creating 1
    • dropping 1
    • managing 1
    • modifying 1
    • monitoring 1
    • removing from apply process 1
    • removing statements from 1
  • Statspack
    • Oracle Streams 1
  • STOP_APPLY procedure 1
  • STOP_CAPTURE procedure 1
  • STOP_PROPAGATION procedure 1
  • stream paths
    • combined capture and apply 1
  • Streams
    • See: Oracle Streams
  • STREAMS$_EVALUATION_CONTEXT 1 , 2
  • STREAMS$_TRANSFORM_FUNCTION 1
  • Streams data dictionary 1 , 2 , 3
  • streams paths
    • statistics 1
  • Streams pool
    • monitoring 1
  • Streams tool 1
  • Streams topology
    • DBMS_STREAMS_ADVISOR_ADM package
      • gathering information 1
  • supplemental logging
    • conditional log groups 1
    • DBA_LOG_GROUPS view 1
    • monitoring 1
    • unconditional log groups 1
  • synchronous capture
    • capture user
      • setting 1
    • changes captured
      • DML changes 1
    • data type restrictions 1
    • data types captured 1
    • dropping 1
    • index-organized tables 1 , 2
    • latency
      • capture to apply 1
    • managing 1
    • monitoring
      • compatible columns 1
    • online redefinition 1
    • Oracle Label Security (OLS) 1
    • Oracle Real Application Clusters 1
    • queues 1
    • rules
      • adding 1
      • modifying 1 , 2
    • rule sets
      • specifying 1
    • switching to 1
    • SYS schema 1
    • SYSTEM schema 1
    • table type restrictions 1
    • transformations
      • rule-based 1
    • Transparent Data Encryption 1
  • SYS.AnyData
    • See: ANYDATA data type
  • system change numbers (SCN)
    • applied SCN for a capture process 1 , 2
    • applied SCN for an apply process 1
    • captured SCN for a capture process 1
    • first SCN for a capture process 1
    • maximum checkpoint SCN for a capture process 1
    • oldest SCN for an apply process 1
    • required checkpoint SCN for a capture process 1
    • start SCN for a capture process 1
  • system-generated names
    • apply process 1

T

  • tables
    • index-organized
      • capture process 1
  • tablespace repositories
    • creating 1
    • monitoring 1 , 2
    • using
      • without shared file system 1
      • with shared file system 1
  • tags 1
  • topology
    • component IDs 1
    • DBMS_STREAMS_ADVISOR_ADM package
      • gathering information 1
    • gathering information 1
    • Oracle Streams 1
    • stream paths
      • combined capture and apply 1
      • statistics 1
      • viewing 1
    • viewing 1
  • trace files
    • Oracle Streams 1
  • transformations
    • custom rule-based
      • action context 1
      • altering 1
      • creating 1
      • monitoring 1
      • removing 1
      • STREAMS$_TRANSFORM_FUNCTION 1
      • troubleshooting 1
    • declarative rule-based
      • monitoring 1
      • troubleshooting 1
    • Oracle Streams 1
    • rule-based
      • apply process 1
      • capture process 1
      • errors during apply 1
      • errors during capture 1
      • errors during dequeue 1
      • errors during propagation 1
      • managing 1
      • messaging client 1
      • monitoring 1
      • multiple 1
      • propagations 1
      • synchronous capture 1
  • transparent data encryption
    • messaging clients 1
  • Transparent Data Encryption
    • apply processes 1
    • buffered queues 1
    • capture processes 1
    • dequeue 1
    • error queue 1
    • explicit capture 1
    • interoperation with Oracle Streams 1
    • messaging clients 1
    • propagations 1
    • synchronous capture 1
  • triggers
    • firing property 1
    • queue tables 1
    • system triggers
      • on SCHEMA 1
  • troubleshooting
    • alerts 1
    • apply process
      • checking apply handlers 1
      • checking message type 1
      • checking status 1
      • error queue 1
      • performance 1
    • capture process
      • checking progress 1
      • checking status 1
      • creation 1
    • custom rule-based transformations 1
    • missing multi-version data dictionary 1
    • Oracle Streams 1 , 2 , 3 , 4 , 5
    • propagation jobs 1
    • propagations
      • checking queues 1
      • checking status 1
      • security 1
    • rules 1

U

  • UNRECOVERABLE clause
    • SQL*Loader
      • capture process 1
  • UNRECOVERABLE SQL keyword
    • capture process 1
  • upgrading
    • online using Streams
      • assumptions 1
      • capture database 1
      • instantiation 1
      • job queue processes 1
      • PL/SQL package subprograms 1
      • user-defined types 1
  • user messages 1 , 2
  • UTL_SPADV package 1

V

  • V$ARCHIVE_DEST view 1
  • V$ARCHIVED_LOG view 1
  • V$BUFFERED_PUBLISHERS view 1
  • V$BUFFERED_QUEUES view 1 , 2 , 3
  • V$BUFFERED_SUBSCRIBERS view 1 , 2
  • V$DATABASE view
    • supplemental logging 1
  • V$PROPAGATION_RECEIVER view 1 , 2
  • V$PROPAGATION_SENDER view 1 , 2 , 3 , 4
  • V$RULE_SET_AGGREGATE_STATS view 1
  • V$RULE_SET view 1 , 2
  • V$RULE view 1
  • V$SESSION view 1 , 2 , 3 , 4 , 5 , 6 , 7
  • V$STREAMS_APPLY_COORDINATOR view 1 , 2 , 3 , 4
  • V$STREAMS_APPLY_READER view 1 , 2 , 3 , 4 , 5
  • V$STREAMS_APPLY_SERVER view 1 , 2 , 3 , 4
  • V$STREAMS_CAPTURE view 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10
  • V$STREAMS_POOL_ADVICE view 1
  • virtual dependency definitions
    • object dependencies
      • managing 1
      • monitoring 1
    • value dependencies
      • managing 1
      • monitoring 1

X

  • XML Schema
    • for LCRs 1