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

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