Index

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

---

A

accounts

creating for snapshots, 3-32

additive conflict resolution method, 5-15

administrative queue, 2-24

administrative requests, 2-22

states, 2-25

awaiting callback, 2-25

do callback, 2-25

error, 2-25

ready, 2-25

AND expression

for simple subquery snapshots, 3-15

append sequences conflict resolution method, 5-25

append site name conflict resolution method, 5-24

assignment tables, 3-11

asynchronous replication, 2-29

average conflict resolution method, 5-16

---

B

backups

for replication, 6-10

BLOBs support, A-7

branch automation, A-6

bulk updates, B-4

---

C

CLOBs support, A-7

columns

column groups, 2-28, 5-10

ensuring data integrity with multiple, 5-10

shadow, 5-11

column level snapshot subsetting, A-3

comments

on Oracle documentation, xviii

COMPATIBLE initialization parameter, 7-3

complete refreshes, 3-28

complex snapshots, 3-6

value for PCTFREE, 3-28

value for PCTUSED, 3-28

conflict resolution, 2-42, 5-1

additive method, 5-15

append sequences method, 5-25

append site name method, 5-24

average method, 5-16

avoiding conflicts, 5-7

column groups, 5-10

concepts, 5-2

data requirements, 5-2

delete conflicts, 5-4

detecting conflicts, 5-5

discard method, 5-17, 5-25

dynamic site ownership, 5-7

in synchronous propagation, 2-33

latest timestamp method, 5-12

maximum value method, 5-18

methods for delete conflicts, 5-26

methods for uniqueness conflicts, 5-24

methods for update conflicts, 5-11

minimum value method, 5-20

overwrite methods, 5-13

performance, 5-26

compare old values, 5-27

min communication, 5-26

send old values, 5-27

primary site ownership, 5-7

priority groups method, 5-21

procedural replication and, 6-3

replication, 2-10

site priority method, 5-22

transaction ordering, 5-4

types of conflicts, 5-3

uniqueness conflicts, 5-3

update conflicts, 5-3

conflicts

avoiding, 5-7

dynamic ownership, 6-11

delete, 5-4

avoiding, 5-8

detecting, 2-33, 2-41, 5-5

identifying rows, 2-42, 5-6

error queue, 5-11

ordering

avoiding, 5-8

procedural replication, 1-17

token passing, 6-12

uniqueness, 5-3

avoiding, 5-8

update, 5-3

avoiding, 5-8

workflow, 6-11

connection qualifiers, 2-14

diagnosing problems with, B-2

constraint violations, B-4

constraints

referential

self-referencing, 2-16

continuous pushes

scheduling, 7-11, 7-12

Copy Template Wizard, 8-26

---

D

data

integrity

ensuring with multiple column groups, 5-10

parallel propagation, 6-21

serial propagation, 6-21

data dictionary

replication, 1-14

data propagation

and dependency maintenance, 6-21

reduced, A-6

synchronous, 2-31

data subsetting, A-6

database links

connection qualifiers, 2-14

diagnosing problems with, B-2

incomplete specifications, B-6

replication, 2-12

snapshot sites, 3-32, 7-15

datatypes

allowed in replicated tables, 7-2

allowed in snapshots, 3-22

support for, A-7

DBA_REGISTERED_SNAPSHOTS view, 3-16

DBA_REPCATLOG view, 2-22

DBA_SNAPSHOT_LOGS view, 3-16

DBMS_REFRESH package

REFRESH_CHANGE procedure, 4-21

DBMS_REPCAT package, 2-22, 2-24

COMPARE_OLD_VALUES procedure

conflict resolution, 5-27

DO_DEFERRED_REPCAT_ADMIN procedure, 2-22, 2-23

REPCAT_IMPORT_CHECK procedure, 6-11

SEND_OLD_VALUES procedure

conflict resolution, 5-27

DBMS_REPCAT_INSTANTIATE package

INSTANTIATE_OFFLINE_REPAPI function, C-14

DBMS_REPUTIL package

REPLICATION_OFF procedure, 6-4, 6-18

REPLICATION_ON procedure, 6-4, 6-19

DBMS_SNAPSHOT package

REGISTER_SNAPSHOT procedure, 3-17

UNREGISTER_SNAPSHOT procedure, 3-17

deadlocks

resolving

in synchronous propagation, 2-33

deferred constraints and updatable snapshots, A-8

deferred transaction queue

push, 2-20

scheduled purge, 3-34

scheduled push, 3-34

deferred transactions, 2-19

diagnosing problems with, B-6

dependency

ordering

replicated transactions, 6-21

tracking

parallel propagation, 6-21

Deployment Template Wizard, 8-22

deployment templates, 1-11, 4-1

adding snapshots to, 4-14

architecture, 4-14

column subsetting, 4-22

concepts, 4-3

data sets, 4-27

definitions, 4-14

design, 4-22

elements, 4-4

general template information, 4-4

horizontal partitioning, 4-24

instantiation, 1-11, 4-9

offline, 4-10, 4-18, A-3

online, 4-9, 4-17

process, 4-16

scenarios, 4-11

object definitions, 4-6, 4-14

packaging, 4-9

for offline instantiation, 4-16

for offline instantiation (Oracle8i Lite), C-14

for online instantiation, 4-16

procedures, 4-13

process, 4-16

parameters, A-2

preparing snapshot sites for, 7-13

refresh groups, 4-21

snapshot groups, 4-21

snapshot logs, 4-13

snapshot sites, 4-9

template parameters, 4-7

security, 4-8

user authorization, 4-8

vertical partitioning, 4-22

disabling

replication, 6-17

discard conflict resolution method, 5-17, 5-25

distributed schema management, 1-14

distributed transactions

problems with, B-6

documentation

conventions, xvii

dynamic ownership

conflict avoidance and, 6-11

locating owner of a row, 6-15

obtaining ownership, 6-15

workflow partitioning, 6-11

dynamic sites

ownership, 5-7

---

E

enabling replication, 6-17

ENQUEUE_RESOURCES initialization parameter, 7-3

errors

error queue, 2-20

conflicts, 5-11

EXIST clause

for simple subquery snapshots, 3-15

---

F

failover sites

FAILOVER option, 6-10

implementing, 6-9

fast refreshes, 3-28

and table reorganization, A-8

direct path load, 3-28

feedback

on Oracle documentation, xviii

filter columns, 3-37

for simple subquery snapshots, 3-15

fine grained quiesce, A-7

force refreshes, 3-29

functions

replicating, 2-17

---

G

generating

replication support

procedural replication, 6-4

GLOBAL_NAMES initialization parameter, 7-3

group owner

snapshot groups, 3-24

---

I

import

snapshot logs, 3-20

snapshots, 3-20

indexes

partitioned tables and, A-8

replication, 2-16

initialization parameters

editing, 3-36

JOB_QUEUE_INTERVAL, 2-23

JOB_QUEUE_PROCESSES, 2-23

OPEN_LINKS, 2-15

PARALLEL_MAX_SERVERS, 2-37

PARALLEL_MIN_SERVERS, 2-37

replication, 7-3

INIT.ORA parameters. See initialization parameters

internal triggers, A-6

intersection tables, 3-15

---

J

Java RepAPI, A-5, C-1

administering, C-16

architecture, C-3

before configuring on server, C-7

callout classes, C-5

client engine, C-5

concepts, C-3

configuring the server for, C-1

CORBA, C-3

defined, C-2

deployment templates

packaging, C-14

initialization parameters, C-7

Java object, C-4

listener configuration, C-8

Oracle Client Replication Tool, C-16

preconfiguration tasks, C-7

sample program, C-17

examples, C-20

installing, C-17

using, C-17

server component, C-4

server object

loading, C-9

publishing, C-9

verify publication of, C-12

service URL, C-4

JAVA_POOL_SIZE initialization parameter, 7-4

job queue, 2-20

JOB_QUEUE_INTERVAL initialization parameter, 2-23, 7-4

JOB_QUEUE_PROCESSES initialization parameter, 2-23, 3-34, 7-4

jobs

checking for scheduled links, B-6

joins

for simple subquery snapshots, 3-15

---

L

latest timestamp

conflict resolution method, 5-12

LOBs

allowed in replicated tables, 7-2

support for, 3-22, A-7

---

M

many-to-many references

simple subquery snapshots, 3-15

many-to-one references

simple subquery snapshots, 3-15

mass deployment, 3-4, 4-2, A-6

master definition site, 1-5, 2-2

master groups, 1-5, 2-26

master sites, 1-5

advantages of, 7-9

bulk updates, B-4

compared with snapshot sites, 7-8

constraints

violations, B-4

DDL changes not propagated, B-3

diagnosing problems with, B-2

DML changes not propagated, B-3

fine grained quiesce, A-7

internal triggers, 3-19

replicated objects not created at new, B-2

replication, 2-6, 2-11

roles, 2-11

scheduled links for

guidelines, 7-10

scheduled purge, 3-34

scheduled purges for

guidelines, 7-11

snapshot registration, 3-16

snapshots, 3-19

users, 2-11

master tables

columns

number restriction for simple subquery snapshots, 3-15

snapshot logs, 3-20

snapshots, 3-19

MAX_ENABLED_ROLES initialization parameter, 7-4

maximum value conflict resolution method, 5-18

min communication, 2-38

conflict resolution, 5-26

minimum value conflict resolution method, 5-20

modifying

tables

without replicating changes, 6-17

MTS_DISPATCHERS initialization parameter, 7-5

multimaster replication, 1-5, 2-1

architecture, 2-11

asynchronous, 2-7

concepts, 2-2

disconnected snapshots, 2-5

failover, 2-3

load balancing, 2-4

synchronous, 2-7, 2-8

transaction propagation protection, 6-20

uses of, 2-3

---

N

NCLOB support, A-7

Net8

FAILOVER option, 6-10

new features

data subsetting and subqueries, A-6

enhanced security, A-8

for management and use, A-7

improved mass deployment support, A-2

improved Oracle8i Lite integration, A-5

improved security, A-4

LOB support, A-7

Oracle Replication Manager enhancements, A-4

performance enhancements, A-2, A-5

replication, A-1

subqueries for snapshots, A-6

subquery snapshots, A-6

null refresh, A-2

n-way replication. See multimaster replication

---

O

objects

replicated

re-creating, B-4

offline instantiation

support for, A-8

Offline Instantiation Wizard, 8-24

OPEN_CURSORS initialization parameter, 7-5

OPEN_LINKS initialization parameter, 2-15, 7-5

OPS. See Oracle Parallel Server

Oracle Client Replication Tool, C-16

Oracle Parallel Server

compared to replication, 2-5, 6-8

Oracle Replication Manager, 1-13, 8-1

Destination Map, 8-7

first login, 8-3

interface, 8-4

menus, 8-13

Edit, 8-14

File, 8-13

Group, 8-14

Help, 8-17

Object, 8-16

Scheduling, 8-16

Setup, 8-16

Template, 8-15

View, 8-14

Navigator pane, 8-5

right pane, 8-5

starting, 8-3

toolbar, 8-10

Change Database Connection button, 8-10

Create Local Job button, 8-12

Create Master Group button, 8-10

Create Refresh Group button, 8-11

Create Scheduled Link button, 8-12

Create Snapshot button, 8-11

Create Snapshot Group button, 8-11

Create Snapshot Log button, 8-11

Create Template button, 8-12

Help button, 8-13

Offline Instantiation File Generation button, 8-12

Refresh button, 8-10

Setup Wizard button, 8-10

usage scenarios, 8-2

wizards, 8-17

Copy Template, 8-26

Deployment Template, 8-22

Offline Instantiation Wizard, 8-24

Setup, 8-18

Snapshot Group, 8-20

Oracle8i

new replication features, A-1

Oracle8i Lite support, C-1

overwrite conflict resolution methods, 5-13

---

P

packages

internal, A-2

replication, 2-16

parallel propagation, 2-36, A-5

dependency

tracking, 6-21

implementing, 2-37

planning for, 7-12

replication environment, 7-12

tuning, 2-38

parallel server processes

configuring for replication environments, 2-36

Parallel Server. See Oracle Parallel Server

PARALLEL_MAX_SERVERS initialization parameter, 2-37, 7-6

PARALLEL_MIN_SERVERS initialization parameter, 2-37, 7-6

partitioned tables

indexes and, A-8

PCTFREE

value for complex snapshots, 3-28

PCTUSED

value for complex snapshots, 3-28

peer-to-peer replication. See multimaster replication

performance

replication, 2-36

performance enhancements, A-2, A-5

periodic purges

scheduling, 7-12

periodic pushes

scheduling, 7-10

PRIMARY KEY constraint

simple subquery snapshots and, 3-15

primary key snapshots, 3-5, A-7

primary keys

replicated tables, 7-2

primary sites

ownership, 5-7

priority groups conflict resolution method, 5-21

procedural replication, 1-16

conflicts and, 6-3

detecting conflicts, 1-17

generating support for, 6-4

restrictions, 2-16, 6-2

serialization of transactions, 6-3

using, 6-2

wrapper, 1-16

procedures

replicating, 2-17

PROCESSES initialization parameter, 7-7

propagation, 2-29

initiating, 2-35

modes, 2-33

parallel, 2-36

implementing, 2-37

tuning, 2-38

reduction, A-6

security context of propagator, 2-32

propagator

replication, 2-12

purges

periodic

scheduling, 7-12

pushes

continuous

scheduling, 7-11, 7-12

periodic

scheduling, 7-10

---

Q

quiescing, 2-20

and fine grained quiesce, A-7

---

R

read-only snapshots, 1-7, 3-8

registration

manual, 3-17

unregistering, 3-17

receiver

replication, 2-12

recovery

for replication, 6-10

re-enabling

replication, 6-19

referential integrity

self-referential constraints, 2-16

refresh, 3-28

automatic, 3-30

complete, 3-28

DBMS_REFRESH package

REFRESH_CHANGE procedure, 4-21

failures, B-8

fast, 3-28

fast and table reorganization, A-8

force, 3-29

group, 3-30

initiating, 3-30

interval, 3-30

intervals

parameter constraints, 3-30

manual, 3-30

null optimization, 3-27

on-demand, 3-30

retries, B-8

snapshots, 1-10

refresh groups, 3-25

deployment templates, 4-21

optimization for large, A-2

size considerations, 3-27

troubleshooting, B-7

RepAPI. See Java RepAPI

replicated tables

and DML incompatibility, B-4

datatypes allowed, 7-2

replicated transactions

dependency ordering, 6-21

replication

administration, 1-12, 2-20

administration requests, 2-22

administrative queue, 2-24

administrative requests

states, 2-25

advanced techniques, 6-1

applications that use, 1-3

asynchronous propagation, 2-29

availability, 1-2, 6-7

backup and recovery for, 6-10

checking imported data, 6-11

column groups, 2-28

compared to Oracle Parallel Server, 2-5, 6-8

conflict resolution, 1-15, 2-10, 2-42, 5-1

conflicts

detecting, 2-41

procedural replication, 1-17

connection qualifiers, 2-14

creating an environment, 8-28

data requirements, 5-2

database links, 2-12

CONNECT TO clause, 2-13

USING clause, 2-13

deferred transaction queue, 2-20

diagnosing problems with, B-6

deferred transactions, 2-19

definition, 1-2

deployment templates, 1-11, 4-1

disabling, 6-4, 6-17, 6-18

disconnected computing, 1-2

distributed schema management, 1-14

enabling, 6-4, 6-17

error queue, 2-20

failover, 6-9

filter columns, 3-37

flowchart for creating environment, 8-28

groups, 1-4, 2-26

hybrid configurations, 1-11

initialization parameters, 7-3

internal procedures, 2-19

internal triggers, 2-19

introduction, 1-2

Java RepAPI, C-1

job queue, 2-20

mass deployment, 1-3, 4-2

master definition site, 1-5

master groups, 1-5, 2-26

master sites, 1-5, 2-6, 2-11

min communication, 2-38

modes, 2-20

multimaster, 1-5, 2-1

network load reduction, 1-2

new features, A-1

improved mass deployment support, A-2

improved Oracle8i Lite integration, A-5

improved security, A-4

Oracle Replication Manager enhancements, A-4

performance enhancements, A-2, A-5

objects, 2-15

off/on affects current session, 6-18

Oracle8i Lite support, C-1

performance, 1-2, 2-36

planning for, 7-1

procedural, 1-16

procedural replication, 6-2

propagation, 2-29

propagator, 2-12

quiesce, 2-20

real-time replication. See synchronous replication

receiver, 2-12

re-enabling, 6-19

REPADMIN user, 2-12

replication administrator, 2-12

replication management API, 1-14

resuming, 2-22

See Also multimaster replication

See Also snapshots

single master, 2-6

sites, 1-4

snapshot groups, 1-5

snapshots, 1-7, 3-1

SNP background processes, 3-34

survivability, 6-7

suspending, 2-21

synchronous, 1-16, 2-31

transaction propagation protection, 6-20

triggers, 6-19

troubleshooting, B-1

unsupported datatypes

BFILE, 3-22

LONG, 3-22

uses of, 1-2

replication catalog, 1-14

DBA_REGISTERED_SNAPSHOTS, 3-16

DBA_REPCATLOG, 2-22

DBA_SNAPSHOT_LOGS, 3-16

incorrect views, B-6

USER_REFRESH, B-8

USER_REFRESH_CHILDREN, B-8

replication functions, 2-17

replication management API, 1-14, 2-22

Replication Manager. See Oracle Replication Manager

replication objects, 1-4, 2-19

at snapshot sites

problems creating, B-7

indexes, 2-16

packages, 2-16

procedures, 2-17

re-creating, B-4

sequences, 2-18

tables, 2-15, 7-2

modifying, 6-17

primary keys, 7-2

unable to generate support for, B-4

triggers, 2-17

replication triggers, A-6

REPLICATION_DEPENDENCY_TRACKING initialization parameter, 7-7

restrictions

procedural replication, 2-16

rollback segments

snapshot sites, 7-16

ROWID datatype

ROWID snapshots, 3-5

rows

identifying during conflict detection, 2-42

---

S

scheduled links

continuous pushes, 7-11, 7-12

guidelines, 7-10

parallel propagation, 7-12

periodic pushes, 7-10

serial propagation, 7-12

scheduled purges

guidelines, 7-11

periodic purges, 7-12

schemas

creating for snapshots, 3-32

security, A-8

sequences

replication, 2-18

serialization

of transactions, 6-3

Setup Wizard, 8-18

shadow column groups, 5-11

SHARED_POOL_SIZE initialization parameter, 7-7

simple subquery snapshots

many-to-many references, 3-15

many-to-one references, 3-15

site ownership

dynamic, 5-7

primary, 5-7

site priority

as a backup method during timestamp conflict resolution, 5-12, 5-18

site priority conflict resolution method, 5-22

Snapshot Group Wizard, 8-20

snapshot groups, 1-5, 3-23

deployment templates, 4-21

group owner, 3-24

snapshot logs, 1-10, 3-20

creating, 3-37

deployment templates, 4-13

import, 3-20

primary key, 3-20

privileges required to create, 3-37

ROWID, 3-20

troubleshooting, B-9

underlying table for, 3-20

snapshot sites

advantages of, 7-9

compared with master sites, 7-8

database links, 7-15

database links for, 3-32

database version, 7-14

deferred transaction queue

scheduled push, 3-34

local creation, 4-29

network connectivity, 7-14

preparing for deployment templates, 7-13

rollback segments, 7-16

scheduled links for

guidelines, 7-10

scheduled purge for

guidelines, 7-11

schemas, 7-15

setup, 7-14

snapshots, 1-7, 3-1

architecture, 3-17

assignment tables, 3-11

base table, 3-21

column level subsetting, A-3

complex, 3-6

value for PCTFREE, 3-28

value for PCTUSED, 3-28

concepts, 3-2

creating, 3-38

creating schemas for, 3-32

data subsetting, 3-4, 3-8

datatypes supported, 3-22

deployment templates, 1-11, 4-1

disabling replication for, 6-19

disconnected computing, 3-4

enabling replication for, 6-19

horizontal partitioning, 3-8

import, 3-20

index, 3-23

large refresh group optimization, A-2

mass deployment, 3-4

master sites, 3-19

master tables, 3-19

network loads, 3-3

null refresh, A-2

Oracle8i Lite support, C-1

preparing for, 3-31

primary key, 3-5, A-7

privileges, 3-33

read-only, 1-7, 3-8

registration, 3-17

simple with subqueries, A-6

unregistering, 3-17

refresh, 1-10, 3-28

complete, 3-28

failures, B-8

fast, 3-28

force, 3-29

initiating, 3-30

interval, 3-30

on-demand, 3-30

querying for last refresh time, 3-16

retries, B-8

troubleshooting, B-7, B-8

refresh groups, 3-25

size, 3-27

registration at master site, 3-16

ROWID, 3-5

simple subquery

AND expression and, 3-15

EXISTS clause and, 3-15

filter columns requirement, 3-15

joins and, 3-15

number of columns in master tables, 3-15

snapshot groups, 3-23

snapshot logs, 1-10, 3-20

subqueries, 3-9

restrictions, 3-14

trace file, B-8

troubleshooting, B-7

types, 3-4

updatable

deferred constraints, A-8

updateable, 1-8

use of, 3-3

vertical partitioning, 3-8

views, 3-22

SNP background processes, 3-34

store-and-forward replication. See asynchronous replication

subquery snapshots, A-6

AND expression and, 3-15

EXIST clause and, 3-15

filter columns requirement, 3-15

joins for, 3-15

many-to-many references, 3-15

many-to-one references, 3-15

number of columns in master tables, 3-15

survivability, 6-7

design considerations, 6-8

implementing, 6-9

Oracle Parallel Server and, 6-8

synchronous replication, 1-16, 2-31

of destination of transactions, 2-33

synonyms, 2-19

replication, 2-19

system-based security, A-8

---

T

tables

intersection, 3-15

modifying

without replicating changes, 6-17

partitioned and indexes, A-8

problems generating replication support for, B-4

reorganizing, A-8

replication, 2-15

token passing, 6-12

sample implementation, 6-11

trace files

snapshots, B-8

transactions

propagation

protection mechanisms, 6-20

serialization of, 6-3

triggers

internal, A-6

replicating, 2-17, 6-19

troubleshooting, B-1

---

U

UNIQUE constraint

simple subquery snapshots and, 3-15

updateable snapshots, 1-8

USER_REFRESH view, B-8

USER_REFRESH_CHILDREN view, B-8

---

V

views, 2-19

replication, 2-19

---

W

workflow, 6-11

wrapper

procedural replication, 1-16