Oracle8(TM) Server -- Index

DBMS_OFFLINE_OG package, 7-16

BEGIN_INSTANTIATION procedure

BEGIN_LOAD procedure

DBMS snapshot package, 2-31

BEGIN_TABLE_REORGANIZATION procedure

BLOBs support, A-3

branch automation, A-3

catalog, replication, 1-18

CHANGE procedure

DBMS_REFRESH package, 2-38

changing

master definition site, 6-7

checking imported data, 6-13

circular dependencies in tables

restrictions on adding sites with to master group, 3-26

CLOBs support, A-3

Cluster page

Create Snapshot property sheet, 2-15

clustering snapshots, 2-15

column groups, 1-26

adding members to, 5-29

syntax, 10-69

conflict resolution and, 5-7

update conflicts, 5-7

creating, 5-29, 5-31

syntax, 10-107, 10-136

definition, 5-3

dropping, 5-30

syntax, 10-111

removing members from, 5-30

commands, SQL

ALTER SNAPSHOT LOG, 2-28

CREATE SNAPSHOT, 2-7, 2-11, 2-19, 2-21

CREATE SNAPSHOT LOG, 2-7, 2-17

CREATE TABLE, 2-16

DROP SNAPSHOT, 2-37

DROP SNAPSHOT LOG, 2-34

TRUNCATE, 2-30

TRUNCATE TABLE, 2-31

comments

on Oracle documentation, xxii

updating, 6-19

comparing

tables, 10-51

complete refresh, 1-8

complex snapshot, 1-10, 2-42

value for PCTFREE, 2-44

value for PCTUSED, 2-44

configuration

basic replication environment, 2-2, 2-27

example, 2-2

Configuration folder, 3-32-3-33

conflict avoidance

dynamic ownership, 7-22

conflict notification

example, 5-48

package, 5-49

conflict resolution, 1-26

adding method of, 10-76

and asynchronous, 5-2

auditing, 6-9

changing, 5-34

column groups and, 5-7

conflict notification, 5-23

declarative methods

additive, 5-17

append sequence number, 5-21

append site name, 5-21

average, 5-17

discard, 5-20, 5-22

earliest timestamp, 5-15

latest timestamp, 5-15

uniqueness conflicts, 5-10

update conflicts, 5-9

delete conflicts

strategy, 7-20

detecting conflicts, 5-4, 5-7

examples, 5-48

gathering statistics, 6-9

highest priority, 5-44

methods, 1-27, 5-9

designating, 5-24, 5-32

dropping, 5-35

using multiple, 5-12

ordering conflicts, 5-10

primary keys and, 5-6

procedural replication and, 7-3

RepResolution_Statistics table

purging, 6-10

statistics, 10-89, 10-141

strategy for, 5-26

types of conflicts, 5-6

user defined routines, 5-56

example, 5-58

parameters, 5-56

restrictions, 5-58

viewing information, 5-47

conflicts

column groups and, 1-26

data models and, 1-24

delete, 1-24

detecting, 1-26

procedural replication, 1-28

replication, 1-23

resolution methods, 1-27

resolving, 1-26

row-level replication, 1-26

unique (resolution for), 5-53

uniqueness, 1-23

update, 1-23

update (resolution for), 5-51

connection qualifiers

master group, 3-17

continuous pushes

scheduling, 3-11, 3-14

coordinated sequence generation, 1-25

Create Master Sites dialog

setup wizard, 3-25

Create New Master Group property sheet

Destinations page, 3-16

General page, 3-16

Objects page, 3-16

Replication Manager, 3-16

CREATE SNAPSHOT command, 2-7, 2-11, 2-19, 2-21

General page, 3-9

Options page, 3-9

Create Refresh Group property sheet

General page, 4-24

Next Date field, 2-26

Replication Manager, 4-3

Scheduling page, 4-24

Snapshots page, 4-24

Create Scheduled Link property sheet

setup wizard, 3-11, 3-14

REFRESH clause, 2-45

CREATE SNAPSHOT LOG command, 2-17

Create Snapshot Log property sheet

Filter Columns page, 4-11

General page, 4-11

Options page, 2-9

Replication Manager, 4-3, 4-11

Storage page, 2-9

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

creating

Customize Master Site property sheet

setup wizard, 3-7

Customize Snapshot Site property sheet

setup wizard, 4-8

data cluster

creating snapshot as part of, 2-15

data definition language (DDL)

supplying asynchronous, 6-14, 10-126

data dictionary

DBA_REGISTERED_SNAPSHOTS view, 2-35

data dictionary views, 11-2

data inconsistencies

removing after deleting master site, 3-27

data integrity

parallel propagation, 3-41

serial propagation, 3-41

data manipulation language (DML)

minimizing propagation, 7-30

data ownership models, 1-24

dynamic ownership, 1-24

primary ownership, 1-24

shared ownership, 1-25

static ownership, 1-24

data propagation

minimizing, 3-30

reduced, A-2

data subsetting, A-3

database

preparing for multimaster replication, 3-4

database link

creating for snapshot site, 2-2

snapshot site, for, 2-5

using different paths, 3-17

Database Link setting

for read-only snapshot, 1-7

database objects

Database Objects folder

master definition site, 3-20

datatypes

allowed in replicated tables, 3-21

allowed in snapshots, 2-13, 4-19

support for, A-3

DBA_REFRESH view, 2-45

DBA_REFRESH_CHILDREN view, 2-45

DBA_REGISTERED_SNAPSHOTS view, 2-35, 2-45

DBA_REPCATLOG, 8-3

DBA_RGROUP view, 2-45

DBA_SNAPSHOT_LOGS view, 2-35, 2-45

DBA_SNAPSHOTS view, 2-45

DBMS_DEFER package

ADD_DEFAULT_DEST procedure, 9-6, 11-16

CALL procedure, 10-5

CHAR_ARG procedure, 9-5, 10-8

COMMIT_WORK procedure, 10-7

datatype_ARG procedure, 10-8

DATE_ARG procedure, 9-5, 10-8

NUMBER_ARG procedure, 9-5, 10-8

RAW_ARG procedure, 9-5, 10-8

ROWID_ARG procedure, 9-5, 10-8

TRANSACTION procedure, 9-4, 10-9

VARCHAR2_ARG procedure, 9-5

VARHCHAR2_ARG procedure, 10-8

DBMS_DEFER_QUERY package

GET_ARG_TYPE procedure, 6-2, 10-12

GET_CALL_ARGS procedure, 10-14

GET_CHAR_ARG procedure, 10-15

GET_DATE_ARG procedure, 10-15

GET_NUMBER_ARG procedure, 10-15

GET_RAW_ARG procedure, 10-15

GET_ROWID_ARG procedure, 10-15

GET_VARCHAR2_ARG procedure, 10-15

DBMS_DEFER_QUERY procedure

GET_CHAR_ARG function, 6-3

GET_DATE_ARG function, 6-3

GET_NUMBER_ARG function, 6-3

GET_RAW_ARG function, 6-3

GET_ROWID_ARG function, 6-3

GET_VARCHAR2_ARG function, 6-3

DBMS_DEFER_SYS package

DBMS_OFFLINE_OG package

BEGIN_INSTANTIATION procedure, 7-16, 10-41

BEGIN_LOAD procedure, 7-17, 10-42

END_INSTANTIATION procedure, 7-17, 10-43

END_LOAD procedure, 7-17, 10-44

RESUME_SUBSET_OF_MASTERS procedure, 7-17, 10-45

DBMS_OFFLINE_SNAPSHOT package

BEGIN_LOAD procedure, 10-47

END_LOAD procedure, 10-49

DBMS_RECTIFIER_DIFF package, 3-27, 6-15

DIFFERENCES procedure, 10-51

RECTIFY procedure, 10-54

DBMS_REFRESH package

ADD procedure, 2-38, 10-57

CHANGE procedure, 2-38, 10-58

DESTROY procedure, 2-39, 10-60

MAKE procedure, 4-24, 10-61

REFRESH procedure, 2-39, 10-64

SUBTRACT procedure, 2-38, 10-65

DBMS_REPCAT package, 3-35

ADD_DELETE_RESOLUTION procedure, 5-32, 10-76

ADD_GROUPED_COLUMN procedure, 5-29, 10-69

ADD_MASTER_DATABASE procedure, 3-26, 10-71

ADD_PRIORITY_CHAR procedure, 5-38, 10-73

ADD_PRIORITY_DATE procedure, 5-38, 10-73

ADD_PRIORITY_NUMBER procedure, 5-38, 10-73

ADD_PRIORITY_RAW procedure, 5-38, 10-73

ADD_PRIORITY_VARCHAR2 procedure, 5-38, 10-73

ADD_SITE_PRIORITY_SITE procedure, 5-44, 10-75

ADD_UNIQUE_RESOLUTION procedure, 5-32, 10-76

ADD_UPDATE_RESOLUTION procedure, 5-32, 10-76

ALTER_MASTER_PROPAGATION procedure, 10-79

ALTER_MASTER_REPOBJECT procedure, 3-24, 10-81

ALTER_PRIORITY procedure, 5-40, 10-83

ALTER_PRIORITY_CHAR procedure, 5-39, 10-84

ALTER_PRIORITY_DATE procedure, 5-39, 10-84

ALTER_PRIORITY_NUMBER procedure, 5-39, 10-84

ALTER_PRIORITY_RAW procedure, 5-39, 10-84

ALTER_PRIORITY_VARCHAR2 procedure, 5-39, 10-84

ALTER_SITE_PRIORITY procedure, 5-44, 10-86

ALTER_SITE_PRIORITY_SITE procedure, 5-45, 10-87

ALTER_SNAPSHOT_PROPAGATION procedure, 10-88

CANCEL_STATISTICS procedure, 6-10, 10-89

COMMENT_ON_COLUMN_GROUP procedure, 6-19, 10-90

COMMENT_ON_DELETE resolution package, 6-19

COMMENT_ON_DELETE_RESOLUTION procedure, 10-96

COMMENT_ON_PRIORITY_GROUP procedure, 6-19, 10-91

COMMENT_ON_REPCAT procedure, 6-19

COMMENT_ON_REPGROUP procedure, 10-93

COMMENT_ON_REPOBJECT procedure, 6-19, 10-95

COMMENT_ON_REPSCHEMA procedure, 6-19

COMMENT_ON_REPSITES procedure, 10-94

COMMENT_ON_SITE_PRIORITY procedure, 10-91

COMMENT_ON_UNIQUE resolution package, 6-19

COMMENT_ON_UNIQUE_RESOLUTION procedure, 10-96

COMMENT_ON_UPDATE resolution package, 6-19

COMMENT_ON_UPDATE_RESOLUTION procedure, 10-96

CREATE_MASTER_REPGROUP procedure, 3-17, 10-98

CREATE_MASTER_REPOBJECT procedure, 10-99

CREATE_SNAPSHOT_REPGROUP procedure, 10-102

CREATE_SNAPSHOT_REPOBJECT procedure, 10-104

DEFINE_COLUMN_GROUP procedure, 5-31, 10-107

DEFINE_PRIORITY_GROUP procedure, 5-37, 10-108

DEFINE_SITE_PRIORITY procedure, 5-43, 10-109

DO_DEFERRED_REPCAT_ADMIN procedure, 3-35-3-36, 6-12, 10-110

DROP_COLUMN_GROUP procedure, 5-30, 10-111

DROP_DELETE_RESOLUTION procedure, 5-35

DROP_GROUPED_COLUMN procedure, 5-30, 10-112

DROP_MASTER_REPGROUP procedure, 3-18, 10-113

DROP_MASTER_REPOBJECT procedure, 3-25, 10-115

DROP_PRIORITY procedure, 5-41, 10-116

DROP_PRIORITY_CHAR procedure, 5-40, 10-118

DROP_PRIORITY_DATE procedure, 5-40, 10-118

DROP_PRIORITY_GROUP procedure, 5-41, 10-117

DROP_PRIORITY_NUMBER procedure, 5-40, 10-118

DROP_PRIORITY_RAW procedure, 5-40, 10-118

DROP_PRIORITY_VARCHAR2 procedure, 5-40, 10-118

DROP_SITE_PRIORITY procedure, 5-46, 10-120

DROP_SITE_PRIORITY_SITE procedure, 5-45, 10-121

DROP_SNAPSHOT_REPGROUP procedure, 10-122

DROP_SNAPSHOT_REPOBJECT procedure, 4-23, 10-123

DROP_UNIQUE_RESOLUTION procedure, 5-35

DROP_UPDATE_RESOLUTION procedure, 5-35

EXECUTE_DDL procedure, 3-31, 6-14, 10-126

GENERATE_REPLICATION_PACKAGE procedure, 10-128

GENERATE_REPLICATION_SUPPORT procedure, 3-30, 10-129

GENERATE_REPLICATION_TRIGGER procedure, 10-131

GENERATE_SNAPSHOT_SUPPORT, 10-134

MAKE_COLUMN_GROUP procedure, 5-29, 10-136

PURGE_MASTER_LOG procedure, 6-13, 10-137

PURGE_STATISTICS procedure, 6-10, 10-138

REFRESH_SNAPSHOT_REPGROUP procedure, 10-139

REGISTER_STATISTICS procedure, 6-9, 10-141

RELOCATE_MASTERDEF procedure, 3-28, 6-7, 10-142

REMOVE_MASTER_DATABASES procedure, 3-26, 10-144

REPCAT_IMPORT_CHECK procedure, 6-13, 10-145

RESUME_MASTER_ACTIVITY procedure, 3-20, 10-146

SET_COLUMNS procedure, 3-21, 10-149

SUSPEND_MASTER_ACTIVITY procedure, 3-19, 10-151

SWITCH_SNAPSHOT_MASTER procedure, 4-17, 6-8, 10-152

VALIDATE procedure, 10-154

WAIT_MASTER_LOG procedure, 6-11, 10-156

DBMS_REPCAT_ADMIN package

GRANT_ADMIN_ANY_SCHEMA procedure, 10-158

GRANT_ADMIN_SCHEMA procedure, 10-159

REVOKE_ADMIN_ANY_SCHEMA procedure, 10-160

REVOKE_ADMIN_SCHEMA procedure, 10-161

DBMS_REPCAT_AUTH package

GRANT_SURROGATE_REPCAT procedure, 10-163

REVOKE_SURROGATE_REPCAT procedure, 10-164

DBMS_REPUTIL package

FROM_REMOTE variable, 10-179

GLOBAL_NAME variable, 10-179

REPLICATION_IS_ON variable, 10-179

REPLICATION_OFF procedure, 7-27, 10-166

REPLICATION_ON procedure, 7-28, 10-167

DBMS_SNAPSHOT package

BEGIN_TABLE_REORGANIZATION procedure, 2-31

END_TABLE_REORGANIZATION procedure, 2-31

I_AM_A_REFRESH function, 10-171

PURGE_LOG procedure, 2-29-2-30, 10-172

REFRESH procedure, 10-173

REGISTER_SNAPSHOT procedure, 2-36, 10-175

SET_I_AM_A_REFRESH procedure, 10-177

UNREGISTER_SNAPSHOT procedure, 2-36

DDL statements

propagating to master sites, 3-31

declarative conflict resolution methods, 5-9

DefCall view, 11-16

DefCallDest view

description, 11-16

DefDefaultDest table

adding destination to, 9-6

adding destinations to, 10-18

removing destinations from, 9-7, 10-19-10-20

DefDefaultDest view, 11-16

deferred constraints and updatable snapshots, A-5

deferred RPCs, 9-3

deferred transaction queue, 3-15

clearing after deleting master site, 3-27

deferred transaction views, 11-16

deferred transactions, 1-21

Deferred Transactions by Dest folder, 3-42-3-43

deferred transcactions

DefTranDest view, 11-20

DefError table

deleting transactions from, 6-5, 10-21

DefError view, 11-17-11-18

conflicts and, 1-26

description, 11-19

DefErrorCount view, 11-17

defining query

snapshot, 1-6, 2-12

DefPropagator view

description, 11-18

DefTramDest view, 9-7

DefTran view

description, 11-19

DefTranDest view, 11-20

Delay Seconds setting

delete conflicts, 1-24, 5-6

strategy for handling, 7-20

deleting

transactions, 6-5-6-6

dependency ordering

replicated transactions, 3-40

dependency tracking

parallel propagation, 3-41

destination map

displaying for master group, 3-32

Destination Map folder, 3-32

destination master site

adding to master group, 3-16, 3-26

Destinations page

Create New Master Group property sheet, 3-16

Edit Master Group property sheet, 3-26-3-27

DESTROY procedure

DBMS_REFRESH package, 2-39

detecting conflicts, 5-4

differences

between replicated tables, 6-15

between tables, 10-51

rectifying, 10-54

DISABLED procedure

DBMS_DEFER_SYS package, 3-12

disabling

propagation, 10-36

disabling replication, 7-27

discard uniqueness conflict resolution method, 5-22

discard update conflict resolution method, 5-20

DO_DEFERRED_REPCAT_ADMIN procedure

DBMS_REPCAT package, 3-35-3-36

DROP SNAPSHOT command, 2-37

DROP SNAPSHOT LOG command, 2-34

DROP_MASTER_REPGROUP procedure

DBMS_REPCAT package, 3-18

DROP_MASTER_REPOBJECT procedure

DBMS_REPCAT package, 3-25

DROP_SNAPSHOT_REPOBJECT procedure

DBMS_REPCAT package, 4-23

dropping

column groups, 5-30

syntax, 10-111

conflict resolution method, 5-35

master sites, 10-144

priority group members

by priority, 5-41

by value, 5-40

priority groups, 5-41, 10-117

replicated object groups, 10-113

replicated objects

from master sites

syntax, 10-115

from snapshot sites

syntax, 10-123

site priority group members, 5-45

site priority groups, 5-46, 10-120

snapshot logs, 2-34

snapshot sites, 10-122

snapshots, 2-37

dynamic ownership, 1-24

conflict avoidance and, 7-22

conflict resolution for, 5-27

workflow, 7-22

earliest timestamp conflict resolution method, 5-15

Edit Database Destination property sheet

Replication Manager, 3-33

Edit DB Connection property sheet

Replication Manager, 3-15

setup wizard, 3-14

Edit Master Group property sheet

Destinations page, 3-26-3-27

Operations page, 3-19, 3-30

Replication Manager, 3-19-3-20

setup wizard, 3-26

Edit Replication Object property sheet

General page, 3-24, 3-30, 4-22

Min(imize) Communications setting, 3-30

Edit Scheduled Link property sheet

Replication Manager, 3-12

setup wizard, 3-11

Edit Snapshot Log property sheet

Filter Columns page, 4-12

General page, 4-12

Replication Manager, 4-12

Tablespace and Extents page, 4-12

Edit Snapshot property sheet

Tablespace and Extents page, 4-22

Enabled setting

enabling replication, 7-27

END_INSTANTIATION procedure

END_LOAD procedure

DBMS_SNAPSHOT package, 2-31

END_TABLE_REORGANIZATION procedure

error conditions

RepCatLog table

error transactions

errors

avoid with VALIDATE, A-5

DefError view, 5-2

determining cause, 6-2

resolving, 6-4

examples

minimizing communication, 7-31

Execute DDL dialog

Replication Manager, 3-31

EXECUTE_DDL procedure

DBMS_REPCAT package, 3-31

EXIST clause

for simple subquery snapshots, 2-24

Export utility

offline instantiation of master site, 7-16

failure, media

recovering read-only snapshots from, 2-37

fast refresh, 1-8

and table reorg, A-4

snapshot requirements for, 2-17

features requiring migration, B-13

Feedback

on ORACLE documentation, xxii

filter columns

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

Filter Columns page

Create Snapshot Log property sheet, 4-11

Edit Snapshot Log property sheet, 4-12

fine grained quiesce, A-4

Finish page

Replication Manager, 3-7

setup wizard, 3-7

General page

Create New Master Group property sheet, 3-16

Create Snapshot Log property sheet, 4-11

Edit Replication Object property sheet, 3-30, 4-22

Edit Snapshot Log property sheet, 4-12

Snapshot Log property sheet, 2-35

GENERATE_REPLICATION_SUPPORT procedure

DBMS_REPCAT package, 3-30

generated objects

displaying for master group, 3-33

Generated Objects folder, 3-33

generated replication object, 1-19

wrapper package, 1-19

generating

replication support and migration, B-3

generating replication support

migration and, B-7

procedural replication, 7-3

generating snapshot support, 10-134

hybrid configurations

advanced replication, 1-16

identity column

detecting conflicts and, 1-26

Import utility

offline instantiation of master site, 7-17

importing

object groups

offline instantiation and, 10-42, 10-44

snapshots

offline instantiation and, 10-47, 10-49

status check, 10-145

indexes

partitioned tables and, A-5

snapshot, 2-41

information consolidation

advanced replication and, 1-15

INIT.ORA, 3-18

initialization parameters

JOB_QUEUE_INTERVAL, 2-6, 3-36, 4-10

JOB_QUEUE_PROCESSES, 2-6, 3-36, 4-10

PARALLEL_MAX_SERVERS, 3-39

PARALLEL_MIN_SERVERS, 3-39

PARALLEL_SERVER_IDLE_TIME, 3-39

instantiation offline, A-5

internal triggers, A-2

Interval Expression setting

job queue process, 3-8, 4-10

Setup wizard, 3-13

job queues, 1-21

diagnosing problems with, 8-5

disabling, 8-5

removing jobs from, 10-38-10-39

JOB_QUEUE_INTERVAL initialization parameter, 2-6, 3-36, 4-10

JOB_QUEUE_PROCESSES initialization parameter, 2-6, 3-36, 4-10

jobs

removing from job queue, 10-38-10-39

joins

for simple subquery snapshots, 2-24

large object types

allowed in replicated tables, 3-21

latest timestamp conflict resolution method, 5-15

LOBs

omitting old values for, 7-30

support for, A-3

Local Errors folder, 3-43

log information

removing, 6-13

MAKE procedure

DBMS_REFRESH package, 2-26, 4-24

NEXT_DATE parameter, 2-26

management

basic replication environment, 2-28, 2-45

management and use new features, A-4

manual refresh, 1-10

many-to-many references

simple subquery snapshot, 2-23

many-to-one references

simple subquery snapshot, 2-23

mass deployment, A-3

master definition site, 1-18

changing, 6-7

relocating, 3-27, 10-142

master group, 1-18

adding destination master site, 3-25-3-26

adding replication objects, 3-16, 3-20

adding sites with tables having circular dependencies, 3-26

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

Admin Requests folder, 3-34

administration requests

deleting, 3-35

altering object definition, 3-24

applying administration requests for, 3-35

choosing, for snapshot group, 4-4

connection qualifiers, 3-17

creating, 3-16

deleting, 3-18

deleting master sites from, 3-26

destination master sites, 3-16

displaying administration requests, 3-33

displaying destination map, 3-32

displaying generated objects, 3-33

generating replication support for changes, 3-28

listing, 3-32

listing objects in, 3-32

managing, 3-16, 3-33

propagating DDL to sites in, 3-31

relocating master definition site, 3-27

removing replication objects, 3-25

resuming replication activity, 3-20

suspending replication activity, 3-18

validating, 3-31

viewing information about, 3-32

Master Groups folder, 3-32-3-33

master site, 1-18

master sites

fine grained quiesce, A-4

snapshot registration, A-4

master sites and migration, B-3

master table

columns

number restriction for simple subquery snapshots, 2-24

datatypes allowed in, 2-13

dropping, 2-37

PRIMARY KEY constraint for snapshot, 2-12

reorganizing, 2-31

methods, 2-32-2-33

requirements for primary key snapshot, 2-9

snapshot log, 1-8

snapshot log for, 2-7

truncating, 2-31

masterdef, 6-7

maximum conflict resolution method, 5-14

media failure

recovery

read-only snapshots, 2-37

migration

features requiring, B-13

master sites, B-3

obsolete procedures, B-14

snapshot sites, B-9

upgrading to primary key snapshots, B-11

Min(imize) Communications setting

Edit Replication Object property sheet, 3-30

min_communication

examples of, 7-31

Minimize Communication setting

Replication Manager, 4-20

minimizing

updates and min_communication, 7-31

minimizing communication, 7-31

minimum conflict resolution method, 5-14

mode of propagation, 7-9

multimaster replication, 1-14, 3-1, 3-47

advanced options, 3-38

building environment, 3-1

example, 3-2

creating

master group, 3-16

customizing master site settings, 3-6

database preparation, 3-4

local job queues, 3-44

master site creation, 3-5

monitoring system, 3-42, 3-47

ordering conflicts, 5-10

reviewing configuration settings, 3-7

scheduled links, 3-9

schema creation for, 3-6

setup wizard, 3-4

transaction propagation protection, 3-40-3-41

naming

snapshot, 2-11

NCLOB support, A-3

new features

data subsetting and subqueries, A-3

enhanced security, A-6

for management and use, A-4

LOB support, A-3

performance, A-2

subqueries for snapshots, A-3

subquery snapshots, A-3

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

refresh interval use of, 2-26

Setup wizard, 3-13

NEXT_DATE parameter

DBMS_REFRESH package

MAKE procedure, 2-26

NEXT_DAY expression

Objects page

Create New Master Group property sheet, 3-16

obsolete procedures, B-14

offline instantiation, 3-24

master site, 7-16-7-17

replicated object groups, 10-41-10-45

snapshots, 10-47, 10-49

offline instatiation

support for, A-5

OPEN_LINKS initialization parameter

initialization parameters

OPEN_LINK, 3-18

Operations page

Edit Master Group property sheet, 3-19, 3-30-3-31

Options page, 2-28

Create Snapshot property sheet, 2-14

Oracle Replication Manager, 1-17

Oracle7

and min_communication, 4-21

Oracle8

features and migration, B-13

ordering conflicts, 5-10

overwrite conflict resolution method, 5-20

package variables

from_remote, 10-179

global_name, 10-179

i_am_a_refresh, 10-171

i_am_a_snapshot, 10-179

replication_is_on, 10-179

Parallel, 3-10

parallel propagation, 1-21, A-2

advanced replication environment, 3-38-3-39

dependency tracking, 3-41

Parallel Propagation setting

symmetric replication versus, 7-12

Parallel Server

parallel server processes

configuring for advanced replication environment, 3-39

PARALLEL_MAX_SERVERS initialization parameter, 3-39

PARALLEL_MIN_SERVERS initialization parameter, 3-39

PARALLEL_SERVER_IDLE_TIME initialization parameter, 3-39

PCTFREE

value for complex snapshot, 2-44

value for snapshot log, 2-10

PCTUSED

value for complex snapshot, 2-44

value for snapshot log, 2-10

performance enhancements, A-2

performance tuning

simple subquery snapshots, 2-41

snapshot, 2-41

periodic purges

scheduling, 3-14

periodic pushes

scheduling, 3-11

PL/SQL triggers

using with snapshot base table, 4-22

PRESERVE SNAPSHOT LOG option

TRUNCATE TABLE command, 2-31

primary key

missing from replicated table, 3-17

upgrading snapshots, B-11

PRIMARY KEY constraint

simple subquery snapshot and, 2-23

snapshot requirement for, 2-12

primary key snapshot, 1-11

requirements for creating log, 2-9

primary key snapshots, A-4

primary keys

conflict resolution and, 5-6

primary ownership, 1-24

priority group conflict resolution method, 5-18

priority groups, 5-36

adding members to, 5-38, 10-73

altering members

priorities, 5-40, 10-83

values, 5-39, 10-84

creating, 5-37, 10-108

dropping, 5-41, 10-117

dropping members

by priority, 5-41

by value, 5-40

removing members from, 10-116, 10-118

site priority groups

adding members to, 10-75

using, 5-36

privileges

altering snapshots, 2-36

basic replication environment, 2-3, 2-5

deleting rows from snapshot logs, 2-31

dropping snapshots, 2-37

snapshot creation, 2-12

snapshot log creation, 2-8

procedural replication, 1-27

conflicts and, 7-3

deleting and, 7-20

detecting conflicts, 1-28

generating support for, 7-3

restrictions, 7-2

using, 7-2

wrapper, 1-27

Processes setting

altering propagation method, 10-79, 10-88

propagating changes

propagation interval, 5-28

propagation

disabling, 10-36

minimizing data, 7-30

mode of, 7-9

parallel, 1-21, A-2

security context of propagator, 7-7

serial, 1-21

setting default characteristics, 3-6

status of, 10-23

propagation reduction, A-2

propagator, 1-23

account

snapshot site, 4-5, 4-7

propagator account

purge

PURGE SNAPSHOT LOG option

TRUNCATE TABLE command, 2-32

PURGE_LOG procedure

DBMS_SNAPSHOT package, 2-29-2-30

purges

periodic

scheduling, 3-14, 4-8

purging, 3-15

deferred tranaction queue, 3-13

RepCatLog table, 10-137

snapshot log, 2-29

statistics, 10-138

pushes

continuous

scheduling, 3-11, 3-14

periodic

scheduling, 3-11

query, defining

for snapshot, 2-12

quiescing

and fine grained quiesce, A-4

replicated schemas, 10-151

quiescing master group, 3-18

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

uses of, 1-4

read-only snapshot, 1-5

altering

privileges required, 2-36

base table, 1-7

dropping, 2-37

index, 1-7

managing, 2-34, 2-37

privileges required to query, 2-35

recovery from media failure, 2-37

using, 2-34

real-time replication, 1-28, 7-7

receiver account

rectifying

rectifying tables, 6-15

re-executing transactions, 6-4

refresh

failures, 2-40

fast and table reorg, A-4

snapshot sites

REFRESH clause

ALTER SNAPSHOT command, 2-45

CREATE SNAPSHOT command, 2-45

refresh group, 1-9

adding members, 2-38

adding snapshots, 4-24

altering settings, 2-38

automatic refresh, 1-9

creating, 2-3, 2-25, 4-3

for snapshot site, 4-24

deleting, 2-39

deleting members, 2-38

designing, 2-5

managing, 2-41

manual refresh, 1-10, 2-39

refresh interval, 2-26

settings

next date, 2-26

snapshot, 4-24

refresh groups

adding members to, 10-57

creating new, 10-61

data dictionary views, 11-21

deleting, 10-60

listing group members, 11-25

refresh interval

changing, 10-58

refreshing

manually, 10-64

removing members from, 10-65

troubleshooting refresh, 2-39

USER_REFRESH view, 11-24

USER_REFRESH_CHILDREN view, 11-25

refresh interval

listing, 11-24

NEXT_DAY expression, 2-26

snapshot refresh group, 1-9

SYSDATE expression, 2-26

USER_REFRESH view, 11-24

REFRESH procedure

DBMS_REFRESH package, 2-39

refresh settings

snapshot, 2-12

refresh types

read-only snapshots, 1-10

snapshot, 2-27

REFRESH view, 11-24

REFRESH_CHILDREN view, 11-25

REGISTER_SNAPSHOT procedure

DBMS_SNAPSHOT package, 2-36

registering

propagator for local database, 10-31

snapshots, A-4

RELOCATE_MASTERDEF procedure

DBMS_REPCAT package, 3-28

relocating

master definition site, 6-7

remote data

referencing for snapshot, 2-13

remote procedure call, 1-21

deferring, 9-5

REMOVE_MASTER_DATABASES procedure

DBMS_REPCAT package, 3-26

removing

column group members, 5-30

RepCat table

updating, 6-19

REPCATLOG view, 3-36-3-37, 3-47

RepCatLog view, 11-3

diagnosing problems with, 8-3

purging, 6-13, 10-137

RepColumn_Group table

updating, 6-19, 10-90

RepColumn_Group view, 11-4-11-5

RepConflict view, 11-5

RepDDL view, 11-6

RepGenerated view, 11-6

RepGenObjects view, 11-15

REPGROUP view, 3-47

RepGroup view, 11-2

updating, 10-93

RepGrouped_Column view, 11-7

RepKey_Columns view, 11-7

replicated environment

determining differences, 6-15

replicated object groups

creating, 5-51

master sites, 10-98

dropping, 10-113

offline instantiation of, 10-41-10-45

replicated objects

altering, 10-81

creating

master sites, 10-99

snapshot sites, 10-104

DROP_MASTER_REPOBJECT and, 10-115

dropping

snapshot site, 10-123

generating support for, 10-128-10-129, 10-131

replicated tables

alternate key for, 3-21

datatypes allowed, 3-21

populating manually, 3-23

replicated transactions

dependency ordering, 3-40

replication

replication catalog views, 11-2

replication group

master site

managing, 3-16, 3-33

replication management API, 1-18, 10-1

Replication Manager, 1-17

replication objects

adding to master group, 3-16, 3-20

altering definition, 3-24

deleting from master group, 3-25

replication support

generating for all master group tables, 3-30

generating for master group, 3-28

generation for object, 3-30

replication tables

updating Comments, 6-19

RepObject table

updating, 6-19, 10-95

REPOBJECT view, 3-47

RepObject view, 11-8

RepParameter_Column, 11-8

RepPriority view, 5-18, 11-9

RepPriority_Group table

updating, 6-19, 10-91

RepPriority_Group view, 11-11

RepProp view, 11-11

RepResolution Statistics Control view, 11-13

RepResolution table

updating, 6-19, 10-96

RepResolution view, 11-12

RepResolution_Method view, 11-13

RepResolution_Statistics table

purging, 6-10, 10-138

RepResolution_Statistics view, 11-14

gathering statistics, 6-9

RepSchema table

resolving errors, 6-4

restrictions

procedural replciation, 7-2

RESUME_MASTER_ACTIVITY procedure

DBMS_REPCAT package, 3-20

RESUME_SUBSET_OF_MASTERS procedure

resuming replication activity, 10-146

rollback segment

setting for snapshot, 2-27

ROWID snapshot, 1-11, 2-44

row-level replication, 1-19

detecting conflicts, 1-26, 5-4

RPC, 1-21

SCHEDULE_EXECUTION procedure

DBMS_DEFER_SYS package, 3-10, 3-12-3-13, 3-15

SCHEDULE_PUSH procedure

DBMS_DEFER_SYS package, 3-10, 3-12-3-13, 3-15

scheduled link

continuous pushes, 3-11, 3-14

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-38-3-39

periodic pushes, 3-11

serial propagation, 3-10, 3-38

viewing status, 3-12

Scheduled Links folder

Replication Manager, 3-12

scheduled purge

editing, 3-15

guidelines, 3-14

scheduled purges

periodic purges, 3-14

Scheduling folder

Replication Manager, 3-12

Scheduling page

Create Refresh Group property sheet, 4-24

schema

creating for multimaster replication, 3-6

creating for snapshot, 2-4

creating for snapshot site, 4-7

for snapshot site, 2-2, 2-4

Schema Manager

Create Refresh Group property sheet, 2-26

Create Snapshot Log property sheet, 2-9

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

creating snapshot with, 2-7

creating snapshots with, 2-11

snapshot log creation, 2-7

Snapshot Log property sheet, 2-35

security, A-6

Select from Master Schemas list

setup wizard, 4-7

self-referential constraints in tables

adding sites with to master group, 3-26

sequences

coordinated generation, 1-25

serial propagation, 1-21

scheduled link, 3-10

Set Alternate Key Columns dialog

Replication Manager, 3-17, 3-21

Set Date dialog

Replication Manager, 3-9, 3-13

Set Interval dialog

Replication Manager, 3-9, 3-13

Set Scheduled Link dialog

Replication Manager, 3-9

SET_COLUMNS procedure

DBMS_REPCAT package, 3-21

SET_DISABLED procedure

DBMS_DEFER_SYS package, 3-12-3-13, 3-15

setup wizard

configuring snapshot sites, 4-3

Create Master Sites page, 3-25

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

creating

administrator account, 3-5, 4-7

propagator account, 3-5, 4-7

receiver account, 3-5

Customize Master Site property sheet, 3-7

Customize Snapshot property sheet, 4-8

Edit DB Connection property sheet, 3-14

Edit Master Group property sheet, 3-26

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 group, 1-27

shared ownership, 1-25

simple snapshot

refresh groups

creating, 2-25

SQL restrictions, 2-13

structure, 1-6

simple subquery snapshot

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

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

requirements, 2-10

tuning, 2-41

site priority

altering, 10-86

site priority conflict resolution method, 5-18

site priority groups, 5-43

adding members to, 5-44, 10-75

altering members

dropping, 5-46, 10-120

dropping members, 5-45

removing members from, 10-121

using, 5-43

snapshot

altering

privileges required, 2-36

altering definition, 4-23

assigning to refresh group, 2-3

clustered, 2-15

complex, 1-10, 2-42

value for PCTFREE, 2-44

value for PCTUSED, 2-44

creating, 2-3, 4-18

privileges required, 2-12

with subquery, 4-21

with WHERE clause, 4-20

creating schema for, 2-4

creating synonyms based on, 2-35

creating views based on, 2-35

data dictionary views, 11-21

data load options, 2-15

datatypes supported, 4-19

DBA_SNAPSHOTS view, 11-21

defining query, 1-6, 2-12

deleting from snapshot group, 4-23

dropping

privileges required, 2-37

dropping master table for, 2-37

editing, 4-22

editing storage settings, 4-22

granting access, 2-3

granting access to, 4-4

group, 1-18

indexing, 2-41

log, 1-8

managing, 4-18, 4-23

managing base table, 4-22

naming, 2-11

offline instantiation of, 10-47, 10-49

performance tuning, 2-41

primary key, 1-11, 2-12, A-4

requirements for creating log, 2-9

index, 1-7

privileges required to query, 2-35

registration, 2-36

simple with subqueries, A-3

unregistering, 2-36

using, 2-34

view, 1-7

referencing remote data, 2-13

refresh, 1-8, 1-10

failures, 2-40

individual snapshot, 2-44

querying for last refresh time, 2-35

retries, 2-40

rollback segment for, 2-27

troubleshooting, 2-39-2-40

refresh group, 4-24

adding members, 2-38

altering settings, 2-38

creating, 2-25

deleting, 2-39

deleting members, 2-38

designing, 2-5

managing, 2-41

manual refresh, 2-39

refresh setting, 2-12

refresh types, 2-27

refreshing, 10-173

requirements for fast refresh, 2-17

ROWID, 2-44

rowid, 1-11

simple

structure, 1-6

simple subquery

advanced subsetting, 2-16

AND expression and, 2-24

examples, 2-16

EXISTS clause and, 2-24

filter columns requirement, 2-10, 2-24

joins and, 2-24

number of columns in master tables, 2-24

requirements, 2-10

site, 1-18

schema for, 2-4

SQL restrictions for simple, 2-13

storage options, 2-14

subquery, 1-7, 2-16

examples, 2-21

many-to-many references, 2-19

many-to-one references, 2-19

trace file, 2-40

troubleshooting, 8-10

tuning, 2-41

underlying objects for, 1-7

updatable, 1-15

deferred constraints, A-5

updating, 1-8

upgrading to primary key, B-11

using PL/SQL triggers with base table, 4-22

viewing information about, 2-35

snapshot group

choosing master site, 4-4

choosing objects to replicate, 4-4

managing, 4-13, 4-17

picking master group, 4-4

snapshot group wizard

Replication Manager, 4-3

snapshot log

Snapshot Log property sheet, 2-28

General page, 2-35

Options page, 2-28

Storage page, 2-28

snapshot logs

master table

purging, 10-172

snapshot refresh, 4-9

complete, 1-8

fast, 1-8

group

refresh interval, 1-9

groups, 1-9

snapshot log and, 1-8

snapshot refresh group

adding members, 2-38

altering settings, 2-38

creating, 2-3

deleting, 2-39

deleting members, 2-38

managing, 2-41

manual refresh, 2-39

snapshot registration at master sites, A-4

snapshot site

snapshot site replication, 4-1, 4-26

snapshot sites and migration, B-9

snapshots

refresh groups

data dictionary views, 11-21

Snapshots page

Create Refresh Group property sheet, 4-24

SNAPSHOTS view, 11-21

SNP background process, 3-8, 4-10

basic replication environment, 2-6

for automatic snapshot refresh, 1-10

snapshot sites, 4-10

space

reducing snapshot log, 2-30

SQL

restrictions for simple snapshot, 2-13

SQL commands

snapshot creation, 2-16, 2-21

static ownership, 1-24

statistics

auditing conflict resolution, 6-9

collecting, 10-141

status

propagation, 10-23

Stop on Error setting