Index

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

A

administrator

for replication

creating, 2-4

for snapshot sites

creating, 2-16

ALL_REFRESH_CHILDREN view, 9-57

ALL_REFRESHS view, 9-56

ALL_REGISTERED_SNAPSHOTS view, 9-58

ALL_REPCAT_REFRESH_TEMPLATES view, 9-8

ALL_REPCAT_TEMPLATE_OBJECTS view, 9-8

ALL_REPCAT_TEMPLATE_PARMS view, 9-11

ALL_REPCAT_TEMPLATE_SITES view, 9-13

ALL_REPCAT_USER_AUTHORIZATIONS view, 9-14

ALL_REPCAT_USER_PARM_VALUES view, 9-15

ALL_REPCATLOG view, 9-6

ALL_REPCOLUMN view, 9-17

ALL_REPCOLUMN_GROUP view, 9-18

ALL_REPCONFLICT view, 9-18

ALL_REPDDL view, 9-20

ALL_REPGENOBJECTS view, 9-20

ALL_REPGROUP view, 9-22

ALL_REPGROUP_PRIVILEGES view, 9-23

ALL_REPGROUPED_COLUMN view, 9-23

ALL_REPKEY_COLUMNS view, 9-24

ALL_REPOBJECT view, 9-25

ALL_REPPARAMETER_COLUMN view, 9-26

ALL_REPPRIORITY view, 9-28

ALL_REPPRIORITY_GROUP view, 9-30

ALL_REPPROP view, 9-30

ALL_REPRESOL_STATS_CONTROL view, 9-32

ALL_REPRESOLUTION view, 9-33

ALL_REPRESOLUTION_METHOD view, 9-34

ALL_REPRESOLUTION_STATISTICS view, 9-34

gathering statistics, 6-26

ALL_REPSITES view, 9-35

ALL_SNAPSHOT_LOGS view, 9-59

ALL_SNAPSHOT_REFRESH_TIMES view, 9-60

ALL_SNAPSHOTS view, 9-61

ALTER SNAPSHOT LOG statement, 7-17

altering

propagation method, 8-82, 8-90

auditing

conflict resolution, 6-26

authorize template users, 4-10

C

columns

column groups, 6-4, 6-6, 6-9, 6-11, 6-12, 6-16

adding members to, 8-72

creating, 8-110, 8-134

dropping, 8-115

removing members from, 8-116

comments

comments field

updating in views, 7-42

on Oracle documentation, xxii

updating, 7-42

comparing

tables, 8-53

conflict resolution, 6-1

conflicts

avoiding

delete, 6-23

notification log table

notification methods

notification package

D

data definition language

asynchronous, 8-129

supplying asynchronous, 8-129

data dictionary views

deferred transactions, 9-49

replication, 9-1

snapshots, 9-55

database links

creating, 2-12, 2-17, 5-4

DBA_REFRESH view, 9-62

DBA_REFRESH_CHILDREN view, 9-62

DBA_REGISTERED_SNAPSHOT_GROUPS view, 9-63

DBA_REGISTERED_SNAPSHOTS view, 9-63

DBA_REPCAT_REFRESH_TEMPLATES view, 9-37

DBA_REPCAT_TEMPLATE_OBJECTS view, 9-37

DBA_REPCAT_TEMPLATE_PARMS view, 9-37

DBA_REPCAT_TEMPLATE_SITES view, 9-38

DBA_REPCAT_USER_AUTHORIZATIONS view, 9-38

DBA_REPCAT_USER_PARM_VALUES view, 9-38

DBA_REPCATLOG view, 9-37

purging, 8-135

DBA_REPCOLUMN view, 9-38

updating, 7-42

DBA_REPCOLUMN_GROUP view, 9-38

updating, 8-92

DBA_REPCONFLICT view, 9-39

DBA_REPDDL view, 9-39

DBA_REPGENOBJECTS view, 9-39

DBA_REPGROUP view, 9-39

updating, 8-94

DBA_REPGROUP_PRIVILEGES view, 9-39

DBA_REPGROUPED_COLUMN view, 9-39

DBA_REPKEY_COLUMNS view, 9-39

DBA_REPOBJECT view, 9-40

updating, 8-95

DBA_REPPARAMETER_COLUMN view, 9-40

DBA_REPPRIORITY view, 9-40

DBA_REPPRIORITY_GROUP view, 9-40

updating, 7-42, 8-93

DBA_REPPROP view, 9-40

DBA_REPRESOL_STATS_CONTROL view, 9-41

DBA_REPRESOLUTION view, 9-41

updating, 7-42, 8-99

DBA_REPRESOLUTION_METHOD view, 9-41

DBA_REPRESOLUTION_STATISTICS view, 9-41

purging, 6-27, 8-136

DBA_REPSCHEMA view

updating, 7-42

DBA_REPSITES view, 9-41

updating, 8-97

DBA_SNAPSHOT_LOG_FILTER_COLS view, 9-63

DBA_SNAPSHOT_LOGS view, 9-63

DBA_SNAPSHOT_REFRESH_TIMES view, 9-63

DBA_SNAPSHOTS view, 9-64

DBMS_DEFER package, 8-4

CALL procedure, 8-4

CHAR_ARG procedure, 8-7

COMMIT_WORK procedure, 8-6

datatype_ARG procedure, 8-7

DATE_ARG procedure, 8-7

NUMBER_ARG procedure, 8-7

RAW_ARG procedure, 8-7

ROWID_ARG procedure, 8-7

TRANSACTION procedure, 8-9

VARCHAR2_ARG procedure, 8-7

DBMS_DEFER_QUERY package, 8-10

GET_ARG_FORM function, 8-11

GET_ARG_TYPE function, 8-12

GET_CALL_ARGS procedure, 8-14

GET_CHAR_ARG procedure, 8-15

GET_datatype_ARG function, 8-15

GET_NUMBER_ARG procedure, 8-15

GET_RAW_ARG procedure, 8-15

GET_ROWID_ARG procedure, 8-15

GET_VARCHAR2_ARG procedure, 8-15

DBMS_DEFER_SYS package, 8-17

DBMS_OFFLINE_OG package, 8-39

BEGIN_INSTANTIATION procedure, 7-30, 8-40

BEGIN_LOAD procedure, 7-31, 8-41

END_INSTANTIATION procedure, 7-32, 8-42

END_LOAD procedure, 7-32, 8-44

RESUME_SUBSET_OF_MASTERS procedure, 7-31, 8-45

DBMS_OFFLINE_SNAPSHOT package, 8-47

BEGIN_LOAD procedure, 7-35, 7-36, 8-48

END_LOAD procedure, 7-37, 8-50

DBMS_RECTIFIER_DIFF package, 7-38, 8-52

DIFFERENCES procedure, 7-38, 8-53

RECTIFY procedure, 7-39, 8-56

DBMS_REFRESH package, 8-59

ADD procedure, 5-7, 8-60

CHANGE procedure, 8-61

DESTROY procedure, 8-63

MAKE procedure, 5-5, 8-64

REFRESH procedure, 8-66

SUBTRACT procedure, 8-67

DBMS_REPCAT package, 8-68

ADD_DELETE_RESOLUTION procedure, 8-78

ADD_GROUPED_COLUMN procedure, 8-72

ADD_MASTER_DATABASE procedure, 3-7, 7-4, 8-73

ADD_PRIORITY_CHAR procedure, 8-75

ADD_PRIORITY_datatype procedure, 8-75

ADD_PRIORITY_DATE procedure, 8-75

ADD_PRIORITY_NUMBER procedure, 8-75

ADD_PRIORITY_VARCHAR2 procedure, 8-75

ADD_SITE_PRIORITY_SITE procedure, 6-17, 8-76

ADD_UNIQUENESS_RESOLUTION procedure, 8-78

ADD_UPDATE_RESOLUTION procedure, 6-4, 6-6, 6-10, 6-11, 6-14, 6-17, 8-78

ALTER_MASTER_PROPAGATION procedure, 8-82

ALTER_MASTER_REPOBJECT procedure, 6-8, 6-16, 6-19, 6-24, 7-26, 8-83

ALTER_PRIORITY procedure, 8-85

ALTER_PRIORITY_CHAR procedure, 8-86

ALTER_PRIORITY_datatype procedure, 8-86

ALTER_PRIORITY_DATE procedure, 8-86

ALTER_PRIORITY_NUMBER procedure, 8-86

ALTER_PRIORITY_RAW procedure, 8-86

ALTER_SITE_PRIORITY procedure, 8-88

ALTER_SITE_PRIORITY_SITE procedure, 8-89

ALTER_SNAPSHOT_PROPAGATION procedure, 8-90

CANCEL_STATISTICS procedure, 6-27, 8-91

comment procedures, 7-42

COMMENT_ON_COLUMN_GROUP procedure, 7-42, 8-92

COMMENT_ON_DELETE_RESOLUTION procedure, 7-42, 8-99

COMMENT_ON_PRIORITY_GROUP procedure, 7-42, 8-93

COMMENT_ON_REPGROUP procedure, 7-42, 8-94

COMMENT_ON_REPOBJECT procedure, 8-95

COMMENT_ON_REPSCHEMA procedure, 7-42

COMMENT_ON_REPSITES procedure, 8-97

COMMENT_ON_SITE_PRIORITY procedure, 8-93

COMMENT_ON_SNAPSHOT_REPSITES procedure, 8-98

COMMENT_ON_UNIQUE_RESOLUTION procedure, 7-42, 8-99

COMMENT_ON_UPDATE_RESOLUTION procedure, 7-42, 8-99

COMPARE_OLD_VALUES procedure, 8-101

CREATE_MASTER_REPGROUP procedure, 3-5, 8-103

CREATE_MASTER_REPOBJECT procedure, 6-9, 8-104

CREATE_SNAPSHOT_REPGROUP procedure, 5-5, 7-6, 7-35, 8-107

CREATE_SNAPSHOT_REPOBJECT procedure, 5-6, 7-7, 8-108

DEFINE_COLUMN_GROUP procedure, 8-110

DEFINE_PRIORITY_GROUP procedure, 8-111

DEFINE_SITE_PRIORITY procedure, 6-16, 8-113

DO_DEFERRED_REPCAT_ADMIN procedure, 7-29, 8-113

DROP_COLUMN_GROUP procedure, 8-115

DROP_DELETE_RESOLUTION procedure, 8-127

DROP_GROUPED_COLUMN procedure, 8-116

DROP_MASTER_REPGROUP procedure, 8-117

DROP_MASTER_REPOBJECT procedure, 8-118

DROP_PRIORITY procedure, 8-119

DROP_PRIORITY_CHAR procedure, 8-121

DROP_PRIORITY_datatype procedure, 8-121

DROP_PRIORITY_DATE procedure, 8-121

DROP_PRIORITY_GROUP procedure, 8-120

DROP_PRIORITY_NUMBER procedure, 8-121

DROP_PRIORITY_VARCHAR2 procedure, 8-121

DROP_SITE_PRIORITY procedure, 8-123

DROP_SITE_PRIORITY_SITE procedure, 8-124

DROP_SNAPSHOT_REPGROUP procedure, 7-13, 8-125

DROP_SNAPSHOT_REPOBJECT procedure, 7-13, 8-126

DROP_UNIQUE_RESOLUTION procedure, 8-127

DROP_UPDATE_RESOLUTION procedure, 8-127

EXECUTE_DDL procedure, 8-129

GENERATE_REPLICATION_SUPPORT procedure, 3-8, 7-27, 8-130

GENERATE_SNAPSHOT_SUPPORT procedure, 8-132

MAKE_COLUMN_GROUP procedure, 6-4, 6-6, 6-9, 6-11, 6-12, 6-16, 8-134

PURGE_MASTER_LOG procedure, 8-135

PURGE_STATISTICS procedure, 6-27, 8-136

REFRESH_SNAPSHOT_REPGROUP procedure, 8-137

REGISTER_SNAPSHOT_REPGROUP procedure, 8-138

REGISTER_STATISTICS procedure, 6-26, 8-140

RELOCATE_MASTERDEF procedure, 7-2, 8-141

REMOVE_MASTER_DATABASE procedure, 7-5

REMOVE_MASTER_DATABASES procedure, 8-142

REPCAT_IMPORT_CHECK procedure, 8-143

RESUME_MASTER_ACTIVITY procedure, 3-10, 8-144

SEND_OLD_VALUES procedure, 8-145

SET_COLUMNS procedure, 8-102, 8-147

SUSPEND_MASTER_ACTIVITY procedure, 8-149

SWITCH_SNAPSHOT_MASTER procedure, 7-9, 8-149

UNREGISTER_SNAPSHOT_REPGROUP procedure, 7-14, 8-150

VALIDATE procedure, 8-151

WAIT_MASTER_LOG procedure, 8-154

DBMS_REPCAT_ADMIN package, 8-155

GRANT_ADMIN_ANY_SCHEMA procedure, 2-4, 2-16, 8-156

GRANT_ADMIN_SCHEMA procedure, 8-156

REGISTER_USER_REPGROUP procedure, 2-5, 2-6, 8-157

REVOKE_ADMIN_ANY_SCHEMA procedure, 8-159

REVOKE_ADMIN_SCHEMA procedure, 8-160

UNREGISTER_USER_REPGROUP procedure, 8-161

DBMS_REPCAT_INSTANTIATE package, 8-163

DROP_SITE_INSTANTIATION procedure, 7-10, 8-164

INSTANTIATE_OFFLINE function, 8-164

INSTANTIATE_OFFLINE_REPAPI function, 8-167

INSTANTIATE_ONLINE function, 8-170

DBMS_REPCAT_RGT package, 8-172

ALTER_REFRESH_TEMPLATE procedure, 8-174

ALTER_TEMPLATE_OBJECT procedure, 8-176

ALTER_TEMPLATE_PARM procedure, 4-8, 8-179

ALTER_USER_AUTHORIZATION procedure, 8-181

ALTER_USER_PARM_VALUE procedure, 8-182

COMPARE_TEMPLATES function, 8-185

COPY_TEMPLATE function, 8-186

CREATE_OBJECT_FROM_EXISTING function, 8-188

CREATE_REFRESH_TEMPLATE function, 8-190

CREATE_REFRESH_TEMPLATE procedure, 4-4

CREATE_TEMPLATE_OBJECT function, 8-192

CREATE_TEMPLATE_OBJECT procedure, 4-5

CREATE_TEMPLATE_PARM function, 8-196

CREATE_USER_AUTHORIZATION function, 8-198

CREATE_USER_AUTHORIZATION procedure, 4-10

CREATE_USER_PARM_VALUE function, 8-199

CREATE_USER_PARM_VALUE procedure, 4-9

DELETE_RUNTIME_PARMS procedure, 8-202

DROP_ALL_OBJECTS procedure, 8-203

DROP_ALL_TEMPLATE_PARMS procedure, 8-204

DROP_ALL_TEMPLATE_SITES procedure, 8-205

DROP_ALL_TEMPLATES procedure, 8-206

DROP_ALL_USER_AUTHORIZATIONS procedure, 8-206

DROP_ALL_USER_PARM_VALUES procedure, 8-207

DROP_REFRESH_TEMPLATE procedure, 8-209

DROP_SITE_INSTANTIATION procedure, 7-11, 8-210

DROP_TEMPLATE_OBJECT procedure, 8-211

DROP_TEMPLATE_PARM procedure, 8-213

DROP_USER_AUTHORIZATION procedure, 8-214

DROP_USER_PARM_VALUE procedure, 8-215

GET_RUNTIME_PARM_ID function, 8-216

INSERT_RUNTIME_PARMS procedure, 8-217

INSTANTIATE_OFFLINE function, 8-219

INSTANTIATE_OFFLINE procedure, 4-14

INSTANTIATE_OFFLINE_REPAPI function, 8-221

INSTANTIATE_ONLINE function, 8-224

INSTANTIATE_ONLINE procedure, 4-15

LOCK_TEMPLATE_EXCLUSIVE procedure, 8-227

LOCK_TEMPLATE_SHARED procedure, 8-227

DBMS_REPUTIL package, 8-228

FROM_REMOTE function, 8-230

GLOBAL_NAME function, 8-231

MAKE_INTERNAL_PKG procedure, 8-231

REPLICATION_IS_ON function, 8-230

REPLICATION_OFF procedure, 8-229

REPLICATION_ON procedure, 8-229

SYNC_UP_REP procedure, 8-232

DBMS_SNAPSHOT package, 8-233

BEGIN_TABLE_REORGANIZATION procedure, 7-19, 8-234

END_TABLE_REORGANIZATION procedure, 7-19, 8-234

I_AM_A_REFRESH function, 8-235

PURGE_DIRECT_LOAD_LOG procedure, 8-235

PURGE_LOG procedure, 7-18, 8-236

PURGE_SNAPSHOT_FROM_LOG procedure, 7-14, 7-16, 8-237

REFRESH procedure, 7-37, 8-239

REFRESH_ALL_MVIEWS procedure, 8-242

REFRESH_DEPENDENT procedure, 8-243

REGISTER_SNAPSHOT procedure, 8-245

UNREGISTER_SNAPSHOT procedure, 7-15, 8-247

DDL. See data definition language

DEFCALL view, 9-50

DEFCALLDEST view, 9-50

DEFDEFAULTDEST view, 9-50

adding destinations to, 8-19

removing destinations from, 8-19, 8-20

DEFERRCOUNT view, 9-51

deferred transaction queue, 7-23

managing, 7-23

purging propagated transactions, 7-24

deferred transactions

DefDefaultDest table

removing destinations from, 8-20

DEFDEFAULTDEST view

adding destination to, 8-19

removing destinations from, 8-19

deferred remote procedure calls (RPCs)

argument types, 8-12

argument values, 8-15

arguments to, 8-7

building, 8-4

executing immediately, 8-28

deleting from queue, 8-21

re-executing, 8-24

scheduling execution, 8-34

starting, 8-9

views, 9-49

DEFERROR view, 7-25, 9-51

deleting transactions from, 8-20

DEFLOB view, 9-52

DEFPROPAGATOR view, 9-52

DEFSCHEDULE view, 9-53

DEFTRAN view, 9-53

DEFTRANDEST view, 9-54

deployment templates

adding objects to, 4-5

alter object, 8-176

alter parameters, 8-179

alter template, 8-174

alter user authorization, 8-181

alter user parameter values, 8-182

authorize users, 4-10

compare templates, 8-185

concepts, 4-2

copy template, 8-186

create object from existing, 8-188

create template, 8-190

creating, 4-2, 4-4

data dictionary views for, 9-8

distributing files, 4-16

drop site instantiation, 8-164

dropping, 8-209

dropping all, 8-206

dropping snapshot group, 7-10

flowchart for creating, 4-3

instantiating, 4-16

instantiation script, 4-15

objects

offline instantiation, 4-11, 8-164, 8-167, 8-219, 8-221

online instantiation, 8-170, 8-224

packaging, 4-11, 4-13

for offline instantiation, 4-13

for online instantiation, 4-14

parameters

runtime parameters

sites

user authorizations

user parameter values

differences

disabling

documentation

DROP SNAPSHOT LOG statement, 7-23

E

errors

error queue

DEFERROR view, 7-25

managing, 7-25

error transactions

re-executing as alternate user, 7-25

re-executing as receiver, 7-25

F

feedback

on Oracle documentation, xxii

G

generate replication support, 3-8

GLOBAL_NAMES initialization parameter, 1-4

I

importing

object groups

offline instantiation and, 8-41, 8-44

snapshots

offline instantiation and, 8-48, 8-50

J

job interval, 1-5

job processes, 1-4

JOB_QUEUE_INTERVAL initialization parameter, 1-4

JOB_QUEUE_PROCESSES initialization parameter, 1-4

jobs

queues for

removing jobs from, 8-38

M

master definition sites

relocating, 8-141

master groups

adding objects to, 3-5

creating, 3-2, 3-5, 8-103

dropping, 8-117

flowchart for creating, 3-4

quiescing, 8-149

resuming replication activity, 8-144

master sites

adding, 3-7, 7-3

adding using offline instantiation, 7-28

changing master definition site, 7-2

creating, 8-73

creating users, 2-6

database links, 2-12

determining differences, 7-38

dropping, 7-4, 8-142

flowchart for setting up, 2-3

managing, 7-2

metadata

cleaning up, 7-14

propagating changes between, 8-34

schedule purge, 2-6

scheduled links, 2-13

master tables

multimaster replication

security

trusted vs. untrusted, A-2

security for, A-2

N

notification log table

conflicts

creating, B-6

sample, B-7

notification methods

user-defined, B-6

notification package

conflicts

creating, B-7

O

P

package variables

i_am_a_refresh, 8-235

packaging deployment templates, 4-11

parameters

deployment templates, 4-7

user values, 4-9

PRESERVE SNAPSHOT LOG option

TRUNCATE TABLE statement, 7-20

primary keys

replicated tables, 3-6

priority groups

adding members to, 8-75

altering members

removing members from, 8-119, 8-121

site priority groups

adding members to, 8-76

propagation

altering method, 8-90

disabling, 8-36

of changes

propagation

altering method, 8-82

status of, 8-22

propagator

registering, 2-5, 8-31

proxy snapshot administrator

creating, 2-6

purge deferred transaction queue

master sites, 2-6

snapshot sites, 2-18

PURGE SNAPSHOT LOG option

TRUNCATE TABLE statement, 7-20

purging

DBA_REPCATLOG table, 8-135

deferred transaction queue, 7-24

push

deferred transactions, 7-23

snapshot sites, 2-18

pushing deferred transactions, 7-23

Q

quiescing

master groups, 8-149

R

receiver

registering, 2-5

rectifying

tables, 7-39, 8-56

refresh

snapshot sites, 8-137

snapshots, 7-37, 8-239, 8-242, 8-243

refresh groups

adding members to, 8-60

adding objects to, 5-7

creating, 5-5, 8-64

data dictionary views, 9-55

deleting, 8-63

refresh interval

changing, 8-61

refreshing

manually, 8-66

removing members from, 8-67

refresher

creating, 2-16

registering

propagator for local database, 8-31

replicated object groups

offline instantiation of, 8-40, 8-41, 8-42, 8-44, 8-45

replicated objects

dropping from master sites, 8-118

replication

catalog views, 9-1, 9-2

column groups, 6-4, 6-6, 6-9, 6-11, 6-12, 6-16

conflict resolution, 6-1

creating administrator, 2-4

creating an environment, 1-2

data dictionary views, 9-1

database links

creating, 2-12

deferred transaction queue

managing, 7-23

determining differences between tables, 7-38

disabling, 8-229

enabling, 8-229

error queue

managing, 7-25

generating support for, 3-8

managing an environment, 7-1

master groups

creating, 3-2

master sites

adding, 3-7

managing, 7-2

objects

adding to deployment template, 4-5

adding to master group, 3-5

propagator

receiver

scheduled links

setting up sites, 2-2

sites

snapshot groups

snapshot logs

snapshot sites

tables

replication catalog

comments

updating, 7-42

replication catalog views, 9-1

comments

updating, 7-42

replication management API, 8-1

conflict resolution, 6-1

deployment templates

managing a replicated environment, 7-1

master groups

creating, 3-2

overview, 1-1

packages, 8-2

setting up replication sites, 2-2

snapshot groups

creating, 5-4

resuming replication activity, 8-144

S

scheduled links

creating, 2-13

security

for multimaster replication, A-2

trusted vs. untrusted, A-2

for snapshot replication, A-7

trusted vs. untrusted, A-8

replication, A-1

trusted vs. untrusted, A-2, A-8

set_disabled, 8-36

site priority

altering, 8-88

site priority groups

adding members to, 8-76

creating

syntax, 8-113

dropping, 8-123

removing members from, 8-124

snapshot groups

adding objects to, 5-6

creating, 5-4, 5-5, 8-107

dropping, 7-10

group owner, 7-5

snapshot logs

altering, 7-16

privileges required, 7-16

filter columns

master table

purging, 8-235, 8-236, 8-237

purging

manual, 7-18

privileges required, 7-18

purging rows from, 7-18

reducing space allocated to, 7-18

reorganizing master tables with, 7-19

truncating, 7-18

privileges required, 7-19

truncating master table with, 7-20

snapshot sites

adding using offline instantiation, 7-32

administrator

creating, 2-16

changing masters, 7-9, 8-149

database links

creating, 2-17, 5-4

dropping, 7-10, 8-125

dropping objects from, 7-12

flowchart for setting up, 2-15

group owner

using, 7-5

managing, 7-5

propagating changes to master, 8-34

refresher

users

snapshots

data dictionary views, 9-55

dropping, 7-13

generating support for, 8-132

offline instantiation of, 8-48, 8-50

refresh, 4-18

refresh groups

creating, 5-5

data dictionary views, 9-55

refreshing, 7-37, 8-239, 8-242, 8-243

security

trusted vs. untrusted, A-8

security for, A-7

snapshot logs

creating, 4-1, 5-4

SNP background processes, 1-4

space

reducing snapshot log, 7-18

statistics

auditing conflict resolution, 6-26

status

storage parameters

snapshot log

altering, 7-17

T

tables

comparing, 8-53

differences between, 7-38

rectifying, 7-39, 8-56

updating comments, 7-42

Template. See Deployment Template

TRUNCATE statement, 7-19

TRUNCATE TABLE statement

PRESERVE SNAPSHOT LOG option, 7-20

PURGE SNAPSHOT LOG option, 7-20

trusted security, A-2, A-8

U

USER_REFRESH view, 9-64

USER_REFRESH_CHILDREN view, 9-64

USER_REGISTERED_SNAPSHOTS view, 9-64

USER_REPCAT_REFRESH_TEMPLATES view, 9-42

USER_REPCAT_TEMPLATE_OBJECTS view, 9-42

USER_REPCAT_TEMPLATE_PARMS view, 9-43

USER_REPCAT_TEMPLATE_SITES view, 9-43

USER_REPCAT_USER_AUTHORIZATIONS view, 9-43

USER_REPCAT_USER_PARM_VALUES view, 9-43

USER_REPCATLOG view, 9-42

USER_REPCOLUMN view, 9-44

USER_REPCOLUMN_GROUP view, 9-44

USER_REPCONFLICT view, 9-44

USER_REPDDL view, 9-44

USER_REPGENOBJECTS view, 9-44

USER_REPGROUP view, 9-45

USER_REPGROUP_PRIVILEGES view, 9-45

USER_REPGROUPED_COLUMN view, 9-45

USER_REPKEY_COLUMNS view, 9-45

USER_REPOBJECT view, 9-45

USER_REPPARAMETER_COLUMN view, 9-46

USER_REPPRIORITY view, 9-46

USER_REPPRIORITY_GROUP view, 9-46

USER_REPPROP view, 9-46

USER_REPRESOL_STATS_CONTROL view, 9-47

USER_REPRESOLUTION view, 9-47

USER_REPRESOLUTION_METHOD view, 9-47

USER_REPRESOLUTION_STATISTICS view, 9-47

USER_REPSITES view, 9-48

USER_SNAPSHOT_LOGS view, 9-64

USER_SNAPSHOT_REFRESH_TIMES view, 9-64

USER_SNAPSHOTS view, 9-64

users

authorize for deployment template, 4-10

creating for master sites, 2-6

snapshot sites, 2-16

V

views

deferred transactions, 9-49

refresh groups, 9-55

replication catalog, 9-2

snapshots, 9-55