Index

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

A

ADD_MESSAGE_RULE procedure, 9.3.4, 9.4.2
ADD_TABLE_PROPAGATION_RULES procedure, 4.3.4
ADD_TABLE_RULES procedure, 4.3.4, 4.3.4
ADD_UPDATE_RESOLUTION procedure, 7.6.2
administrator
Streams
creating, 2.2
alerts
Oracle Streams, 5.3.1
ALL_APPLY view, 4.1.10.2
ALL_APPLY_CONFLICT_COLUMNS view, 4.1.10.2
ALL_APPLY_ERROR view, 4.1.10.2
ALL_CAPTURE view, 4.1.10.2
ALL_PROPAGATION view, 4.1.10.2
ALL_STREAMS_COLUMNS view, 4.1.10.2
ALL_STREAMS_RULES view, 4.1.10.2
ALL_STREAMS_UNSUPPORTED view, 4.1.10.2
ALL_SYNC_CAPTURE view, 4.1.10.2
ALTER_APPLY procedure, 4.3.4
ANYDATA queues, 2.3
apply, 4.1.3
apply errors
correcting database objects, 5.3.2.1
managing, 5.3.2
retrying transactions, 5.3.2.2
apply handlers
definition, 4.1.3
apply process
apply errors, 5.3.2
apply handlers, 4.1.3
definition, 4.1.3
instantiation SCN, 4.1.3
managing, 5.1.3
monitoring, 5.2.7
statistics, 5.2.7.2
rules, 4.1.4
setting parameters, 5.1.3.2
starting, 5.1.3.1
stopping, 5.1.3.1

B

best practices
for Oracle Streams replication, 4.2
for working with non-Oracle databases, 3.6.2
bottleneck components, 5.2.2
buffered messaging
definition, 9.1.2
buffered queues
definition, 4.1.1.1, 9.1.2
monitoring
statistics, 5.2.8

C

capture, 4.1.1
capture processes, 4.1.1.1
synchronous captures, 4.1.1.2
capture process
definition, 4.1.1.1
managing, 5.1.1
monitoring, 5.2.5.1
rules, 4.1.4
setting parameters, 5.1.1.2
starting, 5.1.1.1
statistics, 5.2.5.2
stopping, 5.1.1.1
supplemental logging, 4.1.6
case differences
distributed databases, 3.6.2
change cycling
definition, 4.1.8
COMPARE function, 10.3
comparing data, 10
COMPATIBLE parameter, 4.2
complete refresh
definition, 7.1.2
conflict resolution
adding columns for, 4.3.5, 7.6.2
configuring, 7.6.2
creating triggers for, 4.3.5, 7.6.2
definition, 4.1.7, 7.6.1.3
latest time
configuring, 4.3.5, 7.6.2, 7.6.2
monitoring, 5.2.7.4
prebuilt update conflict handlers, 4.1.7
conflicts
definition, 4.1.7, 7.6.1.3
consumers, 9.9.4
configuring, 9.3.4, 9.4.2
definition, 9.1
viewing, 9.8.3
continuous replication, 4.1
CONVERGE procedure, 10.4
converging data, 10
CREATE_APPLY procedure, 4.3.4
CREATE_COMPARISON procedure, 10.3
custom rule-based transformations
definition, 4.1.5

D

data
comparing, 10, 10.3
converging, 10, 10.4
tags, 10.4
modifying, 3.4
data replication and integration, 1.2
options, 1.3
database links
creating, 2.4, 7.3
definition, 2.4, 9.1.4
DB_DOMAIN parameter, 2.1
DB_NAME parameter, 2.1
DBA_APPLY view, 4.1.10.2
DBA_APPLY_CONFLICT_COLUMNS view, 4.1.10.2, 5.2.7.4
DBA_APPLY_ERROR view, 4.1.10.2
DBA_CAPTURE view, 4.1.10.2
DBA_COMPARISON view, 10.3
DBA_COMPARISON_COLUMNS view, 10.3
DBA_COMPARISON_ROW_DIF view, 10.3
DBA_COMPARISON_SCAN view, 10.3, 10.3
DBA_PROPAGATION view, 4.1.10.2
DBA_REGISTERED_MVIEWS view, 8.2.8
DBA_STREAMS_COLUMNS view, 4.1.10.2
DBA_STREAMS_RULES view, 4.1.10.2
DBA_STREAMS_UNSUPPORTED view, 4.1.10.2
DBA_SYNC_CAPTURE view, 4.1.10.2
DBMS_APPLY_ADM package, 4.1.9.3, 4.1.10.1, 4.3.4, 4.3.5, 4.3.5
DBMS_AQ package, 9.4.3
DBMS_CAPTURE_ADM package, 4.1.9.3, 4.1.10.1, 4.3.4
DBMS_COMPARISON package, 10.1, 10.3, 10.4
DBMS_MVIEW package, 8.1.4
DBMS_PROPAGATION_ADM package, 4.1.10.1
DBMS_REPCAT package, 7.6.2
DBMS_STREAMS package, 5.3.2.1
DBMS_STREAMS_ADM package, 4.1.9.3, 4.1.10.1, 4.3.4
DBMS_STREAMS_MESSAGING package, 9.3.3, 9.3.4, 9.4.5
DDL LCRs
definition, 4.1
declarative rule-based transformations
definition, 4.1.5
deferred transactions
definition, 7.6.1.2, 7.6.1.2
monitoring, 8.2.5
DEQUEUE procedure, 9.3.4, 9.4.3
dequeuing messages, 9.1, 9.3.6
destination queues
definition, 4.1.2
distributed databases
case differences, 3.6.2
configuring, 3.6.1
database links, 2.4
distributed SQL, 3.1.1
federation, 3.1
initialization parameters, 3.6.2
memory requirements, 3.6.2
modifying data, 3.4
non-Oracle databases, 3.1.3, 3.6
best practices, 3.6.2
post processing
reducing, 3.6.2
preparing for, 3.2
queries, 3.3
stored procedures, 3.1.4, 3.5
synonyms, 3.1.2
tuning, 3.6.2
two-phase commit, 3.1.1
when to use, 1.3.1
distributed queries
definition, 3.3
distributed SQL
definition, 3.1.1
distributed transactions
definition, 3.4
downstream capture processes
definition, 4.1.1.1
DROP MATERIALIZED VIEW LOG statement, 8.1.4

E

ENQUEUE procedure, 9.3.3, 9.4.5
enqueuing messages, 9.1, 9.3.5, 9.4.5
configuring mechanism for, 9.3.3
error queue
apply errors, 5.3.2

F

fast refresh
definition, 7.1.2
federation, 3.1
definition, 1.2
force refresh
definition, 7.1.2
functions
definition, 3.1.4

G

generating replication support, 7.6.2
global coordinators
definition, 3.1.1
global database name, 2.4
definition, 2.1
GLOBAL_NAMES parameter, 2.1, 2.4, 4.2, 7.2, 9.2

H

HS_FDS_FETCH_ROWS parameter, 3.6.2
HS_LANGUAGE parameter, 3.6.2
HS_RPC_FETCH_SIZE parameter, 3.6.2
hub-and-spoke replication, 4.1.9.2
adding database objects, 6.2
adding databases, 6.3
configuring, 4.3.3

I

information integration, 1.2
options, 1.3
initialization parameters
materialized views, 7.2
messaging, 9.2
Oracle Streams replication, 4.2
setting, 2.1
instantiation SCN
definition, 4.1.3
setting, 4.3.4

L

latest time conflict resolution
configuring, 4.3.5, 7.6.2
local capture processes
definition, 4.1.1.1
location transparency, 3.1.2
logical change records (LCRs)
definition, 4.1

M

MAINTAIN_GLOBAL procedure, 6.1
MAINTAIN_SCHEMAS procedure, 6.1
MAINTAIN_SIMPLE_TTS procedure, 6.1
MAINTAIN_TABLES procedure, 6.1
MAINTAIN_TTS procedure, 6.1
MAKE_COLUMN_GROUP procedure, 7.6.2
master groups
creating, 7.6.2
definition, 7.6.1.1
generating replication support, 7.6.2
quiescing, 7.6.2
master sites
cleaning up materialized view support, 8.1.4
configuring, 7.3, 7.6.2
definition, 7.1.1
monitoring
materialized view logs, 8.2.7
registered materialized views, 8.2.8
master tables
definition, 7.1.1
materialized view groups
creating, 7.6.2
definition, 7.6.1.1
monitoring, 8.2.4
relationship with refresh groups, 7.6.1.1
materialized view logs
configuring, 7.4
definition, 7.1.2
monitoring, 8.2.7
purging, 8.1.4
troubleshooting, 8.3.2
materialized view sites
configuring, 7.3
definition, 7.1.1
materialized views, 7
administering, 8
dropping, 8.1.3
initialization parameters, 7.2
master groups
creating, 7.6.2
definition, 7.6.1.1
generating replication support, 7.6.2
quiescing, 7.6.2
master sites
configuring, 7.6.2
definition, 7.1.1
master tables
definition, 7.1.1
materialized view groups
creating, 7.6.2
definition, 7.6.1.1
monitoring, 8.2.4
relationship with refresh groups, 7.6.1.1
materialized view logs
configuring, 7.4
definition, 7.1.2
monitoring, 8.2.7
troubleshooting, 8.3.2
materialized view sites
configuring, 7.3
definition, 7.1.1
monitoring, 8.2
preparing for, 7.2
read-only, 7.5.1
configuring, 7.5.2
definition, 7.1
refresh groups
adding materialized views to, 8.1.2, 8.1.2
configuring, 7.7
definition, 7.1.3
monitoring, 8.2.6
refreshing, 8.1.1.1
relationship with materialized view groups, 7.6.1.1
refreshing, 8.1.1
definition, 7.1.2
monitoring, 8.2.3
replication, 7.1, 8
troubleshooting, 8.3
refresh, 8.3.1
unregistering at master site, 8.1.4
updatable, 7.6.1
configuring, 7.6.2
conflict resolution, 7.6.2
conflicts, 7.6.1.3
definition, 7.1
MEMORY_TARGET parameter, 4.2, 7.2, 9.2
MERGE_STREAMS_JOB procedure, 5.3.3
message ordering
definition, 9.1.1
message statistics, 9.8.2
message types
creating, 9.3.1, 9.4.1
messages
removal, 9.9.4
viewing, 9.8.1
messaging, 9
buffered, 9.1.2
consumers, 9.1
dequeuing messages, 9.1, 9.3.4, 9.3.6, 9.4.3
enqueuing messages, 9.1, 9.3.3, 9.3.5, 9.4.5
example, 9.3
initialization parameters, 9.2
integration of Oracle and non-Oracle messages, 9.1.5
message modes, 9.1.2
message ordering, 9.1.1
message types
creating, 9.3.1, 9.4.1
messages
viewing, 9.8.1
messaging clients
configuring, 9.3.4, 9.4.2
monitoring, 9.8
notifications
configuring, 9.4.4
definition, 9.1.3
example, 9.4
Oracle Messaging Gateway, 9.1.5
persistent, 9.1.2
preparing for, 9.2
producers, 9.1
propagations
definition, 9.1.4
modifying, 9.7
queue tables
modifying, 9.6
queues
definition, 9.1
modifying, 9.5
statistics, 9.8.2
troubleshooting, 9.9
dequeue, 9.9.1
enqueue, 9.9.1, 9.9.2
propagations, 9.9.3
viewing messages, 9.4.5
when to use, 1.3.4
messaging clients
configuring, 9.3.4, 9.4.2
monitoring
apply processes, 5.2.7
statistics, 5.2.7.2
capture processes, 5.2.5.1
statistics, 5.2.5.2
materialized view groups, 8.2.4
materialized view logs, 8.2.7
materialized view replication, 8.2.1
materialized views, 8.2, 8.2.2
messaging, 9.8
Oracle Streams replication, 5.2
conflict resolution, 5.2.7.4
topology, 5.2.4
propagations, 5.2.6.1, 5.2.6.2
statistics, 5.2.6.2
refresh groups, 8.2.6

N

negative rule sets
definition, 4.1.4
non-Oracle databases, 3.1.3
accessing and modifying data, 3.6
best practices, 3.6.2
case differences, 3.6.2
notifications
configuring, 9.4.4
definition, 9.1.3
example, 9.4
n-way replication, 4.1.9.3

O

object types
creating, 9.3.1, 9.4.1
ORA-01031 error, 9.9.1
ORA-02019 error, 9.9.3
ORA-24033 error, 9.9.2
Oracle Database Gateway, 3.1.3, 3.6
best practices, 3.6.2
configuring, 3.6.1
Oracle Messaging Gateway, 9.1.5
Oracle Streams
Advanced Queuing, 9
alerts, 5.3.1
data dictionary views, 4.1.10
packages, 4.1.10
replication, 4.1
Oracle Streams Advanced Queuing. See messaging
Oracle Streams topology, 5.2.4
Oracle Warehouse Builder, 1.3
ordering
messages, 9.1.1

P

persistent messaging
definition, 9.1.2
persistent queues
definition, 9.1.2
statistics, 9.8.2
positive rule sets
definition, 4.1.4
post processing
distributed databases
reducing, 3.6.2
prebuilt update conflict handlers
definition, 4.1.7
privileges
granting, 9.3.3, 9.4.3, 9.9.1
procedures
definition, 3.1.4
PROCESSES parameter, 4.2
producers
definition, 9.1
propagation
configuring, 9.3.2
definition, 4.1.2, 9.1.4
disabling, 5.1.2
enabling, 5.1.2
modifying, 9.7
monitoring, 5.2.6.1, 5.2.6.2
statistics, 5.2.6.2
rules, 4.1.4
troubleshooting, 9.9.3
propagation jobs
definition, 9.1.4
purge schedule
definition, 7.6.1.2
PURGE_MVIEW_FROM_LOG procedure, 8.1.4

Q

querying
multiple databases, 3.3
queue tables
creating, 2.3
modifying, 9.6
queues
ANYDATA type
creating, 2.3
buffered, 4.1.1.1
monitoring, 5.2.8
consumers, 9.9.4
viewing, 9.8.3
definition, 9.1
messages
removal, 9.9.4
statistics, 9.8.2
viewing, 9.8.1
modifying, 9.5
persistent, 9.1.2
privileges
granting, 9.9.1
subscribers
viewing, 9.8.3
queue-to-dblink propagations
definition, 9.1.4
queue-to-queue propagations
definition, 9.1.4

R

read-only materialized views, 7.5.1
configuring, 7.5.2
definition, 7.1
refresh groups
adding materialized views to, 8.1.2, 8.1.2
configuring, 7.7
definition, 7.1.3
monitoring, 8.2.6
refreshing, 8.1.1.1
relationship with materialized view groups, 7.6.1.1
refreshing
definition, 7.1.2
materialized views, 8.1.1
methods of, 7.1.2
monitoring, 8.2.3
troubleshooting, 8.3.1
remote procedure call (RPC)
definition, 3.5
replication
continuous, 4.1
definition, 4.1, 7.1
materialized views, 7, 7.1
managing, 8.1
monitoring, 8.2, 8.2.1
preparing for, 7.2
read-only data, 7.5
read/write data, 7.6
troubleshooting, 8.3
when to use, 1.3.3
Oracle Streams, 4.1
administering, 5
apply processes, 4.1.3, 5.1.3
best practices, 4.2
bottleneck components, 5.2.2
capture processes, 4.1.1.1, 5.1.1
change capture, 4.1.1
configuring, 4.3.1, 4.3.2, 4.3.3, 4.3.4
conflict resolution, 4.1.7, 4.3.5, 5.2.7.4
extending, 6
hub-and-spoke, 4.1.9.2, 4.3.3, 6.2, 6.3
managing, 5.1
monitoring, 5.2
n-way, 4.1.9.3
preparing for, 4.2
propagations, 4.1.2
rule-based transformations, 4.1.5
rules, 4.1.4
Streams clients, 4.1.4
supplemental logging, 4.1.6
tags, 4.1.8
topology, 5.2.4
troubleshooting, 5.3
two-database, 4.1.9.1, 4.3.1, 4.3.2, 4.3.4
when to use, 1.3.2
replication groups
definition, 7.6.1.1
row LCRs
definition, 4.1
RPC. See remote procedure call
rule sets
definition, 4.1.4
rule-based transformations
definition, 4.1.5
rules
apply processes, 4.1.4
capture processes, 4.1.4
definition, 4.1.4
propagations, 4.1.4
synchronous captures, 4.1.4

S

scheduled links
definition, 7.6.1.2
SESSIONS parameter, 4.2
SET_MESSAGE_NOTIFICATION procedure, 9.4.4
SET_TABLE_INSTANTIATION_SCN procedure, 4.3.4
SET_TAG procedure, 5.3.2.1
SET_UPDATE_CONFLICT_HANDLER procedure, 4.3.5
SGA_TARGET parameter, 4.2, 7.2, 9.2
shared database objects
definition, 10.1
SHARED_POOL_SIZE parameter, 7.2, 9.2
source queues
definition, 4.1.2
SPLIT_STREAMS procedure, 5.3.3
splitting and merging streams, 5.3.3
START_APPLY procedure, 4.3.4
stateful alerts
definition, 5.3.1
stateless alerts
definition, 5.3.1
statistics
apply processes, 5.2.7.2
buffered queues, 5.2.8
capture processes, 5.2.5.2
persistent queue, 9.8.2
propagations, 5.2.6.2
stored functions
definition, 3.1.4
stored procedures
definition, 3.1.4
running, 3.5
Streams administrator
creating, 2.2
creating a tablespace for, 2.2.1
Streams clients
definition, 4.1.4
STREAMS_POOL parameter, 4.2
subscribers
viewing, 9.8.3
supplemental logging
definition, 4.1.6
synchronous capture
configuring, 4.3.4
definition, 4.1.1.2
rules, 4.1.4
synonyms
creating, 3.3
definition, 3.1.2
distributed databases, 3.1.2

T

tables
adding columns to, 4.3.5, 7.6.2
tablespaces
creating for Streams administrator, 2.2.1
tags
avoiding change cycling, 4.3.1, 4.3.3, 4.3.4
converging data, 10.4
definition, 4.1.8
topology, 5.2.4
transformations
rule-based, 4.1.5
triggers
creating, 4.3.5, 7.6.2, 9.3.3
troubleshooting
alerts, 5.3.1
materialized views, 8.3
materialized view logs, 8.3.2
refresh, 8.3.1
messaging, 9.9
dequeuing messages, 9.9.1
enqueuing messages, 9.9.1, 9.9.2
Oracle Streams replication, 5.3
apply errors, 5.3.2
unavailable destination, 5.3.3
propagations, 9.9.3
tuning
distributed databases, 3.6.2
two-database replication, 4.1.9.1
configuring
downstream capture process, 4.3.2
local capture process, 4.3.1
synchronous capture, 4.3.4
two-phase commit
definition, 3.1.1

U

UNREGISTER_MVIEW procedure, 8.1.4
updatable materialized views, 7.6.1
configuring, 7.6.2
deferred transactions, 7.6.1.2
monitoring, 8.2.5
definition, 7.1
purge schedule, 7.6.1.2
scheduled links, 7.6.1.2
users
creating, 2.2.2

V

V$BUFFERED_QUEUES view, 4.1.10.2
V$MVREFRESH view, 8.2.3
V$PROPAGATION_RECEIVER view, 4.1.10.2
V$PROPAGATION_SENDER view, 4.1.10.2
V$STREAMS_APPLY_COORDINATOR view, 4.1.10.2
V$STREAMS_APPLY_READER view, 4.1.10.2
V$STREAMS_APPLY_SERVER view, 4.1.10.2
V$STREAMS_CAPTURE view, 4.1.10.2
V$STREAMS_TRANSACTION view, 4.1.10.2

W

Warehouse Builder, 1.3