Index

DBMS_REPCAT package, 3-25

ADD_MASTER_DATABASE procedure

adding

columns in column groups, 5-14

priority group members, 5-24

site priority group members, 5-29

sites

to an advanced replication environment, 7-8

additive prebuilt conflict resolution method, 5-16

Admin Requests folder, 6-5

Administration folder, 6-9, 6-11

administration requests, 1-19, 6-4 to 6-8

applying, 6-5

deleting, 6-6

diagnosing problems with, 6-8

displaying, 6-5

administrator

account

snapshot sites, 4-5, 4-7

administrator accounts

advanced replication, 3-1 to 7-35

asynchronous propagation, 1-21

deferred transactions and, 1-22

disabling, 7-33

hybrid configurations, 1-16

job queues and, 1-22

multimaster, 3-1 to 3-35

multimaster configuration, 1-14

row-level replication, 1-20

RPCs and, 1-22

snapshot sites

offline instantiation of, 7-17

replication, 4-1 to 4-24

security setup, 7-24

synchronous propagation, 1-28, 7-6

techniques, 7-1 to 7-35

transaction propagation protection, 3-33 to 3-34

updatable snapshots, 1-15

uses for, 1-13

advanced replication systems

monitoring, 6-4

Alter Replication Object dialog

Replication Manager, 3-23

ALTER SNAPSHOT command

REFRESH clause, 2-44

ALTER SNAPSHOT LOG command, 2-28

ALTER_MASTER_REPOBJECT procedure

DBMS_REPCAT package, 3-23

ALTER_SNAPSHOT_PROPAGATION procedure

DBMS_REPCAT package, 4-16

altering

priority group members

priorities, 5-25

values, 5-25

priority levels, 9-91

propagation method, 9-87, 9-99

replicated objects, 9-89

site priority group members

priorities, 5-29

values, 5-30

snapshot definitions, 4-21

snapshots

required privileges, 2-36

alternate keys

detecting conflicts and, 1-26

in replicated tables, 3-20

AND expression

for simple subquery snapshots, 2-24

append sequences

conflict resolution methods, 5-34

append site names

conflict resolution methods, 5-34

assigning

update conflict resolution methods, 5-15

asynchronous

DDL, 9-141

replication, 1-21

RPCs, 8-3

auditing, 6-16

conflict resolution, 6-16

automatic conflict resolution

versus manual, 5-7

automatic refreshes

refresh group, 1-10

refresh interval, 1-10

average

conflict resolution method

use of, 5-38

average prebuilt conflict resolution method, 5-16

B

backups

for replication, 6-15

using multiple conflict resolution methods for, 5-11

basic replication, 1-2, 1-4 to 1-12, 2-1 to 2-44

configuring environment, 2-2 to 2-27

example, 2-2

designing environment, 2-2

environment

read-only snapshots, 2-34 to 2-37

managing environment, 2-27 to 2-44

monitoring environment, 2-44

privileges in, 2-5

SNP background processes for, 2-6

uses of, 1-4

Batch Size setting

DBMS_OFFLINE_OG package, 7-16

BEGIN_INSTANTIATION procedure

BEGIN_LOAD procedure

DBMS_OFFLINE_OG package, 7-17

BEGIN_TABLE_REORGANIZATION procedure

DBMS snapshot package, 2-31

BLOBs support, A-3

branch automation, A-2

bulk updates, 6-24

C

catalog, replication, 1-19

CHANGE procedure

checking imported data, 6-15

circular dependencies in tables

restrictions on adding sites with to master groups, 3-25

CLOBs support, A-3

Cluster page

Create Snapshot property sheet, 2-15

clustering snapshots, 2-15

column groups, 1-26

adding members to

syntax, 9-75

and update conflict resolution, 5-7

creating

syntax, 9-119, 9-152

dropping, 5-14

syntax, 9-124

removing members from

syntax, 9-125

shadow, 1-27, 5-7

columns

adding and removing in column groups, 5-14

commands, SQL

ALTER SNAPSHOT LOG, 2-28

CREATE SNAPSHOT, 2-7, 2-10, 2-19 to 2-21

CREATE SNAPSHOT LOG, 2-7, 2-17

CREATE TABLE, 2-16

DROP SNAPSHOT, 2-36

DROP SNAPSHOT LOG, 2-33

TRUNCATE, 2-30

TRUNCATE TABLE, 2-31

comments

on Oracle documentation, vi

comments field

in views

complex snapshots, 1-11, 2-41

comparing

tables, 9-55

complete refreshes, 1-9

value for PCTFREE, 2-43

value for PCTUSED, 2-43

configuration

basic replication environment, 2-2 to 2-27

example, 2-2

Configuration folder, 3-29, 6-5

conflicts

additive resolution method, 5-16

avoidance

dynamic ownership, 7-27

avoiding, 5-4

column groups and, 1-26

data models and, 1-24

delete, 1-24, 5-3

master sites, avoiding at, 5-5

detecting, 1-26, 5-5, 7-8

detection

identifying rows during, 5-6

how Oracle detects, 5-6

maximum value conflict resolution method, 5-17

minimum value conflict resolution method, 5-17

notification

package, sample, 5-52

notification log

notification log table

sample, 5-51

notification methods

user-defined, 5-50

notification package

automatic versus manual, 5-7

replication, 1-24

resolution, 1-26

adding method of, 9-83

auditing, 6-16

configuration

overview, 5-12

declarative methods, update conflicts, 5-16

delete, 5-8

strategy, 7-25

delete, configuring, 5-36

design and preparation guidelines, 5-12

detecting conflicts, 5-5

gathering statistics, 6-16

highest priority, 5-29

in synchronous propagation, 7-7

information

viewing, 5-54

methods, 1-27

procedural replication and, 7-3

RepResolution_Statistics table, deleting, 6-17

statistics, 9-101, 9-160

canceling, 6-17

uniqueness, 5-8

configuring, 5-33

update

and column groups, 5-7

user-defined routines

parameters, 5-46

user-defined routines, example, 5-49

user-defined routines, restrictions, 5-48

viewing information, 5-54

resolution and notification methods

custom, 5-10

resolution methods, 5-8

average prebuilt, 5-16

delete, assigning, 5-36

delete, removing, 5-36

discard, 5-19

managing, 5-15

multiple

using, 5-10

overwrite, 5-19

prebuilt, restrictions for, 5-9

uniqueness, assigning, 5-33

uniqueness, removing, 5-33

update

prebuilt, 5-8

user-defined, 5-46

using, for notification, 5-11

resolution methods for

removing, 5-15

resolution methods for column groups

ordering, 5-15

row-level replication, 1-26

uniqueness, 1-24, 5-3

update, 1-24, 5-3

using site priority for, 5-28

update resolution

connection qualifiers

master groups, 3-16

constraint violations, 6-24

continuous pushes

scheduling, 3-11, 3-13

Create, 3-5

Create Master Sites dialog

setup wizard, 3-24

Create New Master Group property sheet

Destinations page, 3-15

General page, 3-15

Objects page, 3-15

Replication Manager, 3-15

CREATE SNAPSHOT command, 2-7, 2-10, 2-19 to 2-21

General page, 3-9

Options page, 3-9

Create Refresh Group property sheet

General page, 4-22

Next Date field, 2-26

Replication Manager, 4-3

Scheduling page, 4-22

Snapshots page, 4-22

Create Scheduled Link property sheet

setup wizard, 3-11, 3-13

REFRESH clause, 2-44

CREATE SNAPSHOT LOG command, 2-17

Create Snapshot Log property sheet

Filter Columns page, 4-11

General page, 4-11

Options page, 2-8

Replication Manager, 4-3, 4-11

Storage page, 2-8

Tablespace and Extents page, 4-11

Create Snapshot property sheet

Cluster page, 2-15

Options page, 2-14

Storage page, 2-14

CREATE TABLE command, 2-16

CREATE_MASTER_REPGROUP procedure

DBMS_REPCAT package, 3-16

creating

basic replication environment, 2-2 to 2-27

example, 2-2

column groups

syntax, 9-119, 9-152

database links for snapshot, 2-2

deferred transactions, 8-3

priority groups, 5-23, 9-120

refresh groups, 9-67

replicated object groups

syntax, 9-110

replicated objects

generating support for, 9-143, 9-144, 9-147

snapshot sites, 9-116

syntax, 9-111

site priority groups, 5-28

syntax, 9-122

snapshot logs, 2-3, 2-6

snapshot refresh groups, 2-3

snapshot sites

syntax, 9-114

snapshots, 2-3, 4-17

simple, 2-10

Customize Master Site property sheet

setup wizard, 3-7

Customize Snapshot Site property sheet

setup wizard, 4-8

D

data

convergence, 5-6

guaranteeing, 5-37

inconsistencies

removing after deleting master sites, 3-26

integrity

ensuring with multiple column groups, 5-7

parallel propagation, 3-34

serial propagation, 3-34

data cluster

creating snapshots as part of, 2-15

data definition language (DDL)

supplying asynchronous, 9-141

data dictionary

DBA_REGISTERED_SNAPSHOTS view, 2-35

data dictionary views, 10-2

DEFCALL, 10-20

DEFCALLDEST, 10-20

DEFDEFAULTDEST, 10-21

DEFERRCOUNT, 10-21

deferred transactions, 10-19

REFRESH_CHILDREN, 10-31

REGISTERED_SNAPSHOTS, 10-27

REPCATLOG, 10-5

REPCOLUMN, 10-6

REPCOLUMN_GROUP, 10-6

REPGROUPED_COLUMN, 10-9

REPKEY_COLUMNS, 10-9

REPOBJECT, 10-10

REPPARAMETER_COLUMN, 10-11

REPPRIORITY, 10-12

REPPRIORITY_GROUP, 10-13

REPPROP, 10-13

REPRESOL_STATS_CONTROL, 10-15

REPRESOLUTION, 10-14

REPRESOLUTION_METHOD, 10-15

REPRESOLUTION_STATISTICS, 10-16

REPSITES, 10-17

SNAPSHOT_REFRESH_TIMES, 10-29

SNAPSHOTS, 10-26

snapshots, 10-25

SNAPSHOTS_LOGS, 10-28

data manipulation language (DML)

minimizing propagation, 5-40

data ownership models, 1-24

dynamic ownership, 1-25

primary ownership, 1-25

shared ownership, 1-25

static ownership, 1-25

data propagation

and dependency maintenance, 3-33

minimizing, 3-28

minimizing for update conflict resolution, 5-40

mode of

altering in a master site, 7-10

reduced, A-2

synchronous, 7-6

data replication

real-time, 7-6

data requirements

evaluating and understanding, 5-2

data subsetting, A-2

data warehouse

basic replication for, 1-5

database

links

using different paths, 3-16

preparing for multimaster replication, 3-4

Database Link setting

creating for snapshot site, 2-2

database link specifications

incomplete, 6-25

database links, 6-22

snapshot sites, for, 2-5

database objects

for read-only snapshot, 1-7

Database Objects folder

master definition sites, 3-19

datatypes

allowed in replicated tables, 3-20

allowed in snapshots, 2-12, 4-18

support for, A-3

DBA_REFRESH view, 2-44

DBA_REFRESH_CHILDREN view, 2-44

DBA_REGISTERED_SNAPSHOTS view, 2-35, 2-44

DBA_RGROUP view, 2-44

DBA_SNAPSHOT_LOGS view, 2-35, 2-44

DBA_SNAPSHOTS view, 2-44

DBMS_DEFER package

ADD_DEFAULT_DEST procedure, 8-6

CALL procedure, 9-5

CHAR_ARG procedure, 8-5, 9-8

COMMIT_WORK procedure, 9-7

datatype_ARG procedure, 9-8

DATE_ARG procedure, 8-5, 9-8

NUMBER_ARG procedure, 8-5, 9-8

RAW_ARG procedure, 8-5, 9-8

ROWID_ARG procedure, 8-5, 9-8

TRANSACTION procedure, 8-4, 9-9

VARCHAR2_ARG procedure, 8-5, 9-8

DBMS_DEFER_QUERY package

GET_ARG_TYPE procedure, 9-12

GET_CALL_ARGS procedure, 9-14

GET_CHAR_ARG procedure, 9-16

GET_DATE_ARG procedure, 9-16

GET_NUMBER_ARG procedure, 9-16

GET_RAW_ARG procedure, 9-16

GET_ROWID_ARG procedure, 9-16

GET_VARCHAR2_ARG procedure, 9-16

DBMS_DEFER_SYS package

ADD_DEFAULT_DEST procedure, 9-19

DELETE_DEF_DESTINATION procedure, 9-21

DELETE_DEFAULT_DEST procedure, 8-6, 9-20

DELETE_ERROR procedure, 9-22

DELETE_TRAN procedure, 9-23

DISABLED function, 9-24

DISABLED procedure, 3-12

EXCLUDE_PUSH function, 9-25

EXECUTE_ERROR procedure, 9-26

PURGE procedure, 9-28

PUSH procedure, 9-31

SCHEDULE_EXECUTION procedure, 3-10, 3-11, 3-13, 3-14, 9-37

SCHEDULE_PURGE procedure, 9-35

SCHEDULE_PUSH procedure, 3-10, 3-11, 3-13, 3-14, 9-37

SET_DISABLED procedure, 3-11, 3-13, 3-14, 9-40

UNSCHEDULE_PURGE procedure, 9-42

UNSCHEDULE_PUSH procedure, 3-12, 9-43

DBMS_OFFLINE_OG package

BEGIN_INSTANTIATION procedure, 7-16, 9-45

BEGIN_LOAD procedure, 7-17, 9-46

END_INSTANTIATION procedure, 7-17, 9-47

END_LOAD procedure, 7-17, 9-48

RESUME_SUBSET_OF_MASTERS procedure, 7-16, 9-49

DBMS_OFFLINE_SNAPSHOT package

BEGIN_LOAD procedure, 9-51

END_LOAD procedure, 9-53

DBMS_RECTIFIER_DIFF package, 3-26, 6-17

DIFFERENCES procedure, 9-55

RECTIFY procedure, 9-59

DBMS_REFRESH package

ADD procedure, 2-38, 9-63

CHANGE procedure, 2-38, 9-64

DESTROY procedure, 2-38, 9-66

MAKE procedure, 4-22, 9-67

REFRESH procedure, 2-39, 9-70

SUBTRACT procedure, 2-38, 9-71

DBMS_REPCAT package, 6-6

ADD_DELETE_RESOLUTION procedure, 9-83

ADD_GROUPED_COLUMN procedure, 9-75

ADD_MASTER_DATABASE procedure, 3-25, 9-77

ADD_PRIORITY_CHAR procedure, 5-24, 9-79

ADD_PRIORITY_DATE procedure, 5-24, 9-79

ADD_PRIORITY_NUMBER procedure, 5-24, 9-79

ADD_PRIORITY_RAW procedure, 5-24, 9-79

ADD_PRIORITY_VARCHAR2 procedure, 5-24, 9-79

ADD_SITE_PRIORITY_SITE procedure, 5-29, 9-81

ADD_UNIQUE_RESOLUTION procedure, 9-83

ADD_UPDATE_RESOLUTION procedure, 9-83

ALTER_MASTER_PROPAGATION procedure, 9-87

ALTER_MASTER_REPOBJECT procedure, 3-23, 9-89

ALTER_PRIORITY procedure, 5-25, 9-91

ALTER_PRIORITY_CHAR procedure, 5-25, 9-93

ALTER_PRIORITY_DATE procedure, 5-25, 9-93

ALTER_PRIORITY_NUMBER procedure, 5-25, 9-93

ALTER_PRIORITY_RAW procedure, 5-25, 9-93

ALTER_PRIORITY_VARCHAR2 procedure, 5-25, 9-93

ALTER_SITE_PRIORITY procedure, 5-29, 9-95

ALTER_SITE_PRIORITY_SITE procedure, 5-30, 9-97

ALTER_SNAPSHOT_PROPAGATION procedure, 9-99

CANCEL_STATISTICS procedure, 6-17, 9-101

COMMENT_ON_COLUMN_GROUP procedure, 6-28, 9-102

COMMENT_ON_DELETE resolution package, 6-28

COMMENT_ON_DELETE_RESOLUTION procedure, 9-108

COMMENT_ON_PRIORITY_GROUP procedure, 6-28, 9-103

COMMENT_ON_REPCAT procedure, 6-28

COMMENT_ON_REPGROUP procedure, 9-105

COMMENT_ON_REPOBJECT procedure, 6-28, 9-107

COMMENT_ON_REPSCHEMA procedure, 6-28

COMMENT_ON_REPSITES procedure, 9-106

COMMENT_ON_SITE_PRIORITY procedure, 9-103

COMMENT_ON_UNIQUE resolution package, 6-28

COMMENT_ON_UNIQUE_RESOLUTION procedure, 9-108

COMMENT_ON_UPDATE resolution package, 6-28

COMMENT_ON_UPDATE_RESOLUTION procedure, 9-108

CREATE_MASTER_REPGROUP procedure, 3-16, 9-110

CREATE_MASTER_REPOBJECT procedure, 9-111

CREATE_SNAPSHOT_REPGROUP procedure, 9-114

CREATE_SNAPSHOT_REPOBJECT procedure, 9-116

DEFINE_COLUMN_GROUP procedure, 9-119

DEFINE_PRIORITY_GROUP procedure, 5-23, 9-120

DEFINE_SITE_PRIORITY procedure, 5-28, 9-122

DO_DEFERRED_REPCAT_ADMIN procedure, 6-5, 6-6 to 6-7, 9-123

DROP_COLUMN_GROUP procedure, 9-124

DROP_GROUPED_COLUMN procedure, 9-125

DROP_MASTER_REPGROUP procedure, 3-17, 9-127

DROP_MASTER_REPOBJECT procedure, 3-24, 9-129

DROP_PRIORITY procedure, 5-27, 9-131

DROP_PRIORITY_CHAR procedure, 5-26, 9-133

DROP_PRIORITY_DATE procedure, 5-26, 9-133

DROP_PRIORITY_GROUP procedure, 5-27, 9-132

DROP_PRIORITY_NUMBER procedure, 5-26, 9-133

DROP_PRIORITY_RAW procedure, 5-26, 9-133

DROP_PRIORITY_VARCHAR2 procedure, 5-26, 9-133

DROP_SITE_PRIORITY procedure, 5-30, 9-135

DROP_SITE_PRIORITY_SITE procedure, 5-30, 9-136

DROP_SNAPSHOT_REPGROUP procedure, 9-137

DROP_SNAPSHOT_REPOBJECT procedure, 4-21, 9-138

EXECUTE_DDL procedure, 6-2, 9-141

GENERATE_REPLICATION_PACKAGE procedure, 9-143

GENERATE_REPLICATION_SUPPORT procedure, 3-28, 9-144

GENERATE_REPLICATION_TRIGGER procedure, 9-147

GENERATE_SNAPSHOT_SUPPORT, 9-150

MAKE_COLUMN_GROUP procedure, 9-152

PURGE_MASTER_LOG procedure, 9-154

PURGE_STATISTICS procedure, 6-17, 9-155

REFRESH_SNAPSHOT_REPGROUP procedure, 9-156

REGISTER_STATISTICS procedure, 6-16, 9-160

RELOCATE_MASTERDEF procedure, 6-3, 9-161

REMOVE_MASTER_DATABASES procedure, 3-25, 9-163

REPCAT_IMPORT_CHECK procedure, 6-15, 9-165

RESUME_MASTER_ACTIVITY procedure, 3-19, 9-166

SET_COLUMNS procedure, 3-20, 9-169

SUSPEND_MASTER_ACTIVITY procedure, 3-18, 9-171

SWITCH_SNAPSHOT_MASTER procedure, 4-16, 6-3, 9-172

VALIDATE procedure, 9-174

WAIT_MASTER_LOG procedure, 9-177

DBMS_REPCAT_ADMIN package

GRANT_ADMIN_ANY_SCHEMA procedure, 9-179

GRANT_ADMIN_SCHEMA procedure, 9-180

REVOKE_ADMIN_ANY_SCHEMA procedure, 9-181

REVOKE_ADMIN_SCHEMA procedure, 9-182

DBMS_REPCAT_AUTH package

GRANT_SURROGATE_REPCAT procedure, 9-184

REVOKE_SURROGATE_REPCAT procedure, 9-185

DBMS_REPUTIL package

FROM_REMOTE variable, 9-201

GLOBAL_NAME variable, 9-201

REPLICATION_IS_ON variable, 9-201

REPLICATION_OFF procedure, 7-33, 9-187

REPLICATION_ON procedure, 7-34, 9-188

DBMS_SNAPSHOT package

BEGIN_TABLE_REORGANIZATION procedure, 2-31, 9-190

END_TABLE_REORGANIZATION procedure, 2-31, 9-191

I_AM_A_REFRESH function, 9-192

PURGE_LOG procedure, 2-29, 9-193

REFRESH procedure, 9-194

REGISTER_SNAPSHOT procedure, 2-36, 9-197

SET_I_AM_A_REFRESH procedure, 9-199

UNREGISTER_SNAPSHOT, 9-200

UNREGISTER_SNAPSHOT procedure, 2-36

DDL

changes not propagated to master site, 6-23

executing within a master group, 6-2

propagating statements to master sites, 6-2

deadlocks

resolving

in synchronous propagation, 7-7

decision support application

basic replication for, 1-5

DEFCALL view, 10-20

DefDefaultDest table

adding destinations to, 8-6, 9-19

removing destinations from, 8-6, 9-20, 9-21

DEFDEFAULTDEST view, 10-21

DEFERRCOUNT view, 10-21

deferred constraints and updatable snapshots, A-4

deferred RPCs, 8-3

deferred transactions, 1-22

creating, 8-3

DefCall table, 8-5

DefCallDest table, 8-5

DEFCALLDEST view, 10-20

DefDefaultDest table

adding destination to, 8-6, 9-19

removing destinations from, 8-6, 9-20, 9-21

DEFDEFAULTDEST view, 10-21

deferred remote procedure calls (RPCs)

argument types, 9-12

argument values, 9-16

arguments to, 8-5, 9-8

building, 8-5, 9-5

executing immediately, 9-31

DEFERROR view, 10-22

DefTran table, 8-4

DEFTRAN view, 10-24

DEFTRANDEST view, 10-24

deleting, 6-10

diagnosing problems with, 6-25

queue

clearing after deleting master sites, 3-26

purging, 1-23, 3-14

push, 1-22

re-executing, 9-26

removing from queue, 9-23

scheduling execution, 9-37

starting, 8-4, 9-9

views for, 10-19 to 10-24

Deferred Transactions by Dest folder, 6-9

DefError table

deleting transactions from, 9-22

DEFERROR view, 10-22

defining query

snapshots, 1-7, 2-12

definition sites

relocating for a master group, 6-3

DEFLOB, 10-22

DEFSCHEDULE, 10-23

DEFTRAN, 10-24

DEFTRANDEST view, 10-24

delay seconds

setup wizard, 3-13

Delay Seconds setting

delete conflicts, 1-24, 5-3

avoiding, 5-5, 7-25

resolution, 5-8

configuring, 5-36

methods, assigning, 5-36

resolution methods

removing, 5-36

resolving, 5-48

deleting

master groups, 3-17

scheduled links, 3-12

snapshot logs, 4-12

snapshots, 4-21

dependency

ordering

replicated transactions, 3-33

tracking

parallel propagation, 3-34

Destination Map folder, 3-29

destination maps

displaying for master groups, 3-29

destination master sites

adding to master groups, 3-15, 3-25

Destinations page

Edit Master Group property sheet, 3-25, 6-3

DESTROY procedure

detecting conflicts, 5-5, 5-6

diagnosing problems with, 6-22

DIFFERENCES

procedure, 6-17

differences

between tables, 9-55

rectifying, 9-59

DISABLED procedure

DBMS_DEFER_SYS package, 3-12

disabling

propagation, 9-40

disabling replication, 7-32

discard

conflict resolution method, 5-19

use of, 5-38

discard uniqueness

conflict resolution method, 5-35

disconnected environments

as in advanced replication, 1-13

distributed transactions

problems with, 6-25

distributing application loads

as in advanced replication, 1-13

DML

changes not propagated to other sites, 6-23

DO_DEFERRED_REPCAT_ADMIN package, 6-6

DO_DEFERRED_REPCAT_ADMIN procedure

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

DROP SNAPSHOT command, 2-36

DROP SNAPSHOT LOG command, 2-33

DROP_MASTER_REPGROUP procedure

DBMS_REPCAT package, 3-17

DROP_MASTER_REPOBJECT procedure

DBMS_REPCAT package, 3-24

DROP_SNAPSHOT_REPOBJECT procedure

DBMS_REPCAT package, 4-21

dropping

column groups, 5-14

syntax, 9-124

master sites, 9-163

priority group members

by priority, 5-27

by value, 5-26

priority groups, 5-27, 9-132

replicated objects

from master sites

syntax, 9-129

from snapshot sites

syntax, 9-138

groups of, 9-127

site priority groups, 5-30, 9-135

members of, 5-30

sites

by priority level, 5-30

snapshot logs, 2-33

snapshot sites, 9-137

snapshots, 2-36

dynamic ownership, 1-25

conflict avoidance and, 7-27

workflow partitioning, 7-27

dynamic sites

ownership, 5-4

E

earliest and latest timestamp

conflict resolution methods, 5-18

Edit Database Destination property sheet

Replication Manager, 3-30

Edit DB Connection property sheet

Replication Manager, 3-14

setup wizard, 3-13

Edit Master Group property sheet

Destinations page, 3-25, 6-3

Operations page, 3-18, 3-28

Replication Manager, 3-18, 3-19

setup wizard, 3-25

Edit Replication Object property sheet

General page, 3-23, 3-27, 4-20

Min(imize) Communications setting, 3-28

Edit Scheduled Link property sheet

Replication Manager, 3-11

setup wizard, 3-11

Edit Snapshot Log property sheet

Filter Columns page, 4-11

General page, 4-11

Replication Manager, 4-11

Tablespace and Extents page, 4-11

Edit Snapshot property sheet

Tablespace and Extents page, 4-20

Enabled setting

DBMS_OFFLINE_OG package, 7-17

enabling replication, 7-32

END_INSTANTIATION procedure

END_LOAD procedure

DBMS_OFFLINE_OG package, 7-17

END_TABLE_REORGANIZATION procedure

DBMS_SNAPSHOT package, 2-31

enhancements

new features, A-2

error

transactions

managing, 6-10

errors

avoid with VALIDATE, A-4

transactions

displaying, 6-11

resolving, 6-11

examples

minimizing

communication, 5-41

Execute DDL dialog

Replication Manager, 6-2

EXECUTE_DDL procedure

DBMS_REPCAT package, 6-2

EXIST clause

for simple subquery snapshots, 2-24

Export utility

offline instantiation of master site, 7-16

F

fail-over sites

implementing, 7-14

failover sites

as in advanced replication, 1-13

failure, media

recovering read-only snapshots from, 2-37

fast refreshes, 1-9

and table reorg, A-4

snapshot requirements for, 2-17

features requiring migration, B-11

Feedback

on ORACLE documentation, vi

filter columns

for simple subquery snapshots, 2-9, 2-24

Filter Columns page

fine grained quiesce, A-3

Finish page

Replication Manager, 3-7

setup wizard, 3-7

G

gen_rep_pack, 5-22

General page

Edit Replication Object property sheet, 3-27, 4-20

Snapshot Log property sheet, 2-35

GENERATE_REPLICATION_SUPPORT procedure

DBMS_REPCAT package, 3-28

generated objects

displaying for master groups, 3-30

Generated Objects folder, 3-30

generated replication objects

wrapper package, 1-20

generating

replication support

procedural replication, 7-3

replication support and migration, B-3

snapshot support, 9-150

generating replication support

migration and, B-8

H

hybrid configurations

advanced replication, 1-16

I

identity columns

detecting conflicts and, 1-26

Import utility

offline instantiation of master site, 7-17

import_check, 6-15

importing

object groups

offline instantiation and, 9-46, 9-48

snapshots

offline instantiation and, 9-51, 9-53

status check, 9-165

in basic replication, 1-5

incremental migration, B-4

indexes

partitioned tables and, A-4

snapshots, 2-40

information

consolidation

advanced replication and, 1-15

distribution

in basic replication, 1-4

off-loading

in basic replication, 1-5

transport, 1-5

information distribution

basic replication for, 1-4

initialization parameters

JOB_QUEUE_INTERVAL, 2-6, 4-10, 6-6

JOB_QUEUE_PROCESSES, 2-6, 4-10, 6-6

PARALLEL_MAX_SERVERS, 3-32

PARALLEL_MIN_SERVERS, 3-32

PARALLEL_SERVER_IDLE_TIME, 3-32

INIT.ORA, 3-17

instantiation

offline, 7-14

in advanced replication, 7-17

of an advanced replication master site, 7-16

instantiation offline, A-4

internal snapshot objects, 1-7

internal triggers, A-2

intersection tables, 2-20 to 2-23

Interval Expression setting

job queue process, 3-8, 4-10

Setup wizard, 3-12

J

job queues, 1-22

JOB_QUEUE_INTERVAL initialization parameters, 2-6, 4-10, 6-6

JOB_QUEUE_PROCESSES initialization parameters, 2-6, 4-10, 6-6

jobs

breaking, 6-14

checking for scheduled links, 6-25

diagnosing problems with, 6-14

enabling, 6-14

local

displaying, 6-12

editing properties of, 6-13

manually executing, 6-14

queues for

removing jobs from, 9-42 to 9-43

joins

for simple subquery snapshots, 2-24

L

large object types

allowed in replicated tables, 3-20

latest timestamp

conflict resolution method, 5-18

link specifications

incomplete, 6-25

LOBs

omitting old values for, 5-40

support for, A-3

Local Errors folder, 6-11

local jobs

displaying, 6-12

editing properties of, 6-13

M

MAKE procedure

DBMS_REFRESH package, 2-26, 4-22

NEXT_DATE parameter, 2-26

management

basic replication environment, 2-27 to 2-44

management and use new features, A-3

management of master and snapshot groups

advanced, 6-2

managing update conflict resolution, 5-15

manual conflict resolution

versus automatic, 5-7

manual refreshes, 1-11

many-to-many references

simple subquery snapshots, 2-23

many-to-one references

simple subquery snapshots, 2-23

mass deployment, A-2

master and snapshot groups

advanced management of, 6-2

master definition sites, 1-19

relocating, 6-3, 9-161

master groups, 1-18

adding destination master sites, 3-24, 3-25

adding replication objects, 3-15, 3-19

adding sites with tables having circular dependencies, 3-25

adding sites with tables having self-referential constraints, 3-25

administration requests

deleting, 6-6

altering object definition, 3-23

applying administration requests for, 6-5

choosing, for snapshot groups, 4-4

connection qualifiers, 3-16

creating, 3-15

definition sites for

relocating, 6-3

deleting, 3-17

deleting master sites from, 3-25

destination master sites, 3-15

displaying destination maps for, 3-29

displaying generated objects, 3-30

executing DDL within, 6-2

generating replication support for changes, 3-26

listing, 3-29

listing objects in, 3-29

managing, 3-15 to 3-30

objects

generating support for, 3-27

propagating DDL to sites in, 6-2

relocating master definition sites, 6-3

removing replication objects, 3-24

resuming replication activity, 3-19

suspending replication activity, 3-17

validating, 6-2

viewing information about, 3-29

Master Groups folder, 3-29, 6-5

master sites, 1-18

adding to master groups, 3-24

administrator accounts, 3-5

choosing, for snapshot groups, 4-4

creating, 9-77

creating, for multimaster replication, 3-5

customizing settings, 3-7

default propagation characteristics, 3-6

deleting from master groups, 3-25

determining differences, 6-17

diagnosing problems with, 6-22

dropping, 9-163

fine grained quiesce, A-3

incremental migration of, B-6

manually loading table data from, 3-22

master groups

managing, 3-15 to 3-30

minimizing data propagation, 3-28

offline instantiation, 7-16 to 7-17

propagating changes between, 9-37

propagator accounts, 3-5

receiver accounts, 3-5

replicating data to, 3-22

replicating object definitions to, 3-21

manual, 3-21

scheduled links for, 3-9

guidelines, 3-10

scheduled purges for

guidelines, 3-13

schema creation for, 3-6

snapshot registration, A-3

specifying for snapshot sites, 4-6

master sites and migration, B-2

master table

columns

number restriction for simple subquery snapshots, 2-24

datatypes allowed in, 2-12

dropping, 2-36

PRIMARY KEY constraint for snapshot, 2-12

reorganizing, 2-30

requirements for primary key snapshots, 2-8

master tables

reorganizing

methods, 2-31 to 2-33

snapshot logs, 1-9

snapshot logs for, 2-6

truncating, 2-31

maximum value conflict resolution method, 5-17

media failure

recovery

read-only snapshots, 2-37

members

altering priority for, 5-25

migration

features requiring, B-11

incremental, B-4

master sites, B-2

obsolete procedures, B-12

overview, B-2

snapshot sites, B-5

upgrading to primary key snapshots, B-10

using import and export, B-9

Min(imize) Communications setting

Edit Replication Object property sheet, 3-28

min_communication

examples of, 5-41

Minimize Communication setting

Replication Manager, 4-19

minimizing

updates and min_communication, 5-41

minimum value conflict resolution method, 5-17

mode of propagation, 7-8

modifying

tables

without replicating changes, 7-32

monitoring

environment in basic replication, 2-44

multimaster replication, 1-14

advanced options, 3-31 to 3-35

building environment, 3-1 to 3-3

example, 3-2

creating

master groups, 3-15

customizing master site settings, 3-7

database preparation, 3-4

local job queues, 6-12

master site creation, 3-5

monitoring system, 3-29 to 3-30

monitoring systems, 6-4 to 6-15

reviewing configuration settings, 3-7

scheduled links, 3-9

schema creation for, 3-6

security for, 7-18

setup wizard, 3-4

transaction propagation protection, 3-33 to 3-34

multiple column groups

ensuring data integrity with, 5-7

multiple conflicts

resolution methods

for backups, 5-11

using, 5-10

using for notification, 5-11

N

naming

snapshots, 2-11

NCLOB support, A-3

new features

data subsetting and subqueries, A-2

enhanced security, A-4

for management and use, A-3

LOB support, A-3

performance, A-2

subqueries for snapshots, A-2

subquery snapshots, A-2

New Master Site dialog

setup wizard, 3-5

New Replicated Object Schema dialog

setup wizard, 3-6

New Snapshot Site dialog

setup wizard, 4-6

Next Date field

Create Refresh Group property sheet, 2-26

Next Date setting

custom, for conflict resolution, 5-10

Setup wizard, 3-12

NEXT_DATE parameter

DBMS_REFRESH package

MAKE procedure, 2-26

notification

methods

using multiple conflict resolution methods for, 5-11

notification log

conflict

notification log table

conflict

sample, 5-51

notification methods

user-defined, 5-50

notification package

conflict

altering in a master group, 3-23

O

objects

definitions

replication to master sites, 3-21

master groups

generating support for, 3-27

removing from master groups, 3-24

replicated

re-creating, 6-24

Objects page

offline instantiation, 3-22

obsolete procedures, B-12

master sites, 7-16 to 7-17

replicated object groups, 9-45, 9-46, 9-47, 9-48, 9-49

snapshots, 9-51, 9-53

support for, A-4

OPEN_LINKS initialization parameters

initialization parameters

OPEN_LINK, 3-17

Operations page

Edit Master Group property sheet, 3-18, 3-28, 6-2

Options page, 2-28

Create Snapshot property sheet, 2-14

Oracle Replication Manager, 1-18

Oracle7

and min_communication, 4-19

Oracle8

features and migration, B-11

ordering

conflict resolution methods for column groups, 5-15

ordering conflicts

avoiding, 5-38

overwrite

conflict resolution method

use of, 5-38

conflict resolution methods, 5-19

P

package variables

from_remote, 9-201

global_name, 9-201

i_am_a_refresh, 9-192

i_am_a_snapshot, 9-201

replication_is_on, 9-201

parallel propagation, 1-22, A-2

advanced replication environment, 3-31 to 3-32

dependency

tracking, 3-34

planning for, 3-31

Parallel Propagation setting

configuring for advanced replication environments, 3-32

parallel server processes

PARALLEL_MAX_SERVERS initialization parameters, 3-32

PARALLEL_MIN_SERVERS initialization parameters, 3-32

PARALLEL_SERVER_IDLE_TIME initialization parameters, 3-32

partitioned tables

indexes and, A-4

partitions

replication and, 3-21

PCTFREE

value for complex snapshots, 2-43

value for snapshot log, 2-9

PCTUSED

value for complex snapshots, 2-43

value for snapshot log, 2-9

performance enhancements, A-2

performance tuning

simple subquery snapshots, 2-41

periodic purges

periodic pushes

PL/SQL triggers

using with snapshot base tables, 4-21

prebuilt conflicts

resolution methods

restrictions for, 5-9

prebuilt uniqueness conflicts

resolution methods, 5-9

prebuilt update conflict resolution methods, 5-16

prebuilt update conflicts

resolution methods, 5-8

preface

Send Us Your Comments, xxiii

preparing for, 2-4

PRESERVE SNAPSHOT LOG option

TRUNCATE TABLE command, 2-31

PRIMARY KEY constraint

simple subquery snapshots and, 2-23

snapshot requirement for, 2-12

primary key snapshots, 1-12, A-3

requirements for creating log, 2-8

primary keys

missing from replicated tables, 3-16

upgrading snapshots, B-10

primary ownership, 1-25

primary sites

ownership, 5-4

priority group members

dropping, 5-27

dropping by value, 5-26

priority groups, 5-22

adding members to, 5-24, 9-79

altering members

priorities, 5-25, 9-91

values, 5-25, 9-93

and site priority, 5-20

creating, 5-23, 9-120

dropping, 5-27, 9-132

dropping members

by priority, 5-27

by value, 5-26

removing members from, 9-131, 9-133

site priority groups

adding members to, 9-81

using for conflict resolution, 5-22

priority level of sites

altering, 5-29

priority_groups, 5-20

privileges

altering snapshots, 2-36

basic replication environment, 2-3, 2-5

deleting rows from snapshot logs, 2-30

dropping snapshots, 2-37

snapshot creation, 2-11

snapshot log creation, 2-8

generating support for, 7-3

conflicts and, 7-3

deleting and, 7-25

detecting conflicts, 1-28

restrictions, 7-2

using, 7-2

wrapper, 1-28

Processes setting

altering propagation method, 9-99

propagating changes

propagation

disabling, 9-40

minimizing data, 5-40

mode of, 7-8

altering in a master site, 7-10

of changes

altering propagation method, 9-87

parallel, 1-22, A-2

security context of propagator, 7-6

serial, 1-22

setting default characteristics, 3-6

status of, 9-24

propagation reduction, A-2

propagator, 1-24

account

snapshot sites, 4-5, 4-7

registering, 9-34

propagator accounts

TRUNCATE TABLE command, 2-31

PURGE SNAPSHOT LOG option

PURGE_LOG procedure

DBMS_SNAPSHOT package, 2-29

purges

manual, 3-14

periodic

scheduling, 3-14, 4-8

purging

deferred transaction queue, 3-12

RepCatLog table, 9-154

snapshot logs, 2-29

statistics, 9-155

pushes

continuous

scheduling, 3-11, 3-13

periodic

scheduling, 3-11

Q

query defining

for snapshots, 2-12

queue

deferred transactions, 1-22

quiescing

and fine grained quiesce, A-3

master groups, 3-17

replicated schemas, 9-171

R

read-only replication, 1-2, 1-4 to 1-8

uses of, 1-4

read-only snapshots, 1-6

altering

privileges required, 2-36

base table, 1-7

dropping, 2-36

index, 1-8

managing, 2-34 to 2-37

privileges required to query, 2-34

recovery from media failure, 2-37

using, 2-34

real-time

data replication, 1-29

replication, 1-28, 7-6

receiver, 1-24

accounts

advanced replication, 7-34

recovery, 6-15

for replication, 6-15

RECTIFY

procedure, 6-18

rectifying

tables, 6-18, 9-59

re-enabling

refresh

failures, 2-39

fast and table reorg, A-4

retries, 2-39

snapshot sites

syntax, 9-156

snapshots, 9-194

REFRESH clause

ALTER SNAPSHOT command, 2-44

CREATE SNAPSHOT command, 2-44

refresh groups, 1-10

adding members, 2-38

adding members to, 9-63

adding snapshots, 4-22

altering settings, 2-38

automatic refreshes, 1-10

creating, 2-3, 2-24, 4-3

for snapshot sites, 4-22

creating new, 9-67

data dictionary views, 10-25

deleting, 2-38, 9-66

deleting members, 2-38

designing, 2-5

listing group members, 10-31

managing, 2-5 to 2-40

manual refresh, 1-11, 2-39

refresh interval, 2-26

changing, 9-64

REFRESH view, 10-30

REFRESH_CHILDREN view, 10-31

refreshing

manually, 9-70

removing members from, 9-71

settings

next date, 2-26

snapshots, 4-22

troubleshooting refresh, 2-39

refresh intervals

listing, 10-30

parameter constraints, 1-10

REFRESH view, 10-30

snapshot refresh groups, 1-10

REFRESH procedure

DBMS_REFRESH package, 2-39

refresh settings

snapshots, 2-12

refresh types

default, 1-11

manual, 1-11

read-only snapshots, 1-11

snapshot, 2-27

REFRESH view, 10-30

refresh, planning for, 2-5

REFRESH_CHILDREN view, 10-31

refreshes

snapshot, 4-9

REGISTER_SNAPSHOT procedure

DBMS_SNAPSHOT package, 2-36

REGISTERED_SNAPSHOTS, 10-27

registering

propagator for local database, 9-34

snapshots, A-3

RELOCATE_MASTERDEF procedure

DBMS_REPCAT package, 6-3

remote data

referencing for snapshots, 2-13

remote procedure calls, 1-22

deferring, 8-5

REMOVE_MASTER_DATABASES procedure

DBMS_REPCAT package, 3-25

removing

columns in column groups, 5-14

conflict resolution methods, 5-15

RepCat table

REPCATLOG view, 3-30, 6-6 to 6-7, 10-5

RepCatLog view

purging, 9-154

REPCOLUMN view, 10-6

RepColumn_Group table

updating, 6-28, 9-102

REPCOLUMN_GROUP view, 10-6

REPCONFLICT view, 10-7

REPDDL view, 10-7

REPGENOBJECTS view, 10-18

REPGERATED view, 10-8

REPGROUP view, 3-30, 10-3

RepGroup view

updating, 9-105

REPGROUPED_COLUMN view, 10-9

REPKEY_COLUMNS view, 10-9

replicated environment

determining differences in tables, 6-17

replicated object groups

dropping, 9-127

offline instantiation of, 9-45, 9-46, 9-47, 9-48, 9-49

replicated objects

altering, 9-89

at snapshot sites

problems creating, 6-26

creating

master sites, 9-111

snapshot sites, 9-116

DROP_MASTER_REPOBJECT and, 9-129

dropping

snapshot site, 9-138

generating support for, 9-143, 9-144, 9-147

groups

creating

master sites, 9-110

re-creating, 6-24

replicated procedures

generating support for, 7-3

replicated tables

alternate keys for, 3-20

and DML incompatibility, 6-24

datatypes allowed, 3-20

differences between, 6-17

populating manually, 3-22

replicated transactions

dependency ordering, 3-33

replication

administrator, 1-23

advanced

introduction to conflicts, 5-2

re-enabling, 7-34

advanced techniques, 7-1 to 7-35

advanced, uses for, 1-13

backup and recovery for, 6-15

basic, 1-2, 1-4 to 1-12, 2-1 to 2-44

data models and, 1-24

detecting, 1-26

row-level replication, 1-26

resolution methods, 1-27

resolving, 1-26

definition, 1-2

disabling, 7-32, 7-33

enabling, 7-32

environment

advanced

adding new sites to, 7-8

group, 1-18

multimaster, 3-1 to 3-35

advanced options, 3-31 to 3-35

building environment

example, 3-2

monitoring, 3-29 to 3-30, 6-4 to 6-15

objects

generated, 1-20

of object definitions to master sites, 3-21

manual, 3-21

off/on affects current session, 7-33

resuming for master groups, 3-19

sites, 1-18

suspending for master groups, 3-17

triggers, 7-34

uses of read-only, 1-4

replication catalog view

incorrect, 6-25

replication groups

master sites

managing, 3-15 to 3-30

replication management API, 1-19, 9-1

Replication Manager, 1-18

Add Objects to Group dialog, 3-19

administration requests, 6-4 to 6-8

Alter Replication Object dialog, 3-23

Create Refresh Group property sheet, 4-3

Edit Database Destination property sheet, 3-30

Edit Master Group property sheet, 3-18, 3-19

Edit Replication Object property sheet, 3-23

Scheduled Links folder, 3-12

Execute DDL dialog, 6-2

Finish page, 3-7

Scheduling folder, 3-12

Set Alternate Key Columns dialog, 3-16, 3-20

Set Date dialog, 3-9, 3-12

Set Interval dialog, 3-9, 3-12

Set Scheduled Link dialog, 3-9

setup wizard, 3-4

replication objects, 1-18

adding to master groups, 3-15, 3-19

altering definition, 3-23

deleting from master groups, 3-24

replication support

for tables

unable to generate, 6-24

generating for all master group tables, 3-28

generating for master groups, 3-26

generation for objects, 3-27

replication tables

updating Comments, 6-28

replication triggers, A-2

RepObject table

updating, 6-28, 9-107

REPOBJECT view, 3-30, 10-10

REPPARAMETER_COLUMN view, 10-11

REPPRIORITY view, 10-12

RepPriority_Group table

updating, 6-28, 9-103

REPPRIORITY_GROUP view, 10-13

REPPROP view, 10-13

REPRESOL_STATS_CONTROL view, 10-15

RepResolution table

updating, 6-28, 9-108

REPRESOLUTION view, 10-14

REPRESOLUTION_METHOD view, 10-15

RepResolution_Statistics table

purging, 6-17, 9-155

REPRESOLUTION_STATISTICS view, 10-16

RepResolution_Statistics view

gathering statistics, 6-16

RepSchema table

procedural replication, 7-2

RepSite view

updating, 9-106

REPSITES view, 3-30, 10-17

resolution methods

additive prebuilt, 5-16

average prebuilt, 5-16

discard, 5-19

earliest timestamp, 5-18

for column groups

ordering, 5-15

for conflicts

removing, 5-15

latest timestamp, 5-18

managing, 5-15

maximum value method, 5-17

minimum value method, 5-17

overwrite, 5-19

resolution statistics

gathering, 6-16

viewing, 6-16

restrictions

RESUME_MASTER_ACTIVITY procedure

DBMS_REPCAT package, 3-19

RESUME_SUBSET_OF_MASTERS procedure

DBMS_OFFLINE_OG package, 7-16

resuming replication activity, 9-166

rollback segments

setting for snapshot, 2-27

setup wizard, 3-12

ROWID snapshots, 1-12, 2-43

row-level replication, 1-20

detecting conflicts, 1-26, 5-5

rows

identifying during conflict detection, 5-6

RPC, 1-22

S

SCHEDULE_EXECUTION procedure

DBMS_DEFER_SYS package, 3-10, 3-11, 3-13, 3-14

SCHEDULE_PUSH procedure

DBMS_DEFER_SYS package, 3-10, 3-11, 3-13, 3-14

scheduled links

continuous pushes, 3-11, 3-13

creating, 3-9

snapshot site, 4-7

database link to use, 3-9

number of background processes used, 3-10

parallel propagation, 3-10, 3-31 to 3-32

periodic pushes, 3-11

serial propagation, 3-10, 3-31

viewing status, 3-12

Scheduled Links folder

Replication Manager, 3-12

scheduled purges

editing, 3-14

guidelines, 3-13

periodic purges, 3-14

Scheduling folder

Replication Manager, 3-12

Scheduling page

Create Refresh Group property sheet, 4-22

schema

creating for snapshots, 2-4

for snapshot sites, 2-2, 2-4

Schema Manager

Create Refresh Group property sheet, 2-26

Create Snapshot Log property sheet, 2-8

Create Snapshot property sheet, 2-14, 2-15

creating snapshots with, 2-7, 2-10

snapshot log creation, 2-7

Snapshot Log property sheet, 2-35

schemas

creating for multimaster replication, 3-6

creating for snapshot sites, 4-7

security, A-4

for multimaster replication, 7-18

for snapshot replication, 7-22

setup

alternative, 7-24

Select from Master Schemas list

setup wizard, 4-7

self-referential constraints in tables

adding sites with to master groups, 3-25

Send Us Your Comments

boilerplate, xxiii

serial propagation, 1-22

scheduled links, 3-10

serialization

of transactions, 7-3

Set Alternate Key Columns dialog

Replication Manager, 3-16, 3-20

Set Date dialog

Replication Manager, 3-9, 3-12

Set Interval dialog

Replication Manager, 3-9, 3-12

Set Scheduled Link dialog

Replication Manager, 3-9

SET_COLUMNS procedure

DBMS_REPCAT package, 3-20

set_disabled, 9-40

SET_DISABLED procedure

DBMS_DEFER_SYS package, 3-11, 3-13, 3-14

setup wizard

configuring snapshot sites, 4-3

Create Master Sites page, 3-24

Create Scheduled Link property sheet, 3-11, 3-13

creating

administrator accounts, 3-5, 4-7

propagator accounts, 3-5, 4-7

receiver accounts, 3-5

Customize Master Site property sheet, 3-7

Customize Snapshot property sheet, 4-8

Edit DB Connection property sheet, 3-13, 3-14

Edit Master Group property sheet, 3-25

Edit Scheduled Link property sheet, 3-11

Finish page, 3-7

New Master Site dialog, 3-5

New Replicated Object Schema dialog, 3-6

Replication Manager, 3-4

Select from Master Schemas list, 4-7

shadow column groups, 1-27, 5-7

shared ownership, 1-25

simple snapshots

refresh groups

creating, 2-24

SQL restrictions, 2-13

structure, 1-7

simple subquery snapshots

many-to-many references, 2-20, 2-23

many-to-one references, 2-19, 2-23

site ownership

site priority

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

managing, 5-28

site priority groups, 5-28

adding members to, 5-29, 9-81

altering members

dropping, 5-30, 9-135

dropping members, 5-30

removing members from, 9-136

using, 5-28

sites

dropping by priority level, 5-30

snapshot group wizard

Replication Manager, 4-3

snapshot groups

choosing master sites, 4-4

choosing objects to replicate, 4-4

managing, 4-12 to 4-16

selecting master group, 4-4

Snapshot Log property sheet, 2-28

snapshot logs

privileges required, 2-28

contents of, 1-9

creating, 2-3, 2-6, 4-3, 4-11

privileges required, 2-8

deleting, 4-12

deleting rows

privileges required, 2-30

dropping, 2-33

privileges required, 2-33

filter columns

adding, 2-28

internal operations, 2-10

master table

naming, 2-8

privileges required, 2-29

reducing space allocated to, 2-30

reorganizing master tables with, 2-30

storage parameters, 2-8

truncating, 2-30

privileges required, 2-30

truncating master table with, 2-31

underlying table for, 1-10

when to create, 2-8

snapshot refresh groups

adding members, 2-38

altering settings, 2-38

creating, 2-3

deleting, 2-38

deleting members, 2-38

managing, 2-5 to 2-40

manual refresh, 2-39

snapshot refreshes, 4-9

complete, 1-9

fast, 1-9

group

refresh interval, 1-10

groups, 1-10

snapshot logs and, 1-9

snapshot registration at master sites, A-3

snapshot site replication, 4-1 to 4-24

snapshot sites

account configurations, 4-7

adding to advanced replication environments, 4-2 to 4-10

advanced

alternative security setup, 7-24

changing masters, 9-172

configuration, 4-3

creating

syntax, 9-114

creating refresh groups for, 4-22

customizing settings, 4-8

database links for, 2-2, 2-5

designing, 4-2

dropping, 9-137

offline instantiation

advanced replication, 7-17

preparing for replication, 4-5

propagating changes to master, 9-37

refreshing

syntax, 9-156

replication administrator, 4-5

replication propagator, 4-5

reviewing settings, 4-8

scheduled links for, 3-9

guidelines, 3-10

scheduled purge for

guidelines, 3-13

schema creation for, 4-7

schema for, 2-2

SNP background processes for, 4-10

specifying master site for, 4-6

snapshot sites and migration, B-5

snapshots, 2-5

altering

privileges required, 2-36

altering definition, 4-21

assigning to refresh groups, 2-3

cloning

offline instantiation, 7-14

cloning for basic replication, 7-15

clustered, 2-15

complex, 1-11, 2-41

value for PCTFREE, 2-43

value for PCTUSED, 2-43

creating, 2-3, 4-17

privileges required, 2-11

with subquery, 4-20

with WHERE clause, 4-18

creating schema for, 2-4

creating synonyms based on, 2-35

creating views based on, 2-35

creating with subqueries, 2-16

data dictionary views for, 10-25 to 10-31

data load options, 2-15

datatypes supported, 4-18

defining query, 1-7, 2-12

deleting from snapshot groups, 4-21

dropping

privileges required, 2-37

dropping master table for, 2-36

editing, 4-20

editing storage settings, 4-20

enabling/disabling replication for, 7-35

granting access, 2-3

granting access to, 4-4

group, 1-19

groups

advanced management of, 6-2

indexing, 2-40

managing, 4-16 to 4-21

managing base table, 4-21

naming, 2-11

offline instantiation of, 9-51, 9-53

performance tuning, 2-40

primary key, 1-12, 2-12, A-3

requirements for creating log, 2-8

index, 1-8

managing, 2-34 to 2-37

privileges required to query, 2-34

registration, 2-35, 2-36

simple with subqueries, A-2

unregistering, 2-36

using, 2-34

view, 1-8

referencing remote data, 2-13

refresh, 1-9, 1-11

failures, 2-39

individual snapshot, 2-44

problems with, 6-26

querying for last refresh time, 2-35

retries, 2-39

rollback segment for, 2-27

troubleshooting, 2-39, 2-40

refresh groups, 4-22

adding members, 2-38

altering settings, 2-38

creating, 2-24

data dictionary views, 10-25

deleting, 2-38

deleting members, 2-38

designing, 2-5

manual refresh, 2-39

refresh setting, 2-12

refresh types, 2-27

refreshing, 9-194

replication

security for, 7-22

requirements for fast refresh, 2-17

ROWID, 2-43

rowid, 1-12

simple

structure, 1-7

simple subquery

advanced subsetting, 2-16

AND expression and, 2-24

examples, 2-16 to 2-21

EXISTS clause and, 2-24

filter columns requirement, 2-9, 2-24

joins and, 2-24

number of columns in master tables, 2-24

requirements, 2-9

site, 1-19

sites

changing masters, 6-3

schema for, 2-4

SNAPSHOTS view, 10-26

SQL

restrictions for simple, 2-13

storage options, 2-14

subquery, 1-7, 2-16

many-to-many references, 2-20

many-to-one references, 2-19

subquery snapshots, restrictions for, 2-23

trace file, 2-40

troubleshooting, 6-26

tuning, 2-41

underlying objects for, 1-7

updatable, 1-15

deferred constraints, A-4

propagation mechanism, 1-23

updating, 1-9

upgrading to primary key, B-10

using PL/SQL triggers with base tables, 4-21

viewing information about, 2-35

Snapshots page

Create Refresh Group property sheet, 4-22

SNAPSHOTS view, 10-26

SNAPSHOTS_LOGS view, 10-28

SNP background processes, 3-8, 4-10

basic replication

environment, 2-6

for automatic snapshot refresh, 1-11

snapshot sites, 4-10

space

reducing snapshot log, 2-30

SQL

commands

snapshot creation, 2-16 to 2-21

restrictions for simple snapshots, 2-13

static ownership, 1-25

statistics

auditing conflict resolution, 6-16

collecting, 9-160

deleting, 6-17

for conflict resolution, 6-16

status

propagation, 9-24

Stop on Error setting

Create Snapshot Property Sheet, 2-14

storage options

PCTFREE, 2-9

PCTUSED, 2-9

Storage page

Snapshot Log property sheet, 2-28

storage parameters

snapshot log

altering, 2-28

snapshot logs, 2-8

snapshots, 2-14

storage settings

editing for snapshots, 4-20

store-and-forward replication, 1-21

subqueries for snapshots, A-2

subquery

creating snapshots with, 4-20

subquery snapshots, 1-7, 2-16

advanced subsetting, 2-16

AND expression and, 2-24

creating, 4-20

EXIST clause and, 2-24

filter columns requirement, 2-9, 2-24

joins for, 2-24

many-to-many references, 2-20, 2-23

many-to-one references, 2-19, 2-23

number of columns in master tables, 2-24

requirements, 2-9

tuning, 2-41

SUBTRACT procedure

design considerations, 7-13

survivability, 7-11

Parallel Server and, 7-12

SUSPEND_MASTER_ACTIVITY procedure

DBMS_REPCAT package, 3-18

SWITCH_SNAPSHOT_MASTER procedure

DBMS_REPCAT package

ALTER_SNAPSHOT_PROPAGATION procedure, 4-16

synchronous data propagation, 1-28, 7-6

synchronously replicated transactions

destination of, 7-7

synonyms

creating, based on snapshot, 2-35

system-based security, A-4

T

table data

replicating to master sites, 3-22

tables

comparing, 9-55

intersection, 2-20 to 2-23

master groups

generating replication support for, 3-28

modifying

without replicating changes, 7-32

partitioned

replicating, 3-21

partitioned and indexes, A-4

problems generating replication support for, 6-24

rectifying, 6-18, 9-59

reorg, A-4

Tablespace and Extents page

Edit Snapshot property sheet, 4-20

timestamp conflict resolution methods

sample trigger, 5-31

token passing, 7-28

sample implementation, 7-27

trace file

snapshots, 2-40

transactions

deferred

deleting, 6-10

executing, 6-9

error

displaying, 6-11

propagation

protection mechanisms, 3-33 to 3-34

queue for

deferred, diagnosing problems with, 6-25

serialization of, 7-3

triggers

internal, A-2

replicating, 7-34

troubleshooting, 6-22

TRUNCATE command, 2-30

TRUNCATE TABLE command

PRESERVE SNAPSHOT LOG option, 2-31

PURGE SNAPSHOT LOG option, 2-31

U

Ungrouped Snapshots folder, 4-22

UNIQUE constraint

simple subquery snapshots and, 2-23

uniqueness conflicts, 1-24, 5-3

DBMS_SNAPSHOT package, 2-36

resolution, 5-8

configuring, 5-33

resolution methods, 5-9

assigning, 5-33

removing, 5-33

resolving, 5-47

UNREGISTER_SNAPSHOT procedure

UNSCHEDULE_PUSH procedure

DBMS_DEFER_SYS package, 3-12

updatable snapshots, 1-15

generating replication support for, 4-20

propagation mechanism, 1-23

properties of, 1-15

update conflicts, 1-24, 5-3

using site priority for, 5-28

resolution

and column groups, 5-7

resolution methods

assigning, 5-15

prebuilt, 5-8

resolution of

minimizing data propagation for, 5-40

resolving, 5-47

updates

and min_communication, 5-41

minimizing communication, 5-41

updating

Comments, 6-28

replication tables, 6-28

USER_REFRESH view, 2-40

USER_REFRESH_CHILDREN view, 2-40

user-defined

notification methods, 5-50

user-defined conflict resolution method, 5-46

V

VALIDATE procedure, A-4

View Database Destination property sheet, 6-10

views

creating, based on snapshot, 2-35

DBA_REFRESH, 2-44

DBA_REFRESH_CHILDREN, 2-44

DBA_REGISTERED_SNAPSHOTS, 2-35, 2-44

DBA_RGROUP, 2-44

DBA_SNAPSHOT_LOGS, 2-35, 2-44

DBA_SNAPSHOTS, 2-44

DEFCALL, 10-20

DEFCALLDEST, 10-20

DEFDEFAULTDEST, 10-21

REFRESH_CHILDREN, 10-31

REGISTERED_SNAPSHOTS, 10-27

REPCATLOG, 3-30, 6-6 to 6-7, 10-5

REPCOLUMN, 10-6

REPCOLUMN_GROUP, 10-6

REPGROUPED_COLUMN, 10-9

REPKEY_COLUMNS, 10-9

replication catalog, 10-2

REPOBJECT, 3-30, 10-10

REPPARAMETER_COLUMN, 10-11

REPPRIORITY, 10-12

REPPRIORITY_GROUP, 10-13

REPPROP, 10-13

REPRESOL_STATS_CONTROL, 10-15

REPRESOLUTION, 10-14

REPRESOLUTION_METHOD, 10-15

REPRESOLUTION_STATISTICS, 10-16

REPSITES, 3-30, 10-17

SNAPSHOT_REFRESH_TIMES

SNAPSHOT_REFRESH_TIMES view, 10-29

SNAPSHOTS, 10-26

SNAPSHOTS_LOGS, 10-28

USER_REFRESH, 2-40

USER_REFRESH_CHILDREN, 2-40

W

WHERE clause

creating updatable snapshots with

updatable snapshots

creating with WHERE clause, 4-18

workflow, 7-27

wrapper