Index
A B C D E F G H I J L M N O P Q R S T U V X
A
- action contexts, 5.1.3
-
- name-value pairs
-
- adding, 14.2.2.3, 15.2.1, 15.2.2
- altering, 14.2.2.2
- removing, 14.2.2.4, 15.2.2
- querying, 15.2.1
- system-created rules, 6.6
- ADD_COLUMN member procedure, 27.4
- ADD_COLUMN procedure, 15.1.1.2
- ADD_GLOBAL_RULES procedure, 6.3.1
- ADD_MESSAGE_RULE procedure, 12.3.3
- ADD_PAIR member procedure, 14.2.2.2, 14.2.2.3, 15.2.1, 15.2.2, 28.2, 28.4, 28.5, 28.7
- ADD_RULE procedure, 5.1.2.2, 14.1.2
- ADD_SCHEMA_PROPAGATION_RULES procedure, 6.3.2
- ADD_SUBSCRIBER procedure, 12.1.2
- ADD_SUBSET_PROPAGATION_RULES procedure
-
- row migration, 6.3.4.2
- ADD_SUBSET_RULES procedure, 6.3, 6.3.4
-
- row migration, 6.3.4.2
- ADD_TABLE_RULES procedure, 6.3.3
- alert log
-
- Oracle Streams entries, 18.5
- ALTER_APPLY procedure
-
- removing a rule set, 13.4.4
- removing the message handler, 13.7.2
- removing the precommit handler, 13.8.3
- setting an apply user, 13.6
- setting the message handler, 13.7.1
- setting the precommit handler, 13.8.2
- specifying a rule set, 13.4.1
- ALTER_CAPTURE procedure
-
- removing a rule set, 11.4.4
- setting a capture user, 11.6
- setting the first SCN, 11.10, 11.11
- specifying a rule set, 11.4.1
- specifying database link use, 11.12
- ALTER_PROPAGATION procedure
-
- removing the rule set, 12.2.10
- specifying the rule set, 12.2.5
- ALTER_PROPAGATION_SCHEDULE procedure, 12.2.4
- ALTER_RULE procedure, 14.2.2
- ANYDATA datatype
-
- queues, 3.5, 12.3.1
-
- creating, 12.1.1
- dequeuing, 12.3.2
- enqueuing, 12.3.1
- monitoring, 21.1
- removing, 12.1.4
- wrapper for messages, 3.5, 12.3.1
- applications
-
- upgrading
-
- using Streams, C.3
- applied SCN, 2.9.1, 20.12
- apply forwarding, 3.3.4.1
- apply handlers, 4.3.2.1.2
- apply process, 4
-
- apply forwarding, 3.3.4.1
- apply handlers, 4.3.2.1.2
-
- Java stored procedures, 4.3.2.4
- apply servers, 4.7.1
-
- states, 4.7.1.3
- apply user, 4.1
-
- privileges, 18.3.7
- secure queues, 3.9.4.2
- setting, 13.6
- architecture, 4.7
- automatic restart, 4.7.4.3
- coordinator process, 4.7.1
-
- states, 4.7.1.2
- creating, 4.7.2, 13.1
- datatypes applied, 4.4
- DDL handlers, 4.3.2
- dependencies, 4.7.1
- DML handlers, 4.3.2
-
- creating, 27.4
- dropping, 13.13
- enqueuing messages, 13.9
-
- monitoring, 22.13
- error handlers
-
- creating, 13.11.1
- monitoring, 22.4.1
- setting, 13.11.2
- error queue, 4.7.7
-
- monitoring, 22.15, 22.16
- logical change records (LCRs), 4.3.2.1
- managing, 13
- message handlers, 4.3.2
-
- monitoring, 22.4.2
- removing, 13.7.2
- setting, 13.7.1
- messages, 4.3
-
- captured, 4.3.1
- user-enqueued, 4.3.1
- monitoring, 22
-
- apply handlers, 22.4
- compatible tables, 26.3
- latency, 22.7, 22.10
- transactions, 22.9
- non-LCR messages, 4.3.2.2
- options, 4.3.2
- Oracle Real Application Clusters, 4.6
- parallelism, 22.12
- parameters, 4.7.4
-
- commit_serialization, 4.7.4.2
- disable_on_error, 4.7.4.4
- disable_on_limit, 4.7.4.3
- parallelism, 4.7.4.1
- setting, 13.5
- time_limit, 4.7.4.3
- transaction_limit, 4.7.4.3
- txn_lcr_spill_threshold, 22.6
- persistent status, 4.7.6
- precommit handlers, 4.3.2.3
-
- creating, 13.8.1
- monitoring, 22.4.3
- removing, 13.8.3
- setting, 13.8.2
- reader server, 4.7.1
-
- states, 4.7.1.1
- reenqueue captured messages, 27.4
- RESTRICTED SESSION, 4.5
- row subsetting, 6.3
-
- supplemental logging, 6.3.4.3
- rule sets
-
- removing, 13.4.4
- specifying, 13.4.1
- rules, 4.2, 6.1
-
- adding, 13.4.2
- removing, 13.4.3
- specifying execution, 13.10
-
- monitoring, 22.14
- spilled messages, 22.6
- starting, 13.2
- stopping, 13.3
- trace files, 18.5.3
- transformations
-
- rule-based, 7.3.3
- troubleshooting, 18.3
-
- checking apply handlers, 18.3.5
- checking message type, 18.3.3
- checking status, 18.3.1
- error queue, 18.3.8
- approximate CSCN, 3.8.2
- AQ_TM_PROCESSES initialization parameter
-
- Streams apply process, 18.3.6
- ARCHIVELOG mode
-
- capture process, 2.12.8, 11.1.1, 27.2
-
- Recovery Manager, 2.12.8.1
- ATTACH_TABLESPACES procedure, 16.1
B
- buffered messaging, 3.6
- buffered queues, 3.9.2
-
- monitoring, 21.2
-
- apply processes, 21.2.8
- capture processes, 21.2.2
- propagations, 21.2.3, 21.2.4, 21.2.5, 21.2.6, 21.2.7
- BUILD procedure, 2.9.2, 2.12.5.1
C
- capture process, 2
-
- applied SCN, 2.9.1, 20.12
- architecture, 2.12
- ARCHIVELOG mode, 2.12.8, 11.1.1, 27.2
- automatic restart, 2.12.9.2
- builder server, 2.12.1
- capture user
-
- secure queues, 3.9.4.2
- setting, 11.6
- captured messages, 3.2
- captured SCN, 2.9.1
- changes captured, 2.5
-
- DDL changes, 2.5.2
- DML changes, 2.5.1
- NOLOGGING keyword, 2.5.4
- UNRECOVERABLE clause for SQL*Loader, 2.5.5
- UNRECOVERABLE SQL keyword, 2.5.4
- checkpoints, 2.12.4
-
- managing retention time, 11.7
- maximum checkpoint SCN, 2.12.4.2
- required checkpoint SCN, 2.12.4.1, 2.12.8
- retention time, 2.12.4.3
- creating, 2.12.5, 11.1
- datatypes captured, 2.4
- DBID, 2.12.5, 11.1
- downstream capture, 2.8
-
- advantages, 2.8.2.4
- creating, 11.1
- database link, 2.8.2.5, 11.12
- monitoring, 20.5
- monitoring remote access, 26.1.2
- dropping, 11.14
- first SCN, 2.9.2
-
- setting, 11.10, 11.11
- global name, 2.12.5, 11.1
- index-organized tables, 2.5.1
- local capture, 2.8
-
- advantages, 2.8.1.2
- LogMiner, 2.12.3
-
- data dictionary, 2.12.5.1
- multiple sessions, 2.12.3
- managing, 11
- maximum checkpoint SCN, 2.12.4.2, 2.12.5.1.2
- monitoring, 20
-
- applied SCN, 20.12
- compatible tables, 26.3
- downstream capture, 20.5
- elapsed time, 20.4
- last redo entry, 20.9
- latency, 20.13, 20.14, 20.14
- message creation time, 20.3
- old log files, 20.8
- registered log files, 20.6, 20.8
- required log files, 20.7
- rule evaluations, 20.15
- state change time, 20.3
- online redefinition, 2.5.3
- Oracle Real Application Clusters, 2.11
- parameters, 2.12.9
-
- disable_on_limit, 2.12.9.2
- message_limit, 2.12.9.2
- parallelism, 2.12.9.1
- setting, 11.5
- time_limit, 2.12.9.2
- PAUSED FOR FLOW CONTROL state, 2.12.2
- persistent status, 2.12.11
- preparer servers, 2.12.1
- preparing for, 11.1.1
- reader server, 2.12.1
- Recovery Manager, 2.12.8.1
-
- flash recovery area, 18.1.3
- redo logs, 2.1
-
- adding manually, 11.9
- missing files, 18.1.3
- redo transport services, 2.8
- required checkpoint SCN, 2.12.4.1
- RESTRICTED SESSION, 2.10
- rule evaluation, 2.12.10
- rule sets
-
- removing, 11.4.4
- specifying, 11.4.1
- rules, 2.3, 6.1
-
- adding, 11.4.2
- removing, 11.4.3
- SGA_MAX_SIZE initialization parameter, 2.12.3
- start SCN, 2.9.2
- starting, 11.2
- states, 2.12.2
- stopping, 11.3
- supplemental logging, 2.6
-
- specifying, 11.8
- SYS schema, 2.3, 2.5
- SYSTEM schema, 2.3, 2.5
- trace files, 18.5.1
- transformations
-
- rule-based, 7.3.1
- troubleshooting, 18.1
-
- checking progress, 18.1.2
- checking status, 18.1.1
- captured SCN, 2.9.1
- character sets
-
- migrating
-
- using Streams, C.3
- checkpoints, 2.12.4
-
- retention time, 2.12.4.3
-
- managing, 11.7
- CLONE_TABLESPACES procedure, 16.1
- CLOSE_ITERATOR procedure, 28.3
- COMPATIBLE initialization parameter, 10.2, 27.2, 27.2
- COMPATIBLE_10_1 function, 6.7.1.2
- COMPATIBLE_9_2 function, 6.7.1.2
- conditions
-
- rules, 5.1.1
- CREATE_APPLY procedure, 4.7.2, 13.1
- CREATE_CAPTURE procedure, 2.12.5, 11.1, 11.1.2.2
- CREATE_PROPAGATION procedure, 12.2.1
- CREATE_RULE procedure, 14.2.1
- CREATE_RULE_SET procedure, 14.1.1
D
- database links
-
- Oracle Streams, 10.3
- database maintenance
-
- using Streams, C
-
- assumptions, C.1.2
- capture database, C.1.1
- instantiation, C.2.5
- job queue processes, C.1.3
- logical dependencies, C.2.3.2
- PL/SQL package subprograms, C.1.3
- user-created applications, C.2.3
- user-defined types, C.2.2
- datatypes
-
- applied, 4.4
- captured, 2.4
- DBA_APPLY view, 18.3.1, 18.3.3, 22.1, 22.2, 22.4.2, 22.5, 22.11
- DBA_APPLY_DML_HANDLERS view, 22.4.1
- DBA_APPLY_ENQUEUE view, 22.13
- DBA_APPLY_ERROR view, 22.15, 22.16, 22.16, 22.16
- DBA_APPLY_EXECUTE view, 22.14
- DBA_APPLY_PARAMETERS view, 22.3
- DBA_APPLY_PROGRESS view, 22.10
- DBA_APPLY_SPILL_TXN view, 22.6
- DBA_CAPTURE view, 18.1.1, 20.1, 20.5, 20.6, 20.7, 20.8, 20.12
- DBA_CAPTURE_EXTRA_ATTRIBUTES view, 20.11
- DBA_CAPTURE_PARAMETERS view, 20.10
- DBA_EVALUATION_CONTEXT_TABLES view, 23.6
- DBA_EVALUATION_CONTEXT_VARS view, 23.7
- DBA_FILE_GROUP_EXPORT_INFO view, 25.2.3
- DBA_FILE_GROUP_FILES view, 25.1.3
- DBA_FILE_GROUP_TABLES view, 25.2.2
- DBA_FILE_GROUP_TABLESPACES view, 25.2.1
- DBA_FILE_GROUP_VERSOINS view, 25.1.2
- DBA_FILE_GROUPS view, 25.1.1
- DBA_LOGMNR_PURGED_LOG view, 2.9.2.3, 2.12.8
- DBA_PROPAGATION view, 18.2.1, 18.2.2, 21.2.3, 21.2.4, 21.2.5, 21.2.6, 21.3.1, 21.3.2, 21.3.3, 21.3.4, 21.3.5
- DBA_QUEUE_SCHEDULES view, 21.3.4, 21.3.5
- DBA_QUEUE_TABLES view, 21.1.1
- DBA_QUEUES view, 21.1.1
- DBA_REGISTERED_ARCHIVED_LOG view, 20.6, 20.7, 20.8
- DBA_RULE_SET_RULES view, 23.8, 23.9
- DBA_RULE_SETS view, 23.5
- DBA_RULES view, 23.8, 23.9, 23.10
- DBA_STREAMS_ADD_COLUMN view, 24.2.1
- DBA_STREAMS_NEWLY_SUPPORTED view, 26.3.2
- DBA_STREAMS_RENAME_TABLE view, 24.2.2
- DBA_STREAMS_RULES view, 18.4.1, 23.3
- DBA_STREAMS_TRANSFORM_FUNCTION view, 24.3
- DBA_STREAMS_TRANSFORMATIONS view, 24.1, 24.2
- DBA_STREAMS_UNSUPPORTED view, 26.3.1
- DBID (database identifier)
-
- capture process, 2.12.5, 11.1
- DBMS_APPLY_ADM package, 13
- DBMS_CAPTURE_ADM package, 11
- DBMS_PROPAGATION_ADM package, 12
-
- starting a propagation, 12.2.2
- stopping a propagation, 12.2.3
- DBMS_RULE package, 5.2, 28
- DBMS_RULE_ADM package, 14, 14.1, 28
- DBMS_STREAMS_ADM package, 6.3, 11, 12, 13
-
- creating a capture process, 2.12.5, 11.1
- creating a propagation, 12.2.1
- creating an apply process, 4.7.2, 13.1
- DBMS_STREAMS_TABLESPACE_ADM package, 16.1
-
- information provisioning, 8.2.3
-
- platform conversion, 8.2.3.4
- DDL handlers, 4.3.2
- DELETE_ALL_ERRORS procedure, 13.12.2.2
- DELETE_ERROR procedure, 4.7.7, 13.12.2.1
- dependencies
-
- apply process, 4.7.1
- queues, 3.8.1
- dequeue high-watermark, 3.8.2
- DEQUEUE procedure, 12.3.2, 12.3.3
-
- example, 27.4
- destination queue, 3.1
- DETACH_TABLESPACES procedure, 16.1
- direct path load
-
- capture processes, 2.5.5
- directed networks, 3.3.4
-
- apply forwarding, 3.3.4.1
- queue forwarding, 3.3.4.1
- DISABLE_DB_ACCESS procedure, 12.1.3
- DML handlers, 4.3.2, 27.4
- DROP_APPLY procedure, 13.13
- DROP_CAPTURE procedure, 11.14
- DROP_PROPAGATION procedure, 12.2.11
- DROP_RULE procedure, 14.2.4
- DROP_RULE_SET procedure, 14.1.4
E
- ENABLE_DB_ACCESS procedure, 12.1.2
- ENQUEUE procedure, 12.3.1, 12.3.3
- error handlers
-
- creating, 13.11.1
- monitoring, 22.4.1
- setting, 13.11.2
- unsetting, 13.11.3
- error queue, 4.7.7
-
- apply process, 18.3.8
- deleting errors, 13.12.2
- executing errors, 13.12.1
- monitoring, 22.15, 22.16
- EVALUATE procedure, 5.2, 28.2, 28.3, 28.4, 28.5, 28.6, 28.7, 28.8
- evaluation contexts, 5.1.2
-
- association with rule sets, 5.1.2.2
- association with rules, 5.1.2.2
- evaluation function, 5.1.2.3
- object privileges
-
- granting, 14.3.2
- revoking, 14.3.4
- system privileges
-
- granting, 14.3.1
- revoking, 14.3.3
- user-created, 6.7, 6.7.2
- variables, 5.1.2.1
- event contexts
-
- example, 28.8
- system-created rules, 6.5
- EXECUTE member procedure, 13.11.1, 27.4
- EXECUTE_ALL_ERRORS procedure, 13.12.1.2
- EXECUTE_ERROR procedure, 4.7.7, 13.12.1.1
- explicit capture, 1.2.1
- Export
-
- Oracle Streams, 17.1
F
- file group repositories, 8.2.3.1
-
- monitoring, 25, 25.1
- using, 16.2
- first SCN, 2.9.2
- flash recovery area
-
- capture processes
-
- archived redo log files, 18.1.3
- flow control, 2.12.2
G
- GET_ALL_NAMES member function, 28.2, 28.3, 28.4, 28.5, 28.6, 28.7, 28.8
- GET_COMMA, 22.16
- GET_COMMAND_TYPE member function, 13.11.1, 13.12.1.1.2, 27.4
- GET_COMPATIBLE member function, 6.7.1.2
- GET_DDL_TEXT member function, 22.16
- GET_ERROR_MESSAGE function, 22.16, 22.16
- GET_INFORMATION function, 13.11.1
- GET_NEXT_HIT function, 5.2, 28.3
- GET_OBJECT_NAME member function, 13.11.1, 13.12.1.1.2, 15.2.1, 22.16
- GET_OBJECT_OWNER member function, 13.12.1.1.2, 15.2.1, 22.16
- GET_SOURCE_DATABASE_NAME member function, 22.16
- GET_STREAMS_NAME function, 13.11.1
- GET_VALUE member function, 13.12.1.1.2
-
- LCRs, 15.2.1
- rules, 28.2, 28.3, 28.4, 28.5, 28.6, 28.7, 28.8
- GET_VALUES member function, 13.11.1, 22.16, 27.4
- global name
-
- capture process, 2.12.5, 11.1
- GLOBAL_NAME view, 18.2.1, 20.5
- GLOBAL_NAMES initialization parameter, 10.2, 27.2
- GRANT_ADMIN_PRIVILEGE procedure, 10.1
- GRANT_OBJECT_PRIVILEGE procedure, 5.3
- GRANT_REMOTE_ADMIN_ACCESS procedure, 11.1.3.2, 11.1.4.2
- GRANT_SYSTEM_PRIVILEGE procedure, 5.3
- grids
-
- information provisioning, 8
H
- high availability
-
- Streams, 9
-
- advantages, 9.2.1
- apply, 9.3.2.4
- best practices, 9.3
- capture, 9.3.2.1
- database links, 9.3.2.2
- propagation, 9.3.2.3
I
- implicit capture, 1.2.1
- Import
-
- Oracle Streams, 17.1
- INCLUDE_EXTRA_ATTRIBUTE procedure, 2.2.3, 11.13
- index-organized tables
-
- capture process, 2.5.1
- information provisioning, 8
-
- bulk provisioning, 8.2
-
- Data Pump, 8.2.1
- DBMS_STREAMS_TABLESPACE_ADM package, 8.2.3
- file group repositories, 8.2.3.1
- incremental provisioning, 8.3
- on-demand information access, 8.4
- RMAN
-
- transportable tablespace from backup, 8.2.2
- tablespace repositories, 8.2.3.2
- using, 16
- initialization parameters
-
- AQ_TM_PROCESSES
-
- Streams apply process, 18.3.6
- COMPATIBLE, 10.2
- GLOBAL_NAMES, 10.2
- JOB_QUEUE_PROCESSES, 10.2
- LOG_ARCHIVE_CONFIG, 10.2
- LOG_ARCHIVE_DEST_n, 10.2
- LOG_ARCHIVE_DEST_STATE_n, 10.2
- OPEN_LINKS, 10.2
- Oracle Streams, 10.2
- PARALLEL_MAX_SERVERS, 10.2
- PROCESSES, 10.2
- SESSIONS, 10.2
- SGA_MAX_SIZE, 10.2, 10.2
- SGA_TARGET, 10.2
- SHARED_POOL_SIZE, 10.2
- STREAMS_POOL_SIZE, 3.9.1, 10.2
- TIMED_STATISTICS, 10.2
- UNDO_RETENTION, 10.2
- instantiation
-
- example
-
- RMAN CONVERT DATABASE, C.3.3.3
- RMAN DUPLICATE, B.3.3.2, C.3.3.2
- export/import, B.2.2, C.2.5
-
- Data Pump and original, 2.7
- in Streams, 2.7
- RMAN CONVERT DATABASE, C.2.5
- RMAN DUPLICATE, B.2.2, C.2.5
- interoperability
-
- Streams, 26.3.2
- IS_NULL_TAG member function, 22.16
J
- job queue processes
-
- propagation jobs, 3.9.3
- JOB_QUEUE_PROCESSES initialization parameter, 10.2, 27.2
-
- propagation, 18.2.3
L
- LCRs. See logical change records
- LOG_ARCHIVE_CONFIG initialization parameter, 10.2
- LOG_ARCHIVE_DEST_n initialization parameter, 10.2
- LOG_ARCHIVE_DEST_STATE_n initialization parameter, 10.2
- logical change records (LCRs), 2.2, 13.11.1
-
- apply process, 4.3.2.1
- DDL LCRs, 2.2.2
-
- rules, 6.3.3.1.2, 6.3.6.1.2
- extra attributes, 2.2.3
-
- managing, 11.13
- monitoring, 20.11
- getting information about, 15.2.1, 22.16
-
- compatibility, 6.7.1.2
- row LCRs, 2.2.1
-
- rules, 6.3.1.1
- XML schema, A
- LogMiner
-
- capture process, 2.12.3
- multiple sessions, 2.12.3
M
- MAINTAIN_GLOBAL procedure, 8.3
- MAINTAIN_SCHEMAS procedure, 8.3
- MAINTAIN_SIMPLE_TTS procedure, 8.3
- MAINTAIN_TABLES procedure, 8.3
- MAINTAIN_TTS procedure, 8.3
- maximum checkpoint SCN, 2.12.5.1.2
- message handlers, 4.3.2
-
- monitoring, 22.4.2
- messages
-
- apply process, 4.3
- captured, 3.2
- dequeue, 3.2
- enqueue, 3.2
- propagation, 3.3
- user-enqueued, 3.2
- messaging, 3.5, 12.3
-
- ANYDATA queues, 12.3.1
- buffered messaging, 3.6
- dequeue, 12.3.3
- enqueue, 12.3.3
- messaging clients
-
- example, 27.4
- managing, 12.3.3
- notifications
-
- managing, 12.3.3
- messaging client, 3.4
-
- messaging client user
-
- secure queues, 3.9.4.2
- transformations
-
- rule-based, 7.3.4
- migrating
-
- to different character set
-
- using Streams, C.3
- to different operating system
-
- using Streams, C.3
- monitoring
-
- ANYDATA datatype queues, 21.1
-
- message consumers, 21.1.4
- viewing event contents, 21.1.5
- apply process, 22
-
- apply handlers, 22.4
- compatible tables, 26.3
- error handlers, 22.4.1
- error queue, 22.15, 22.16
- message handlers, 22.4.2
- capture process, 20
-
- applied SCN, 20.12
- compatible tables, 26.3
- elapsed time, 20.4
- latency, 20.13, 20.14, 20.14
- message creation time, 20.3
- rule evaluations, 20.15
- state change time, 20.3
- file group repositories, 25
- Oracle Streams, 19
-
- performance, 26.4
- propagation jobs, 21.3
- propagations, 21, 21.3
- queues, 21
- rule-based transformations, 24
- rules, 23
- tablespace repositories, 25
- multi-version data dictionary
-
- missing, 18.4.1.5
N
- NOLOGGING mode
-
- capture process, 2.5.4
O
- online redefinition
-
- Streams, 2.5.3
- OPEN_LINKS initialization parameter, 10.2
- operating systems
-
- migrating
-
- using Streams, C.3
- ORA-01291 error, 18.1.3
- ORA-06550 error, 18.3.7
- ORA-24093 error, 18.2.4.1
- ORA-25224 error, 18.2.4.2
- ORA-26666 error, 18.3.1
- ORA-26678 error, 18.1.5
- Oracle Data Pump
-
- information provisioning, 8.2.1
- Oracle Enterprise Manager
-
- Streams tool, 1.14.3
- Oracle Real Application Clusters
-
- interoperation with Oracle Streams, 2.11, 3.7, 4.6
- queues, 3.7
- Oracle Streams
-
- administrator
-
- configuring, 10.1
- monitoring, 26.1.1
- alert log, 18.5
- ANYDATA queues, 12.3.1
- apply process, 4
- capture process, 2
- compatibility, 6.7.1.2, 26.3
- data dictionary, 3.9.6, 4.7.3, 19
- Data Pump, 2.7
- database links, 10.3
- database maintenance, C
- directed networks, 3.3.4
- Export utility, 2.7, 17.1
- high availability, 9
- Import utility, 2.7, 17.1
- information provisioning, 8.3
- initialization parameters, 10.2, 27.2, 27.2
- instantiation, 2.7
- interoperability, 26.3.2
- logical change records (LCRs), 2.2
-
- XML schema, A
- LogMiner data dictionary, 2.12.5.1
- messaging, 3.5, 12.3
- messaging clients, 3.4
- monitoring, 19
- network connectivity, 10.3
- overview, 1.1
- packages, 1.14.1
- preparing for, 10
- propagation, 3
-
- Oracle Real Application Clusters, 3.7
- queues
-
- Oracle Real Application Clusters, 3.7
- rules, 6
-
- action context, 6.6
- evaluation context, 6.3, 6.4
- event context, 6.5
- subset rules, 6.3, 6.3.4
- system-created, 6.3
- sample environments
-
- single database, 27
- staging, 3
-
- Oracle Real Application Clusters, 3.7
- Streams data dictionary, 2.12.7
- Streams pool, 3.9.1
-
- monitoring, 26.2
- Streams tool, 1.14.3
- supplemental logging, 2.6
- tags, 1.11
- trace files, 18.5
- transformations
-
- rule-based, 7
- troubleshooting, 18
- upgrading online, B
- user messages, 3.1
P
- PARALLEL_MAX_SERVERS initialization parameter, 10.2
- patches
-
- applying
-
- using Streams, C.3
- POST_INSTANTIATION_SETUP procedure, 8.3
- PRE_INSTANTIATION_SETUP procedure, 8.3
- precommit handlers, 4.3.2.3
-
- creating, 13.8.1
- monitoring, 22.4.3
- removing, 13.8.3
- setting, 13.8.2
- privileges
-
- Oracle Streams administrator, 10.1
-
- monitoring, 26.1.1
- rules, 5.3
- PROCESSES initialization parameter, 10.2
- propagation jobs, 3.9.3
-
- altering, 12.2.4
- job queue processes, 3.9.3
- managing, 12.2
- monitoring, 21.3
- RESTRICTED SESSION, 3.9.3.2
- scheduling, 3.9.3.1
- trace files, 18.5.2
- troubleshooting, 18.2
-
- job queue processes, 18.2.3
- propagations, 3, 3.3
-
- architecture, 3.9
- binary files, 3.3.5
- buffered queues, 3.9.2
- creating, 12.2.1
- destination queue, 3.1
- directed networks, 3.3.4
- dropping, 12.2.11
- ensured delivery, 3.3.3
- managing, 12.2
- monitoring, 21, 21.3
- queue-to-queue, 3.3.2, 3.3.2, 21.3.1
-
- Oracle Real Application Clusters, 3.7
- propagation job, 3.9.3
- schedule, 12.2.4.1
- rule sets
-
- removing, 12.2.10
- specifying, 12.2.5
- rules, 3.3.1, 6.1
-
- adding, 12.2.8
- removing, 12.2.9
- source queue, 3.1
- starting, 12.2.2
- stopping, 12.2.3
- transformations
-
- rule-based, 7.3.2
- troubleshooting, 18.2
-
- checking queues, 18.2.1
- checking status, 18.2.2
- security, 18.2.4
Q
- queue forwarding, 3.3.4.1
- queues
-
- ANYDATA, 3.5, 12.3.1
-
- creating, 12.1.1
- dequeuing, 27.4
- removing, 12.1.4
- browsing, 3.8.1.2
- buffered, 3.9.2
- commit-time, 3.8
- dependencies, 3.8.1
- dequeue high-watermark, 3.8.2
- monitoring, 21
- nontransactional, 3.9.5
- Oracle Real Application Clusters, 3.7
- queue tables, 3.9.2
-
- triggers, 3.9.2
- secure, 3.9.4
-
- disabling user access, 12.1.3
- enabling user access, 12.1.2
- users, 3.9.4.2
- transactional, 3.9.5
- typed, 3.5
- queue-to-queue propagations, 3.3.2, 3.3.2, 21.3.1
-
- schedule, 12.2.4.1
R
- RE$NAME_ARRAY type, 28.5, 28.6, 28.7, 28.8
- RE$NV_LIST type, 5.2, 28.2, 28.4, 28.5, 28.5, 28.6, 28.7, 28.7, 28.8
-
- ADD_PAIR member procedure, 14.2.2.2, 14.2.2.3, 15.2.1, 15.2.2
- REMOVE_PAIR member procedure, 14.2.2.2, 14.2.2.4, 15.2.2, 15.2.3
- RE$RULE_HIT_LIST type, 28.2, 28.4, 28.5, 28.6, 28.7, 28.8
- RE$TABLE_ALIAS_LIST type, 28.5, 28.6, 28.7, 28.8
- RE$TABLE_VALUE type, 28.5, 28.6, 28.7, 28.8
- RE$TABLE_VALUE_LIST type, 28.5, 28.6, 28.7, 28.8
- RE$VARIABLE_TYPE_LIST type, 28.2, 28.4, 28.6, 28.7, 28.8
- RE$VARIABLE_VALUE type, 28.2, 28.3, 28.4, 28.6
- RE$VARIABLE_VALUE_LIST type, 28.2, 28.3, 28.4, 28.6
- Recovery Manager
-
- capture processes
-
- archived redo log files, 2.12.8.1
- flash recovery area, 18.1.3
- CONVERT DATABASE command
-
- Streams instantiation, C.2.5, C.3.3.3
- DUPLICATE command
-
- Streams instantiation, B.2.2, B.3.3.2, C.2.5, C.3.3.2
- information provisioning, 8.2.2
- redo logs
-
- capture process, 2.1
- reenqueue
-
- captured messages, 27
- REMOVE_PAIR member procedure, 14.2.2.2, 14.2.2.4, 15.2.2, 15.2.2, 15.2.3
- REMOVE_QUEUE procedure, 12.1.4
- REMOVE_RULE procedure, 11.4.3, 12.2.9, 13.4.3, 14.1.3
- RENAME_COLUMN procedure, 15.1.2
- RENAME_TABLE procedure, 15.1.1.1, 15.1.3
- required checkpoint SCN, 2.12.8
- RESTRICTED SESSION system privilege
-
- apply processes, 4.5
- capture processes, 2.10
- propagation jobs, 3.9.3.2
- REVOKE_OBJECT_PRIVILEGE procedure, 5.3
- REVOKE_SYSTEM_PRIVILEGE procedure, 5.3
- row migration, 6.3.4.2, 6.3.4.2
- rule sets, 5.1
-
- adding rules to, 14.1.2
- creating, 14.1.1
- dropping, 14.1.4
- evaluation, 5.2
-
- partial, 5.2.2
- negative, 6.2
- object privileges
-
- granting, 14.3.2
- revoking, 14.3.4
- positive, 6.2
- removing rules from, 14.1.3
- system privileges
-
- granting, 14.3.1
- revoking, 14.3.3
- rule-based transformations, 7
-
- custom, 7.2
-
- action contexts, 7.2.1
- altering, 15.2.2
- creating, 15.2.1
- managing, 15.2
- monitoring, 24.3
- privileges, 7.2.2
- removing, 15.2.3
- declarative, 7.1
-
- adding, 15.1.1
- managing, 15.1
- monitoring, 24.2
- removing, 15.1.3
- step number, 7.4.1
- troubleshooting, 18.4.2
- managing, 15
- monitoring, 24
- ordering, 7.4
- rules, 5
-
- action contexts, 5.1.3
-
- adding name-value pairs, 14.2.2.2, 14.2.2.3, 15.2.1, 15.2.2
- altering, 14.2.2.2
- removing name-value pairs, 14.2.2.4, 15.2.2, 15.2.3
- transformations, 7.2.1
- ADD_RULE procedure, 5.1.2.2
- altering, 14.2.2
- apply process, 4.2, 6.1
- capture process, 2.3, 6.1
- components, 5.1
- creating, 14.2.1
- DBMS_RULE package, 5.2
- DBMS_RULE_ADM package, 14
- dropping, 14.2.4
- EVALUATE procedure, 5.2
- evaluation, 5.2
-
- capture process, 2.12.10
- iterators, 5.2
- partial, 5.2.2
- evaluation contexts, 5.1.2
-
- evaluation function, 5.1.2.3
- user-created, 6.7.2
- variables, 5.1.2.1
- event context, 5.2
-
- example, 28.8
- example applications, 28
- explicit variables, 5.1.2.1
-
- example, 28.2, 28.6
- implicit variables, 5.1.2.1
-
- example, 28.7
- iterative results, 5.2
-
- example, 28.3
- managing, 14.1
- MAYBE rules, 5.2
-
- example, 28.4
- monitoring, 23
- object privileges
-
- granting, 14.3.2
- revoking, 14.3.4
- partial evaluation, 5.2.2
-
- example, 28.4
- privileges, 5.3
-
- managing, 14.3
- propagations, 3.3.1, 6.1
- rule conditions, 5.1.1, 6.3.3, 6.3.4
-
- complex, 6.7.1.3
- explicit variables, 5.1.2.1
- finding patterns in, 23.10
- implicit variables, 5.1.2.1
- Streams compatibility, 6.7.1.2
- types of operations, 6.7.1.1
- undefined variables, 6.7.1.4
- using NOT, 6.7.1.3.1
- variables, 6.3.1.1
- rule_hits, 5.2
- simple rules, 5.1.1.2
- subset, 6.3.4
-
- querying for action context of, 15.2.1
- querying for names of, 15.2.1
- system privileges
-
- granting, 14.3.1
- revoking, 14.3.3
- system-created, 6, 6.3
-
- action context, 6.6
- and_condition parameter, 6.3.7
- DDL rules, 6.3.3.1.2, 6.3.6.1.2
- DML rules, 6.3.1.1
- evaluation context, 6.3, 6.4
- event context, 6.5
- global, 6.3.1
- modifying, 14.2.3
- row migration, 6.3.4.2
- schema, 6.3.2
- STREAMS$EVALUATION_CONTEXT, 6.3, 6.4
- subset, 6.3, 6.3.4
- table, 6.3.3
- table data
-
- example, 28.5, 28.6, 28.7
- troubleshooting, 18.4
- TRUE rules, 5.2
- user-created, 6.7
- variables, 5.1.2.1
S
- secure queues, 3.9.4
-
- disabling user access, 12.1.3
- enabling user access, 12.1.2
- propagation, 18.2.4
- Streams clients
-
- users, 3.9.4.2
- SESSIONS initialization parameter, 10.2
- SET_COMMAND_TYPE member procedure, 27.4
- SET_DML_HANDLER procedure, 4.3.2.1.2
-
- setting an error handler, 13.11.2
- unsetting an error handler, 13.11.3
- SET_ENQUEUE_DESTINATION procedure, 13.9, 27.4
- SET_EXECUTE procedure, 13.10
- SET_MESSAGE_NOTIFICATION procedure, 12.3.3
- SET_OBJECT_NAME member procedure, 27.4
- SET_PARAMETER procedure
-
- apply process, 13.5
- capture process, 11.5
- SET_RULE_TRANSFORM_FUNCTION procedure, 15.2
- SET_UP_QUEUE procedure, 12.1.1
- SET_VALUE member procedure, 13.12.1.1.2, 15.2.1
- SET_VALUES member procedure, 13.11.1, 13.11.1, 27.4
- SGA_MAX_SIZE initialization parameter, 2.12.3, 10.2, 10.2
- SGA_TARGET initialization parameter, 10.2
- SHARED_POOL_SIZE initialization parameter, 10.2
- source queue, 3.1
- SQL*Loader
-
- capture processes, 2.5.5
- staging, 3
-
- approximate CSCN, 3.8.2
- architecture, 3.9
- buffered queues, 3.9.2
-
- monitoring, 21.2
- management, 12
- messages, 3.2
- secure queues, 3.9.4
-
- disabling user access, 12.1.3
- enabling user access, 12.1.2
- start SCN, 2.9.2
- START_APPLY procedure, 13.2
- START_CAPTURE procedure, 11.2
- START_PROPAGATION procedure, 12.2.2
- Statspack
-
- Oracle Streams, 26.4
- STOP_APPLY procedure, 13.3
- STOP_CAPTURE procedure, 11.3
- STOP_PROPAGATION procedure, 12.2.3
- Streams data dictionary, 2.12.7, 3.9.6, 4.7.3
- Streams pool, 3.9.1
-
- monitoring, 26.2
- Streams. See Oracle Streams
- Streams tool, 1.14.3
- STREAMS$_EVALUATION_CONTEXT, 6.3, 6.4
- STREAMS$_TRANSFORM_FUNCTION, 7.2.1
- STREAMS_POOL_SIZE initialization parameter, 3.9.1, 10.2
- supplemental logging
-
- capture process, 2.6
- row subsetting, 6.3.4.3
- specifying, 11.8
- SYS.AnyData. See ANYDATA datatype
- system change numbers (SCN)
-
- applied SCN for a capture process, 2.9.1, 20.12
- captured SCN for a capture process, 2.9.1
- first SCN for a capture process, 2.9.2
- maximum checkpoint SCN for a capture process, 2.12.4.2
- required checkpoint SCN for a capture process, 2.12.4.1
- start SCN for a capture process, 2.9.2
T
- tablespace repositories, 8.2.3.2
-
- creating, 16.1.1
- monitoring, 25, 25.2
- using, 16.1
-
- with shared file system, 16.1.2
- without shared file system, 16.1.3
- tags, 1.11
- TIMED_STATISTICS initialization parameter, 10.2
- trace files
-
- Oracle Streams, 18.5
- transformations
-
- custom rule-based, 7.2
-
- action context, 7.2.1
- altering, 15.2.2
- creating, 15.2.1
- monitoring, 24.3
- removing, 15.2.3
- STREAMS$_TRANSFORM_FUNCTION, 7.2.1
- troubleshooting, 18.4.3
- declarative rule-based, 7.1
-
- monitoring, 24.2
- troubleshooting, 18.4.2
- Oracle Streams, 7
- rule-based, 7
-
- apply process, 7.3.3
- capture process, 7.3.1
- errors during apply, 7.3.3.1
- errors during capture, 7.3.1.1
- errors during dequeue, 7.3.4.1
- errors during propagation, 7.3.2.1
- managing, 15
- messaging client, 7.3.4
- monitoring, 24
- multiple, 7.3.5
- propagations, 7.3.2
- triggers
-
- queue tables, 3.9.2
- troubleshooting
-
- apply process, 18.3
-
- checking apply handlers, 18.3.5
- checking message type, 18.3.3
- checking status, 18.3.1
- error queue, 18.3.8
- capture process, 18.1
-
- checking progress, 18.1.2
- checking status, 18.1.1
- custom rule-based transformations, 18.4.3
- missing multi-version data dictionary, 18.4.1.5
- Oracle Streams, 18
- propagation jobs, 18.2
-
- job queue processes, 18.2.3
- propagations, 18.2
-
- checking queues, 18.2.1
- checking status, 18.2.2
- security, 18.2.4
- rules, 18.4
U
- UNDO_RETENTION initialization parameter, 10.2
- UNRECOVERABLE clause
-
- SQL*Loader
-
- capture process, 2.5.5
- UNRECOVERABLE SQL keyword
-
- capture process, 2.5.4
- upgrading
-
- online using Streams, B
-
- assumptions, B.1.2
- capture database, B.1.1
- instantiation, B.2.2
- job queue processes, B.1.3
- PL/SQL package subprograms, B.1.3
- user-defined types, B.2.1
- user messages, 3.1
V
- V$ARCHIVED_LOG view, 2.9.2
- V$BUFFERED_PUBLISHERS view, 21.2.2
- V$BUFFERED_QUEUES view, 21.2.1, 21.2.6, 21.2.8
- V$BUFFERED_SUBSCRIBERS view, 21.2.6, 21.2.8
- V$PROPAGATION_RECEIVER view, 21.2.7
- V$PROPAGATION_SENDER view, 21.2.3, 21.2.4, 21.2.5
- V$RULE view, 23.14
- V$RULE_SET view, 23.12, 23.13
- V$RULE_SET_AGGREGATE_STATS view, 23.11
- V$SESSION view, 20.2, 22.5, 22.7, 22.8, 22.11
- V$STREAMS_APPLY_COORDINATOR view, 4.7.1.2, 22.8, 22.9, 22.10
- V$STREAMS_APPLY_READER view, 4.7.1.1, 22.5, 22.6, 22.7
- V$STREAMS_APPLY_SERVER view, 4.7.1.3, 22.11, 22.12
- V$STREAMS_CAPTURE view, 2.12.2, 18.1.2, 20.2, 20.3, 20.4, 20.9, 20.13, 20.14, 20.14, 20.15
- V$STREAMS_POOL_ADVICE view, 3.9.1.2, 26.2
X
- XML Schema
-
- for LCRs, A