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.7

ADD_TABLE_RULES procedure, 4.7, 4.7

ADD_UPDATE_RESOLUTION procedure, 7.6.2

administrator

Streams

creating, 2.2

alerts

Oracle Streams, 5.3.1

ALTER_APPLY procedure, 4.7

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.5

statistics, 5.2.5.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

buffered messaging

definition, 9.1.2

buffered queues

definition, 4.1.1.1, 9.1.2

monitoring

statistics, 5.2.6

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.3.1

rules, 4.1.4

setting parameters, 5.1.1.2

starting, 5.1.1.1

statistics, 5.2.3.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, 7.6.2

configuring, 7.6.2

creating triggers for, 4.3, 7.6.2

definition, 4.1.7, 7.6.1.3

latest time

configuring, 4.3, 7.6.2, 7.6.2

monitoring, 5.2.5.3

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.7

CREATE_COMPARISON procedure, 10.3

CREATE_RULE_SET procedure, 4.7

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

re-creating, 8.3.1

DB_DOMAIN parameter, 2.1

DB_NAME parameter, 2.1

DBA_APPLY_CONFLICT_COLUMNS view, 5.2.5.3

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_REGISTERED_MVIEWS view, 8.2.8

DBMS_APPLY_ADM package, 4.1.9.2, 4.3, 4.3, 4.7

DBMS_AQ package, 9.4.3

DBMS_CAPTURE_ADM package, 4.1.9.2, 4.7

DBMS_COMPARISON package, 10.1, 10.3, 10.4

DBMS_MVIEW package, 8.1.4

DBMS_REPCAT package, 7.6.2

DBMS_STREAMS package, 5.3.2.1

DBMS_STREAMS_ADM package, 4.1.9.1, 4.1.9.2, 4.4, 4.5, 4.6, 4.7, 6.1, 6.2, 6.3

DBMS_STREAMS_ADVISOR_ADM package, 5.2.2

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

directory objects

creating, 4.4, 4.5, 4.6, 6.3

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.1

adding database objects, 6.2

adding databases, 6.3

configuring, 4.7

read only spokes

configuring, 4.4, 4.5

read/write spokes

configuring, 4.6, 4.7

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.7

L

latest time conflict resolution

configuring, 4.3, 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, 4.1.9.1, 6.1

MAINTAIN_SCHEMAS procedure, 4.1.9.1, 4.4, 4.5, 4.6, 6.1, 6.3

MAINTAIN_SIMPLE_TTS procedure, 4.1.9.1, 6.1

MAINTAIN_TABLES procedure, 4.1.9.1, 6.1, 6.2

MAINTAIN_TTS procedure, 4.1.9.1, 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.5

statistics, 5.2.5.2

capture processes, 5.2.3.1

statistics, 5.2.3.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.5.3

performance, 5.2.7

topology, 5.2.2

propagations, 5.2.4.1, 5.2.4.2

statistics, 5.2.4.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.2

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

replication, 4.1

Oracle Streams Advanced Queuing. See messaging

Oracle Streams Performance Advisor, 5.2.2

Oracle Streams topology, 5.2.2

Oracle Warehouse Builder, 1.3

ordering

messages, 9.1.1

P

performance

Oracle Streams Performance Advisor, 5.2.2

Oracle Streams replication

monitoring, 5.2.7

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.4.1, 5.2.4.2

statistics, 5.2.4.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.6

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

redo transport services

configuring, 4.5

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

capture processes, 4.1.1.1, 5.1.1

change capture, 4.1.1

configuring, 4.4, 4.5, 4.6, 4.7

conflict resolution, 4.1.7, 4.3, 5.2.5.3

extending, 6

hub-and-spoke, 4.1.9.1, 6.2, 6.3

managing, 5.1

monitoring, 5.2

n-way, 4.1.9.2

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.2

troubleshooting, 5.3

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.7

SET_TAG procedure, 5.3.2.1

SET_UPDATE_CONFLICT_HANDLER procedure, 4.3

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.7

stateful alerts

definition, 5.3.1

stateless alerts

definition, 5.3.1

statistics

apply processes, 5.2.5.2

buffered queues, 5.2.6

capture processes, 5.2.3.2

persistent queue, 9.8.2

propagations, 5.2.4.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 topology

DBMS_STREAMS_ADVISOR_ADM package, 5.2.2

STREAMS_POOL parameter, 4.2

subscribers

viewing, 9.8.3

supplemental logging

definition, 4.1.6

synchronous capture

configuring, 4.7

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, 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$MVREFRESH view, 8.2.3

V$STREAMS_APPLY_COORDINATOR view, 5.2.7

W

Warehouse Builder, 1.3