Index

ALTER SNAPSHOT LOG command, 7-23

advanced replication, 2-1 to 8-37

advanced replication systems

monitoring, 7-4

ALTER_MASTER_REPOBJECT procedure

DBMS_REPCAT package, 2-29

altering

priority group members

priorities, 6-27

values, 6-26

site priority group members

priorities, 6-30

values, 6-31

snapshot definitions, 5-27

alternate keys

in replicated tables, 2-25

AND expression

conflict resolution methods, 6-36

append sequences

append site names

conflict resolution methods, 6-36

assigning

update conflict resolution methods, 6-17

asynchronous

replication, 2-3

RPCs, 9-2

auditing, 7-18

conflict resolution, 7-18

automatic conflict resolution

versus manual, 6-7

automatic refreshes

refresh interval, 3-24

average

conflict resolution method

use of, 6-39

average prebuilt conflict resolution method, 6-18

B

backups

for replication, 7-17

using multiple conflict resolution methods for, 6-11

basic replication, 3-1 to ??

uses of, 1-10

Batch Size setting

DBMS_OFFLINE_OG package, 8-16

BEGIN_INSTANTIATION procedure

BEGIN_LOAD procedure

DBMS_OFFLINE_OG package, 8-17

BEGIN_TABLE_REORGANIZATION procedure

DBMS snapshot package, 7-25

BLOBs support, A-3

branch automation, A-3

bulk updates, 7-31

C

catalog, replication, 1-13

checking imported data, 7-17

circular dependencies in tables

restrictions on adding sites with to master groups, 2-33

CLOBs support, A-3

column groups

and update conflict resolution, 6-7

dropping, 6-15

shadow, 6-8

columns

adding and removing in column groups, 6-14

commands, SQL

ALTER SNAPSHOT LOG, 7-23

DROP SNAPSHOT LOG, 7-28

TRUNCATE, 7-25

TRUNCATE TABLE, 7-26

comments

on Oracle documentation, xxii

comments field

in views

Configuration folder, 2-38

complete refreshes, 3-22

complex snapshots, 3-5

value for PCTFREE, 3-22

value for PCTUSED, 3-22

conflicts

additive resolution method, 6-18

avoidance

dynamic ownership, 8-30

master sites, avoiding at, 6-5

detection

identifying rows during, 6-6

how Oracle detects, 6-6

maximum value conflict resolution method, 6-19

minimum value conflict resolution method, 6-19

notification

package, sample, 6-54

notification log

creating, 6-53

notification log table

sample, 6-53

notification methods

user-defined, 6-52

notification package

creating, 6-54

procedural replication, 1-15

resolution

auditing, 7-18

automatic versus manual, 6-7

configuration

overview, 6-12

declarative methods, update conflicts, 6-18

delete, 6-8

strategy, 8-28

delete, configuring, 6-37

design and preparation guidelines, 6-12

detecting conflicts, 6-5

gathering statistics, 7-18

highest priority, 6-31

in synchronous propagation, 8-8

information

viewing, 6-56

procedural replication and, 8-3

RepResolution_Statistics table, deleting, 7-19

statistics

canceling, 7-18

uniqueness, 6-8

configuring, 6-34

update

and column groups, 6-7

user-defined routines

parameters, 6-48

user-defined routines, example, 6-51

user-defined routines, restrictions, 6-51

viewing information, 6-56

resolution and notification methods

custom, 6-10

resolution methods, 6-8

average prebuilt, 6-18

delete, assigning, 6-37

delete, removing, 6-37

multiple

prebuilt, restrictions for, 6-9

uniqueness, assigning, 6-34

uniqueness, removing, 6-35

update

prebuilt, 6-8

user-defined, 6-48

using, for notification, 6-11

resolution methods for

removing, 6-17

resolution methods for column groups

update resolution

using site priority for, 6-29

constraint violations, 7-31

continuous pushes

scheduling, 2-14, 2-17

Create, 2-8

Create Master Sites dialog

setup wizard, 2-32

Create New Master Group property sheet

Destinations page, 2-19

General page, 2-19

Objects page, 2-19

Replication Manager, 2-19

Create New Scheduled Link property sheet, 2-12

General page, 2-12

Options page, 2-12

Create Refresh Group property sheet

General page, 5-29

Scheduling page, 5-29

Snapshots page, 5-29

Create Scheduled Link property sheet

setup wizard, 2-14, 2-17

Create Schema dialog

setup wizard, 2-9

CREATE_MASTER_REPGROUP procedure

DBMS_REPCAT package, 2-20

creating

deferred transactions, 9-2

site priority groups, 6-30

priority groups, 6-25

snapshots, 5-24

Customize Master Site property sheet

setup wizard, 2-10

D

data

convergence, 6-7

guaranteeing, 6-38

inconsistencies

removing after deleting master sites, 2-34

integrity

ensuring with multiple column groups, 6-7

parallel propagation, 2-43

serial propagation, 2-43

data dictionary

DBA_REGISTERED_SNAPSHOTS view, 7-37

data manipulation language (DML)

minimizing propagation, 6-42

data propagation

and dependency maintenance, 2-43

minimizing, 2-37

minimizing for update conflict resolution, 6-42

mode of

altering in a master site, 8-10

reduced, A-2

synchronous, 8-6

data replication

real-time, 8-6

data requirements

evaluating and understanding, 6-2

data subsetting, A-3

data warehouse

basic replication for, 1-11

database

links

using different paths, 2-20

preparing for multimaster replication, 2-7

Database Information property sheet

Replication Manager, 2-18

Database Link setting

Create Scheduled Link property sheet, 2-12

database link specifications

incomplete, 7-33

database links, 7-29

snapshot sites, for, 3-26

datatypes

allowed in replicated tables, 2-26

allowed in snapshots, 3-17, 5-26

support for, A-3

DBA_REGISTERED_SNAPSHOTS view, 7-37

DBA_SNAPSHOT_LOGS view, 7-37

DBMS_DEFER package

ADD_DEFAULT_DEST procedure, 9-6

CHAR_ARG procedure, 9-5

DATE_ARG procedure, 9-5

NUMBER_ARG procedure, 9-5

RAW_ARG procedure, 9-5

ROWID_ARG procedure, 9-5

TRANSACTION procedure, 9-4

VARCHAR2_ARG procedure, 9-5

DBMS_DEFER_SYS package

DELETE_DEFAULT_DEST procedure, 9-6

DISABLED procedure, 2-15

SCHEDULE_EXECUTION procedure, 2-13, 2-15, 2-17, 2-18

SCHEDULE_PUSH procedure, 2-13, 2-15, 2-17, 2-18

SET_DISABLED procedure, 2-15, 2-17, 2-18

UNSCHEDULE_PUSH procedure, 2-16

DBMS_OFFLINE_OG package

BEGIN_INSTANTIATION procedure, 8-16

BEGIN_LOAD procedure, 8-17

END_INSTANTIATION procedure, 8-17

END_LOAD procedure, 8-17

RESUME_SUBSET_OF_MASTERS procedure, 8-16

DBMS_RECTIFIER_DIFF package, 2-34, 7-19

DBMS_REPCAT package, 7-6

ADD_MASTER_DATABASE procedure, 2-33

ADD_PRIORITY_CHAR procedure, 6-25

ADD_PRIORITY_DATE procedure, 6-25

ADD_PRIORITY_NUMBER procedure, 6-25

ADD_PRIORITY_RAW procedure, 6-25

ADD_PRIORITY_VARCHAR2 procedure, 6-25

ADD_SITE_PRIORITY_SITE procedure, 6-30

ALTER_MASTER_REPOBJECT procedure, 2-29

ALTER_PRIORITY procedure, 6-27

ALTER_PRIORITY_CHAR procedure, 6-26

ALTER_PRIORITY_DATE procedure, 6-26

ALTER_PRIORITY_NUMBER procedure, 6-26

ALTER_PRIORITY_RAW procedure, 6-26

ALTER_PRIORITY_VARCHAR2 procedure, 6-26

ALTER_SITE_PRIORITY procedure, 6-30

ALTER_SITE_PRIORITY_SITE procedure, 6-31

CANCEL_STATISTICS procedure, 7-18

COMMENT_ON_COLUMN_GROUP procedure, 7-38

COMMENT_ON_DELETE resolution package, 7-38

COMMENT_ON_PRIORITY_GROUP procedure, 7-38

COMMENT_ON_REPCAT procedure, 7-38

COMMENT_ON_REPOBJECT procedure, 7-38

COMMENT_ON_REPSCHEMA procedure, 7-38

COMMENT_ON_UNIQUE resolution package, 7-38

COMMENT_ON_UPDATE resolution package, 7-38

CREATE_MASTER_REPGROUP procedure, 2-20

DEFINE_PRIORITY_GROUP procedure, 6-25

DEFINE_SITE_PRIORITY procedure, 6-30

DO_DEFERRED_REPCAT_ADMIN procedure, 7-6, 7-6 to 7-7

DROP_MASTER_REPGROUP procedure, 2-21

DROP_MASTER_REPOBJECT procedure, 2-31

DROP_PRIORITY procedure, 6-28

DROP_PRIORITY_CHAR procedure, 6-27

DROP_PRIORITY_DATE procedure, 6-27

DROP_PRIORITY_GROUP procedure, 6-28

DROP_PRIORITY_NUMBER procedure, 6-27

DROP_PRIORITY_RAW procedure, 6-27

DROP_PRIORITY_VARCHAR2 procedure, 6-27

DROP_SITE_PRIORITY procedure, 6-32

DROP_SITE_PRIORITY_SITE procedure, 6-31

EXECUTE_DDL procedure, 7-2

GENERATE_REPLICATION_SUPPORT procedure, 2-37

PURGE_STATISTICS procedure, 7-19

REGISTER_STATISTICS procedure, 7-18

RELOCATE_MASTERDEF procedure, 7-3

REMOVE_MASTER_DATABASES procedure, 2-34

REPCAT_IMPORT_CHECK procedure, 7-17

RESUME_MASTER_ACTIVITY procedure, 2-24

SET_COLUMNS procedure, 2-25

SUSPEND_MASTER_ACTIVITY procedure, 2-23

SWITCH_SNAPSHOT_MASTER procedure, 7-3

DBMS_REPUTIL package

REPLICATION_OFF procedure, 8-35

REPLICATION_ON procedure, 8-36

DBMS_SNAPSHOT package

BEGIN_TABLE_REORGANIZATION procedure, 7-25

END_TABLE_REORGANIZATION procedure, 7-25

PURGE_LOG procedure, 7-24

REGISTER_SNAPSHOT procedure, 7-37

UNREGISTER_SNAPSHOT procedure, 7-37

DDL

changes not propagated to master site, 7-30

executing within a master group, 7-2

propagating statements to master sites, 7-2

deadlocks

resolving

in synchronous propagation, 8-8

decision support application

basic replication for, 1-10

DefDefaultDest table

adding destinations to, 9-6

removing destinations from, 9-6

deferred constraints and updatable snapshots, A-4

deferred RPCs, 9-2

deferred transactions, 2-4

creating, 9-2

DefCall table, 9-5

DefCallDest table, 9-5

DefDefaultDest table

adding destination to, 9-6

removing destinations from, 9-6

deferred remote procedure calls (RPCs)

diagnosing problems with, 7-33

queue

clearing after deleting master sites, 2-34

purging, 2-5, 2-18

push, 2-4

starting, 9-4

Deferred Transactions by Dest folder, 7-9, 7-11

definition sites

relocating for a master group, 7-3

delay seconds

setup wizard, 2-17

Delay Seconds setting

replicated transactions, 2-43

delete conflicts, 6-3

avoiding, 6-5, 8-28

resolution, 6-8

configuring, 6-37

methods, assigning, 6-37

resolution methods

removing, 6-37

resolving, 6-50

deleting

master groups, 2-21

scheduled links, 2-16

snapshots, 5-28

dependency

ordering

tracking

parallel propagation, 2-43

deployment templates, 4-1

destination maps

displaying for master groups, 2-39

destination master sites

adding to master groups, 2-19, 2-32

Destinations page

detecting conflicts, 6-5, 6-6

diagnosing problems with, 7-29

DIFFERENCES

procedure, 7-19

DISABLED procedure

DBMS_DEFER_SYS package, 2-15

disabling replication, 8-34

discard

conflict resolution method, 6-21

use of, 6-39

discard uniqueness

conflict resolution method, 6-37

disconnected environments

as in advanced replication, 1-11

distributed transactions

problems with, 7-33

distributing application loads

as in advanced replication, 1-6

DML

changes not propagated to other sites, 7-31

DO_DEFERRED_REPCAT_ADMIN package, 7-6

DO_DEFERRED_REPCAT_ADMIN procedure

DBMS_REPCAT package, 7-6, 7-6 to 7-7

DROP SNAPSHOT LOG command, 7-28

DROP_MASTER_REPGROUP procedure

DBMS_REPCAT package, 2-21

DROP_MASTER_REPOBJECT procedure

DBMS_REPCAT package, 2-31

dropping

column groups, 6-15

priority group members

by priority, 6-28

by value, 6-27

priority groups, 6-28

site priority groups, 6-32

members of, 6-31

sites

by priority level, 6-32

snapshot logs, 7-28

dynamic ownership

conflict avoidance and, 8-30

workflow partitioning, 8-30

dynamic sites

ownership, 6-4

E

earliest and latest timestamp

conflict resolution methods, 6-20

Edit Database Destination property sheet

Replication Manager, 2-39

Edit DB Connection property sheet

setup wizard, 2-17

Edit Replication Object property sheet

Min(imize) Communications setting, 2-37

Edit Scheduled Link property sheet

Replication Manager, 2-15

setup wizard, 2-14

Edit Snapshot property sheet

Tablespace and Extents page, 5-27

Enabled setting

enabling replication, 8-34

END_INSTANTIATION procedure

DBMS_OFFLINE_OG package, 8-17

END_LOAD procedure

DBMS_OFFLINE_OG package, 8-17

END_TABLE_REORGANIZATION procedure

DBMS_SNAPSHOT package, 7-25

enhancements

new features, A-2

error

transactions

managing, 7-12

errors

transactions

displaying, 7-12

resolving, 7-13

examples

minimizing

communication, 6-43

EXECUTE_DDL procedure

DBMS_REPCAT package, 7-2

EXIST clause

offline instantiation of master site, 8-16

Export utility

F

fail-over sites

implementing, 8-14

failover sites

as in advanced replication, 1-5

fast refreshes, 3-22

and table reorg, A-4

features requiring migration, B-12

Feedback

on ORACLE documentation, xxii

filter columns

fine grained quiesce, A-3

Finish page

Replication Manager, 2-10

setup wizard, 2-10

force refreshes, 3-23

G

gen_rep_pack, 6-23

General page

Snapshot Log property sheet, 7-37

GENERATE_REPLICATION_SUPPORT procedure

DBMS_REPCAT package, 2-37

generated objects

displaying for master groups, 2-39

generated replication objects

wrapper package, 2-2

generating

replication support

procedural replication, 8-3

replication support and migration, B-3

generating replication support

migration and, B-8

group owner, 3-19

H

hybrid configurations

advanced replication, 1-12

I

Import utility

offline instantiation of master site, 8-17

import_check, 7-17

in basic replication, 1-11

incremental migration, B-4

indexes

partitioned tables and, A-4

information

distribution

in basic replication, 1-10

off-loading

in basic replication, 1-10

transport, 1-11

information distribution

basic replication for, 1-10

initialization parameters

JOB_QUEUE_INTERVAL, 7-7

JOB_QUEUE_PROCESSES, 7-7

PARALLEL_MAX_SERVERS, 2-42

PARALLEL_MIN_SERVERS, 2-42

PARALLEL_SERVER_IDLE_TIME, 2-42

INIT.ORA, 2-21

instantiation

offline, 8-14

in advanced replication, 8-17

of an advanced replication master site, 8-16

instantiation offline, A-4

internal triggers, A-2

intersection tables, ?? to 3-13

Interval Expression setting

Setup wizard, 2-16

Interval setting

Create Scheduled Link property sheet, 2-13

J

job queue process, 2-11

job queues, 2-4

JOB_QUEUE_INTERVAL initialization parameters, 7-7

JOB_QUEUE_PROCESSES initialization parameters, 7-7

jobs

breaking, 7-16

checking for scheduled links, 7-33

diagnosing problems with, 7-16

enabling, 7-16

local

displaying, 7-14

editing properties of, 7-15

manually executing, 7-15

joins

allowed in replicated tables, 2-26

L

large object types

latest timestamp

conflict resolution method, 6-20

link qualifiers

master groups, 2-20

link specifications

incomplete, 7-33

LOBs

omitting old values for, 6-42

support for, 2-26, 3-17, A-3

local jobs

displaying, 7-14

editing properties of, 7-15

M

management and use new features, A-3

management of master and snapshot groups

advanced, 7-2

managing update conflict resolution, 6-16

manual conflict resolution

versus automatic, 6-7

manual refreshes, 3-24

many-to-many references

simple subquery snapshots, 3-13

many-to-one references

simple subquery snapshots, 3-13

mass deployment, 4-2, A-3

master and snapshot groups

advanced management of, 7-2

master definition sites, 1-4

master groups, 1-4

adding destination master sites, 2-31, 2-32

adding replication objects, 2-19, 2-24

adding sites with tables having circular dependencies, 2-33

adding sites with tables having self-referential constraints, 2-33

administration requests

deleting, 7-6

altering object definition, 2-28

applying administration requests for, 7-5

creating, 2-19

definition sites for

relocating, 7-3

deleting, 2-21

deleting master sites from, 2-33

destination master sites, 2-19

displaying destination maps for, 2-39

displaying generated objects, 2-39

executing DDL within, 7-2

generating replication support for changes, 2-35

link qualifiers, 2-20

listing, 2-38

listing objects in, 2-38

managing, 2-19 to ??

objects

generating support for, 2-36

propagating DDL to sites in, 7-2

removing replication objects, 2-30

resuming replication activity, 2-23

suspending replication activity, 2-22

viewing information about, 2-38

Master Groups folder, 2-38

master sites, 1-4

master sites and migration, B-2

master table

columns

number restriction for simple subquery snapshots, 3-13

reorganizing, 7-25

master tables

reorganizing

methods, 7-26 to 7-28

truncating, 7-26

maximum value conflict resolution method, 6-19

members

altering priority for, 6-27

migration

features requiring, B-12

incremental, B-4

master sites, B-2

obsolete procedures, B-13

overview, B-2

snapshot sites, B-6

upgrading to primary key snapshots, B-10

using import and export, B-9

Min(imize) Communications setting

Edit Replication Object property sheet, 2-37

min_communication

examples of, 6-43

Minimize Communication setting

Replication Manager, 5-11

minimizing

updates and min_communication, 6-43

minimum value conflict resolution method, 6-19

mode of propagation, 8-9

modifying

tables

without replicating changes, 8-34

multimaster replication, 1-5

multiple column groups

ensuring data integrity with, 6-7

multiple conflicts

resolution methods

for backups, 6-11

using, 6-10

using for notification, 6-11

N

NCLOB support, A-3

new features

data subsetting and subqueries, A-3

enhanced security, A-4

for management and use, A-3

LOB support, A-3

performance, A-2

subqueries for snapshots, A-3

subquery snapshots, A-3

New Master Site dialog

setup wizard, 2-8

Next Date setting

Create New Scheduled Link property sheet, 2-12

Setup wizard, 2-16

notification

methods

custom, for conflict resolution, 6-10

using multiple conflict resolution methods for, 6-11

notification log

conflict

creating, 6-53

notification log table

conflict

sample, 6-53

notification methods

user-defined, 6-52

notification package

conflict

creating, 6-54

O

objects

altering in a master group, 2-28

definitions

replication to master sites, 2-26

master groups

generating support for, 2-36

removing from master groups, 2-30

replicated

re-creating, 7-32

Objects page

offline instantiation, 2-28

obsolete procedures, B-13

master sites, 8-16 to 8-17

support for, A-4

OPEN_LINKS initialization parameters

initialization parameters

OPEN_LINK, 2-21

Options page, 7-23

Oracle Replication Manager, 1-13

Oracle7

and min_communication, 5-11

Oracle8

features and migration, B-12

ordering

conflict resolution methods for column groups, 6-17

ordering conflicts

avoiding, 6-40

overwrite

conflict resolution method

use of, 6-39

conflict resolution methods, 6-21

P

parallel propagation, 2-4, A-2

advanced replication environment, 2-40 to 2-42

dependency

tracking, 2-43

planning for, 2-40

Parallel Propagation setting

configuring for advanced replication environments, 2-41

parallel server processes

PARALLEL_MAX_SERVERS initialization parameters, 2-42

PARALLEL_MIN_SERVERS initialization parameters, 2-42

PARALLEL_SERVER_IDLE_TIME initialization parameters, 2-42

partitioned tables

indexes and, A-4

partitions

replication and, 2-26

PCTFREE

value for complex snapshots, 3-22

PCTUSED

value for complex snapshots, 3-22

performance enhancements, A-2

periodic purges

scheduling, 2-18

periodic pushes

scheduling, 2-14

pgroup, 6-23

PL/SQL triggers

using with snapshot base tables, 5-27

prebuilt conflicts

resolution methods

restrictions for, 6-9

prebuilt uniqueness conflicts

resolution methods, 6-9

prebuilt update conflict resolution methods, 6-18

prebuilt update conflicts

resolution methods, 6-8

PRESERVE SNAPSHOT LOG option

TRUNCATE TABLE command, 7-26

PRIMARY KEY constraint

simple subquery snapshots and, 3-13

primary key snapshots, A-3

primary keys

missing from replicated tables, 2-20

upgrading snapshots, B-10

primary sites

ownership, 6-4

priority group members

dropping, 6-28

dropping by value, 6-27

priority groups, 6-23

adding members to, 6-25

altering members

priorities, 6-27

values, 6-26

and site priority, 6-22

dropping members

using for conflict resolution, 6-23

priority level of sites

altering, 6-30

priority_groups, 6-22

privileges

deleting rows from snapshot logs, 7-25

procedural replication, 1-14

conflicts and, 8-3

deleting and, 8-28

detecting conflicts, 1-15

generating support for, 8-3

restrictions, 8-2

using, 8-2

wrapper, 1-15

Processes setting

altering in a master site, 8-10

propagation

minimizing data, 6-42

mode of, 8-9

parallel, 2-4, A-2

security context of propagator, 8-7

serial, 2-4

setting default characteristics, 2-9

propagation reduction, A-2

propagator, 2-5

propagator accounts

TRUNCATE TABLE command, 7-26

PURGE SNAPSHOT LOG option

PURGE_LOG procedure

DBMS_SNAPSHOT package, 7-24

purges

manual, 2-18

periodic

scheduling, 2-18

purging

deferred transaction queue, 2-16

snapshot logs, 7-24

pushes

continuous

scheduling, 2-14, 2-17

periodic

scheduling, 2-14

Q

queue

deferred transactions, 2-4

quiescing

and fine grained quiesce, A-3

master groups, 2-22

R

read-only replication

uses of, 1-10

read-only snapshot, 1-7

read-only snapshots, 3-7

registration, 7-37

manual, 7-37

unregistering, 7-37

real-time

data replication, 1-15

replication, 1-15, 8-6

receiver, 2-5

accounts

advanced replication, 8-36

recovery, 7-17

for replication, 7-17

RECTIFY

procedure, 7-19

rectifying

tables, 7-19

re-enabling

refresh

failures, 7-34

fast and table reorg, A-4

retries, 7-34

refresh groups

creating

for snapshot sites, 5-29

managing, ?? to 7-35

manual refresh, 3-24

snapshots, 5-28

troubleshooting refresh, 7-34

refresh intervals

parameter constraints, 3-24

snapshot refresh groups, 3-24

refresh types

manual, 3-24

REGISTER_SNAPSHOT procedure

DBMS_SNAPSHOT package, 7-37

registering

snapshots, A-4

RELOCATE_MASTERDEF procedure

DBMS_REPCAT package, 7-3

remote procedure calls, 2-4

deferring, 9-5

REMOVE_MASTER_DATABASES procedure

DBMS_REPCAT package, 2-34

removing

columns in column groups, 6-14

conflict resolution methods, 6-17

RepCat table

REPCATLOG view, 2-40, 7-6 to 7-8

RepColumn_Group table

determining differences in tables, 7-19

REPGROUP view, 2-40

replicated environment

replicated objects

at snapshot sites

problems creating, 7-34

re-creating, 7-32

replicated procedures

generating support for, 8-3

replicated tables

alternate keys for, 2-25

and DML incompatibility, 7-31

datatypes allowed, 2-26

differences between, 7-19

populating manually, 2-27

replicated transactions

dependency ordering, 2-43

replication

administrator, 2-5

advanced

introduction to conflicts, 6-2

re-enabling, 8-36

advanced techniques, 8-1 to 8-37

advanced, uses for, 1-5

backup and recovery for, 7-17

basic, 3-1 to ??

catalog, 1-13

conflicts

procedural replication, 1-15

definition, 1-2

disabling, 8-34, 8-35

enabling, 8-34

environment

advanced

adding new sites to, 8-8

group, 1-2

multimaster, 2-1 to 2-44

advanced options, 2-40 to 2-44

building environment

example, 2-6

monitoring, 2-38 to 2-40, 7-4 to 7-16

objects

generated, 2-2

of object definitions to master sites, 2-26

manual, 2-27

off/on affects current session, 8-35

resuming for master groups, 2-23

sites, 1-4

suspending for master groups, 2-22

triggers, 8-36

uses of read-only, 1-10

replication catalog view

incorrect, 7-33

replication groups

master sites

managing, 2-19 to ??

replication management API, 1-13

Replication Manager, 1-13

administration requests, 7-4 to 7-8

Create New Scheduled Link property sheet, 2-12

Edit Database Destination property sheet, 2-39

Finish page, 2-10

Scheduled Links folder, 2-15

Scheduling folder, 2-15

Set Alternate Key Columns dialog, 2-20, 2-25

Set Date dialog, 2-12, 2-16

Set Interval dialog, 2-13, 2-16

Set Scheduled Link dialog, 2-12

setup wizard, 2-7

replication objects, 1-2

adding to master groups, 2-19, 2-24

altering definition, 2-28

deleting from master groups, 2-30

replication support

for tables

unable to generate, 7-32

generating for all master group tables, 2-37

generating for master groups, 2-35

generation for objects, 2-36

replication tables

updating Comments, 7-38

replication triggers, A-2

RepObject table

REPOBJECT view, 2-40

RepPriority_Group table

RepResolution table

gathering statistics, 7-18

RepResolution_Statistics table

purging, 7-19

RepResolution_Statistics view

RepSchema table

maximum value method, 6-19

REPSITES view, 2-40

resolution methods

additive prebuilt, 6-18

average prebuilt, 6-18

discard, 6-21

earliest timestamp, 6-20

for column groups

ordering, 6-17

for conflicts

removing, 6-17

latest timestamp, 6-20

managing, 6-16

minimum value method, 6-19

overwrite, 6-21

resolution statistics

gathering, 7-18

viewing, 7-18

restrictions

procedural replication, 8-2

RESUME_MASTER_ACTIVITY procedure

DBMS_REPCAT package, 2-24

RESUME_SUBSET_OF_MASTERS procedure

DBMS_OFFLINE_OG package, 8-16

rollback segments

setup wizard, 2-16

ROWID snapshots, 3-5

row-level replication, 2-2

detecting conflicts, 6-5

rows

identifying during conflict detection, 6-6

RPC, 2-4

S

SCHEDULE_EXECUTION procedure

DBMS_DEFER_SYS package, 2-13, 2-15, 2-17, 2-18

SCHEDULE_PUSH procedure

DBMS_DEFER_SYS package, 2-13, 2-15, 2-17, 2-18

scheduled links

continuous pushes, 2-14, 2-17

creating, 2-12

database link to use, 2-12

number of background processes used, 2-13

parallel propagation, 2-13, 2-40 to 2-42

periodic pushes, 2-14

serial propagation, 2-13, 2-40

viewing status, 2-15

Scheduled Links folder

Replication Manager, 2-15

scheduled purges

editing, 2-18

guidelines, 2-17

periodic purges, 2-18

Scheduling folder

Replication Manager, 2-15

Scheduling page

Create Refresh Group property sheet, 5-29

schema

creating for snapshots, 3-25

Schema Manager

Snapshot Log property sheet, 7-37

schemas

creating for multimaster replication, 2-9

security, A-4

for multimaster replication, 8-18

for snapshot replication, 8-24

self-referential constraints in tables

adding sites with to master groups, 2-33

serial propagation, 2-4

scheduled links, 2-13

serialization

of transactions, 8-3

Set Alternate Key Columns dialog

Replication Manager, 2-20, 2-25

Set Date dialog

Replication Manager, 2-12, 2-16

Set Interval dialog

Replication Manager, 2-13, 2-16

Set Scheduled Link dialog

Replication Manager, 2-12

SET_COLUMNS procedure

DBMS_REPCAT package, 2-25

SET_DISABLED procedure

DBMS_DEFER_SYS package, 2-15, 2-17, 2-18

setup wizard

Create Master Sites page, 2-32

Create Scheduled Link property sheet, 2-14, 2-17

Create Schema dialog, 2-9

creating

administrator accounts, 2-8

propagator accounts, 2-8

receiver accounts, 2-8

Customize Master Site property sheet, 2-10

Edit DB Connection property sheet, 2-17, 2-18

Edit Scheduled Link property sheet, 2-14

Finish page, 2-10

New Master Site dialog, 2-8

Replication Manager, 2-7

shadow column groups, 6-8

simple subquery snapshots

many-to-many references, 3-13

many-to-one references, 3-13

site ownership

dynamic, 6-4

primary, 6-4

site priority

as a backup method during timestamp conflict resolution, 6-20

managing, 6-29

site priority groups, 6-29

adding members to, 6-30

altering members

dropping members, 6-31

using, 6-29

sites

dropping by priority level, 6-32

snapshot

read-only, 1-7, 3-7

updateable, 1-8

snapshot group

group owner, 3-19

snapshot groups

managing, 5-6 to 5-23

Snapshot Log property sheet, 7-23

snapshot logs

privileges required, 7-23

deleting rows

privileges required, 7-25

dropping, 7-28

privileges required, 7-28

filter columns

master table

privileges required, 7-24

reducing space allocated to, 7-24

reorganizing master tables with, 7-25

truncating, 7-24

privileges required, 7-25

truncating master table with, 7-26

underlying table for, 3-15

snapshot refresh groups

managing, ?? to 7-35

snapshot refreshes

complete, 3-22

fast, 3-22

force, 3-23

group

refresh interval, 3-24

snapshot registration at master sites, A-4

snapshot site replication, 5-1 to 5-32

snapshot sites

creating refresh groups for, 5-29

database links for, 3-26

offline instantiation

advanced replication, 8-17

scheduled links for, 2-12

guidelines, 2-14

scheduled purge for

guidelines, 2-17

snapshot sites and migration, B-6

snapshots

altering definition, 5-27

cloning

offline instantiation, 8-14

cloning for basic replication, 8-15

complex, 3-5

value for PCTFREE, 3-22

value for PCTUSED, 3-22

creating, 5-24

creating schema for, 3-25

datatypes supported, 3-17, 5-26

deleting from snapshot groups, 5-28

editing, 5-27

editing storage settings, 5-27

enabling/disabling replication for, 8-37

group, 1-4

groups

advanced management of, 7-2

managing, 5-23 to ??

managing base table, 5-27

primary key, A-3

read-only

registration, 7-37

simple with subqueries, A-3

unregistering, 7-37

refresh, 3-22, 3-24

failures, 7-34

querying for last refresh time, 7-37

retries, 7-34

troubleshooting, 7-34, 7-35

refresh groups, 5-28

replication

security for, 8-24

ROWID, 3-5

simple subquery

AND expression and, 3-13

EXISTS clause and, 3-13

filter columns requirement, 3-13

joins and, 3-13

number of columns in master tables, 3-13

site, 1-4

sites

changing masters, 7-3

trace file, 7-35

troubleshooting, 7-34

updatable

deferred constraints, A-4

updating, 3-22

upgrading to primary key, B-10

using PL/SQL triggers with base tables, 5-27

viewing information about, 7-37

Snapshots page

Create Refresh Group property sheet, 5-29

SNP background processes, 2-11

space

reducing snapshot log, 7-24

statistics

auditing conflict resolution, 7-18

deleting, 7-19

for conflict resolution, 7-18

Stop on Error setting