Oracle8i Replication API Reference
Release 8.1.5
A67793-01

Product

Contents

Index

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

A

add master site, 3-7, 7-3

add object to refresh group, 5-6

add template object, 4-5

additive prebuilt conflict resolution method, 6-10

alter replicated object, 7-16

alter replication object, 6-8

altering

priority levels, 8-93

propagation method, 8-89, 8-98

replicated objects, 8-91

asynchronous

DDL, 8-138

authorize template users, 4-10

average prebuilt conflict resolution method, 6-10

avoiding delete conflicts, 6-24

C

change master definition site, 7-2

column group, 6-4, 6-6, 6-9, 6-11, 6-13, 6-16

column groups

adding members to

syntax, 8-79

creating

syntax, 8-118, 8-144

dropping

syntax, 8-123

removing members from

syntax, 8-124

comments

on Oracle documentation, xxiii

comparing

tables, 8-60

conflict resolution

additive, 6-10, 8-85

average, 6-10

average prebuilt, 6-10

avoid delete conflicts, 6-24

discard, 6-3

maximum, 6-5

maximum value method, 6-5

minimum, 6-5

minimum value method, 6-5

overwrite, 6-3

priority groups, 6-12

site priority, 6-15

statistics, 8-99, 8-150

timestamp, 6-7

create

deployment template, 4-4

refresh group, 5-4

snapshot group, 5-3

snapshot group object, 5-5

snapshot log, 5-3

template parameter, 4-7

user parameter value, 4-9

create master group, 3-5

create proxy snapshot administrator, 2-6

create refresher, 2-16

create replication administrator, 2-4

create replication object, 3-5

create snapshot administrator, 2-16

creating

column groups

syntax, 8-118, 8-144

priority groups, 8-119

refresh groups, 8-70

replicated object groups

syntax, 8-109

replicated objects

generating support for, 8-140

snapshot sites, 8-116

syntax, 8-110

site priority groups

syntax, 8-121

snapshot sites

syntax, 8-114

D

data definition language (DDL)

supplying asynchronous, 8-138

data dictionary views, 9-2

deferred transactions, 9-27

REFRESH_CHILDREN, 9-37

REGISTERED_SNAPSHOTS, 9-34

REPCATLOG, 9-5, 9-6, 9-12, 9-13

REPCOLUMN, 9-15

REPCOLUMN_GROUP, 9-16

REPGROUP_PRIVILEGES, 9-17

REPGROUPED_COLUMN, 9-18

REPKEY_COLUMNS, 9-18

REPOBJECT, 9-19

REPPARAMETER_COLUMN, 9-20

REPPRIORITY, 9-21

REPPRIORITY_GROUP, 9-22

REPPROP, 9-22

REPRESOL_STATS_CONTROL, 9-24

REPRESOLUTION, 9-23

REPRESOLUTION_METHOD, 9-24

REPRESOLUTION_STATISTICS, 9-25

REPSITES, 9-26

SNAPSHOT_LOGS, 9-34

SNAPSHOT_REFRESH_TIMES, 9-35

SNAPSHOTS, 9-32

snapshots, 9-32

database link, 2-12, 2-17, 5-3

DBMS_DEFER package

CALL procedure, 8-6

CHAR_ARG procedure, 8-9

COMMIT_WORK procedure, 8-8

DATE_ARG procedure, 8-9

NUMBER_ARG procedure, 8-9

RAW_ARG procedure, 8-9

ROWID_ARG procedure, 8-9

TRANSACTION procedure, 8-10

VARCHAR2_ARG procedure, 8-9

DBMS_DEFER_QUERY package

GET_ARG_TYPE procedure, 8-13

GET_CHAR_ARG procedure, 8-16

GET_DATE_ARG procedure, 8-16

GET_NUMBER_ARG procedure, 8-16

GET_RAW_ARG procedure, 8-16

GET_ROWID_ARG procedure, 8-16

GET_VARCHAR2_ARG procedure, 8-16

DBMS_DEFER_SYS package

DBMS_OFFLINE_OG package

BEGIN_INSTANTIATION procedure, 7-19, 8-44

BEGIN_LOAD procedure, 7-21, 8-46

END_INSTANTIATION procedure, 7-22, 8-48

END_LOAD procedure, 7-21, 8-50

RESUME_SUBSET_OF_MASTERS procedure, 7-20, 8-52

DBMS_OFFLINE_SNAPSHOT package

BEGIN_LOAD procedure, 7-25, 7-26, 8-55

END_LOAD procedure, 7-27, 8-57

DBMS_RECTIFIER_DIFF package

DIFFERENCES procedure, 8-60

RECTIFY procedure, 8-63

DBMS_REFRESH package

ADD procedure, 5-6, 5-7, 8-66

CHANGE procedure, 8-67

DESTROY procedure, 8-69

MAKE procedure, 5-4, 8-70

REFRESH procedure, 8-73

SUBTRACT procedure, 8-74

DBMS_REPCAT package

ADD_DELETE_RESOLUTION procedure, 8-85

ADD_GROUPED_COLUMN procedure, 8-79

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

ADD_PRIORITY_CHAR procedure, 8-82

ADD_PRIORITY_DATE procedure, 8-82

ADD_PRIORITY_NUMBER procedure, 8-82

ADD_PRIORITY_RAW procedure, 8-82

ADD_PRIORITY_VARCHAR2 procedure, 8-82

ADD_SITE_PRIORITY_SITE procedure, 8-84

ADD_UNIQUE_RESOLUTION procedure, 8-85

ADD_UPDATE_RESOLUTION procedure, 6-4, 6-6, 6-10, 6-11, 6-14, 6-18, 8-85

ALTER_MASTER_PROPAGATION procedure, 8-89

ALTER_MASTER_REPOBJECT procedure, 6-8, 6-16, 6-19, 6-25, 7-16, 8-91

ALTER_PRIORITY procedure, 8-93

ALTER_PRIORITY_CHAR procedure, 8-94

ALTER_PRIORITY_DATE procedure, 8-94

ALTER_PRIORITY_NUMBER procedure, 8-94

ALTER_PRIORITY_RAW procedure, 8-94

ALTER_PRIORITY_VARCHAR2 procedure, 8-94

ALTER_SITE_PRIORITY procedure, 8-96

ALTER_SITE_PRIORITY_SITE procedure, 8-97

ALTER_SNAPSHOT_PROPAGATION procedure, 8-98

CANCEL_STATISTICS procedure, 8-99

COMMENT_ON_COLUMN_GROUP procedure, 8-100

COMMENT_ON_DELETE_RESOLUTION procedure, 8-105

COMMENT_ON_PRIORITY_GROUP procedure, 8-101

COMMENT_ON_REPGROUP procedure, 8-102

COMMENT_ON_REPOBJECT procedure, 8-104

COMMENT_ON_REPSITES procedure, 8-103

COMMENT_ON_SITE_PRIORITY procedure, 8-101

COMMENT_ON_UNIQUE_RESOLUTION procedure, 8-105

COMMENT_ON_UPDATE_RESOLUTION procedure, 8-105

COMPARE_OLD_VALUES procedure, 8-107

CREATE_MASTER_REPGROUP procedure, 3-5, 8-109

CREATE_MASTER_REPOBJECT procedure, 3-6, 3-7, 6-9, 8-110

CREATE_SNAPSHOT_REPGROUP procedure, 5-4, 7-6, 7-25, 8-114

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

DEFINE_COLUMN_GROUP procedure, 8-118

DEFINE_PRIORITY_GROUP procedure, 8-119

DEFINE_SITE_PRIORITY procedure, 8-121

DO_DEFERRED_REPCAT_ADMIN procedure, 7-19, 8-122

DROP_COLUMN_GROUP procedure, 8-123

DROP_GROUPED_COLUMN procedure, 8-124

DROP_MASTER_REPGROUP procedure, 8-125

DROP_MASTER_REPOBJECT procedure, 8-127

DROP_PRIORITY procedure, 8-128

DROP_PRIORITY_CHAR procedure, 8-130

DROP_PRIORITY_DATE procedure, 8-130

DROP_PRIORITY_GROUP procedure, 8-129

DROP_PRIORITY_NUMBER procedure, 8-130

DROP_PRIORITY_RAW procedure, 8-130

DROP_PRIORITY_VARCHAR2 procedure, 8-130

DROP_SITE_PRIORITY procedure, 8-132

DROP_SITE_PRIORITY_SITE procedure, 8-133

DROP_SNAPSHOT_REPGROUP procedure, 8-134

DROP_SNAPSHOT_REPOBJECT procedure, 8-135

EXECUTE_DDL procedure, 8-138

GENERATE_REPLICATION_SUPPORT procedure, 3-8, 3-9, 7-17, 8-140

GENERATE_SNAPSHOT_SUPPORT, 8-142

MAKE_COLUMN_GROUP procedure, 6-4, 6-6, 6-9, 6-11, 6-13, 6-16, 8-144

PURGE_MASTER_LOG procedure, 8-146

PURGE_STATISTICS procedure, 8-147

REFRESH_SNAPSHOT_REPGROUP procedure, 8-148

REGISTER_STATISTICS procedure, 8-150

RELOCATE_MASTERDEF procedure, 7-2, 7-3, 8-151

REMOVE_MASTER_DATABASES procedure, 8-153

REPCAT_IMPORT_CHECK procedure, 8-154

RESUME_MASTER_ACTIVITY procedure, 3-9, 8-155

SEND_OLD_VALUES procedure, 8-156

SET_COLUMNS procedure, 8-108, 8-157

SUSPEND_MASTER_ACTIVITY procedure, 8-160

SWITCH_SNAPSHOT_MASTER procedure, 8-161

VALIDATE procedure, 8-163

WAIT_MASTER_LOG procedure, 8-166

DBMS_REPCAT_ADMIN package

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

GRANT_ADMIN_SCHEMA procedure, 8-169

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

REVOKE_ADMIN_ANY_SCHEMA procedure, 8-172

REVOKE_ADMIN_SCHEMA procedure, 8-173

UNREGISTER_USER_REPGROUP procedure, 8-174

DBMS_REPCAT_INSTANTIATE package

DROP_SITE_INSTANTIATION procedure, 8-177

INSTANTIATE_OFFLINE procedure, 8-178

INSTANTIATE_ONLINE procedure, 8-180

DBMS_REPCAT_RGT package

ALTER_REFRESH_TEMPLATE procedure, 8-185

ALTER_TEMPLATE_OBJECT procedure, 8-187

ALTER_TEMPLATE_PARM procedure, 4-8, 8-190

ALTER_USER_AUTHORIZATION procedure, 8-192

ALTER_USER_PARM_VALUE procedure, 8-194

COMPARE_TEMPLATES procedure, 8-196

COPY_TEMPLATE procedure, 8-198

CREATE_DEPLOYMENT_TEMPLATE procedure, 4-4

CREATE_OBJECT_FROM_EXISTING procedure, 8-200

CREATE_REFRESH_TEMPLATE procedure, 8-203

CREATE_TEMPLATE_OBJECT procedure, 4-5, 4-6, 4-7, 8-206

CREATE_TEMPlATE_OBJECT procedure, 4-5

CREATE_TEMPLATE_PARM procedure, 8-209

CREATE_USER_AUTHORIZATION procedure, 4-10, 8-212

CREATE_USER_PARM_VALUE procedure, 4-9, 4-10, 8-214

DELETE_RUNTIME_PARMS procedure, 8-217

DROP_ALL_OBJECTS procedure, 8-218

DROP_ALL_TEMPLATE_PARMS procedure, 8-219

DROP_ALL_TEMPLATE_SITES procedure, 8-220

DROP_ALL_TEMPLATES procedure, 8-221

DROP_ALL_USER_AUTHORIZATIONS procedure, 8-222

DROP_ALL_USER_PARM_VALUES procedure, 8-223

DROP_REFRESH_TEMPLATE procedure, 8-225

DROP_SITE_INSTANTIATION procedure, 8-226

DROP_TEMPLATE_OBJECT procedure, 8-227

DROP_TEMPLATE_PARM procedure, 8-229

DROP_USER_AUTHORIZATION procedure, 8-230

DROP_USER_PARM_VALUE procedure, 8-231

GET_RUNTIME_PARM_ID function, 8-232

INSERT_RUNTIME_PARMS procedure, 8-233

INSTANTIATE_OFFLINE procedure, 4-12

INSTANTIATE_ONLINE procedure, 4-13, 8-238

INSTANTIATE_SITE_OFFLINE procedure, 8-235

LOCK_TEMPLATE_EXCLUSIVE procedure, 8-241

LOCK_TEMPLATE_SHARED procedure, 8-242

DBMS_REPUTIL package

FROM_REMOTE procedure, 8-247

GLOBAL_NAME procedure, 8-248

MAKE_INTERNAL_PKG procedure, 8-249

REPLICATION_IS_ON procedure, 8-246

REPLICATION_OFF procedure, 8-244

REPLICATION_ON procedure, 8-245

SYNC_UP_REP procedure, 8-250

DBMS_SNAPSHOT package

BEGIN_TABLE_REORGANIZATION procedure, 8-252

END_TABLE_REORGANIZATION procedure, 8-253

I_AM_A_REFRESH function, 8-254

PURGE_DIRECT_LOAD_LOG procedure, 8-255

PURGE_LOG procedure, 8-256

PURGE_SNAPSHOT_FROM_LOG procedure, 8-257

REFRESH procedure, 8-259

REFRESH_ALL_MVIEWS procedure, 8-261

REFRESH_DEPENDENT procedure, 8-263

UNREGISTER_SNAPSHOT, 8-267

DEFCALL view, 9-27

DefDefaultDest table

adding destinations to, 8-20

removing destinations from, 8-21, 8-22

DEFDEFAULTDEST view, 9-28

DEFERRCOUNT view, 9-28

deferred transaction queue, 7-8

deferred transactions

DEFCALLDEST view, 9-28

DefDefaultDest table

adding destination to, 8-20

removing destinations from, 8-21, 8-22

DEFDEFAULTDEST view, 9-28

deferred remote procedure calls (RPCs)

argument types, 8-13

argument values, 8-16

arguments to, 8-9

building, 8-6

executing immediately, 8-31

DEFERROR view, 9-29

DEFTRAN view, 9-31

DEFTRANDEST view, 9-31

re-executing, 8-27

removing from queue, 8-24

scheduling execution, 8-37

starting, 8-10

views for, 9-27 to 9-31

DefError table

deleting transactions from, 8-23

DEFTRANDEST view, 9-31

deployment template

add object, 4-5

alter object, 8-187

alter parameter, 8-190

alter template, 8-185

alter user authorization, 8-192

alter user parameter value, 8-194

authorize users, 4-10

compare templates, 8-196

create object from existing, 8-200

create parameter, 4-7, 8-209

create runtime parameters, 8-233

create template, 8-203

create user authorization, 8-212

create user parameter value, 4-9, 8-214

data dictionary views for, 9-6 to 9-14

delete runtime parameters, 8-217

drop all objects, 8-218

drop all template parameters, 8-219

drop all template sites, 8-220

drop all templates, 8-221

drop all user authorizations, 8-222

drop all user parameter values, 8-223

drop parameter, 8-229

drop site instantiation, 8-177, 8-226

drop template, 8-225

drop template object, 8-227

drop user authorization, 8-230

drop user parameter value, 8-231

get runtime parameter ID, 8-232

insert runtime parameters, 8-233

instantiation, 4-11, 4-12

lock template, 8-241, 8-242

offline instantiation, 4-11, 8-178, 8-235

online instantiation, 4-12, 8-180, 8-238

differences

between tables, 8-60

rectifying, 8-63

disabling

propagation, 8-39

discard

conflict resolution method, 6-3

drop master site, 7-4

drop snapshot site, 7-9

dropping

column groups

syntax, 8-123

master sites, 8-153

priority groups, 8-129

replicated objects

from master sites, 8-127

from snapshot sites, 8-135

groups of, 8-125

site priority groups, 8-132

snapshot sites, 8-134

E

error queue, 7-14

execute error transaction, 7-15

F

Feedback

on ORACLE documentation, xxiii

G

generate replication support, 3-8

generating

snapshot support, 8-142

Global Names, 1-3

I

importing

object groups

offline instantiation and, 8-46, 8-50

snapshots

offline instantiation and, 8-55, 8-57

status check, 8-154

INIT.ORA, 1-3, 1-4

J

job interval, 1-3

Job Processes, 1-3

jobs

queues for

removing jobs from, 8-41 to 8-42

L

latest timestamp

conflict resolution method, 6-7

M

manage snapshot site, 7-5

drop site, 7-9

push deferred transaction queue, 7-8

using a group owner, 7-5

master definition sites

relocating, 8-151

master sites

creating, 8-80

dropping, 8-153

propagating changes between, 8-37

maximum value conflict resolution method, 6-5

minimum value conflict resolution method, 6-5

O

offline instantiation, 7-17

master site, 7-17

replicated object groups, 8-44, 8-46, 8-48, 8-50, 8-52

snapshot site, 7-22

snapshots, 8-55, 8-57

overwrite

conflict resolution methods, 6-3

P

package variables

i_am_a_refresh, 8-254

priority groups

adding members to, 8-82

altering members

priorities, 8-93

values, 8-94

and site priority, 6-12

creating, 8-119

dropping, 8-129

removing members from, 8-128, 8-130

site priority groups

adding members to, 8-84

propagating changes

altering propagation method, 8-98

propagation

disabling, 8-39

of changes

altering propagation method, 8-89

status of, 8-25

propagator

registering, 8-34

purge deferred transaction queue, 2-6

purging

RepCatLog table, 8-146

statistics, 8-147

push deferred transaction queue, 7-8

Q

quiescing

replicated schemas, 8-160

R

rectifying

tables, 8-63

refresh

snapshot sites

syntax, 8-148

snapshots, 8-259, 8-261, 8-263

refresh groups

adding members to, 8-66

creating new, 8-70

data dictionary views, 9-32

deleting, 8-69

listing group members, 9-37

refresh interval

changing, 8-67

REFRESH view, 9-36

REFRESH_CHILDREN view, 9-37

refreshing

manually, 8-73

removing members from, 8-74

refresh intervals

listing, 9-36

REFRESH view, 9-36

REFRESH_CHILDREN view, 9-37

REGISTERED_SNAPSHOTS, 9-34

registering

propagator for local database, 8-34

REPCAT_REFRESH_TEMPLATES view, 9-6

REPCAT_TEMPLATE_OBJECTS view, 9-6

REPCAT_TEMPLATE_PARMS view, 9-8

REPCAT_TEMPLATE_SITES view, 9-11

REPCAT_USER_AUTHORIZATIONS view, 9-12

REPCAT_USER_PARM_VALUES view, 9-13

REPCATLOG view, 9-5

RepCatLog view

purging, 8-146

REPCOLUMN view, 9-15

RepColumn_Group table

updating, 8-100

REPCOLUMN_GROUP view, 9-15, 9-16

REPCONFLICT view, 9-16

REPDDL view, 9-17

REPGENOBJECTS view, 9-26

REPGROUP view, 9-3

RepGroup view

updating, 8-102

REPGROUP_PRIVILEGES view, 9-17

REPGROUPED_COLUMN view, 9-18

REPKEY_COLUMNS view, 9-18

replicated object groups

dropping, 8-125

offline instantiation of, 8-44, 8-46, 8-48, 8-50, 8-52

replicated objects

altering, 8-91

creating

master sites, 8-110

snapshot sites, 8-116

creating master group, 8-109

DROP_MASTER_REPOBJECT and, 8-127

dropping

snapshot site, 8-135

generating support for, 8-140

replication

catalog views, 9-2

replication management API, 8-1

RepObject table

updating, 8-104

REPOBJECT view, 9-19

REPPARAMETER_COLUMN view, 9-20

REPPRIORITY view, 9-21

RepPriority_Group table

updating, 8-101

REPPRIORITY_GROUP view, 9-22

REPPROP view, 9-22

REPRESOL_STATS_CONTROL view, 9-24

RepResolution table

updating, 8-105

REPRESOLUTION view, 9-23

REPRESOLUTION_METHOD view, 9-24

RepResolution_Statistics table

purging, 8-147

REPRESOLUTION_STATISTICS view, 9-25

RepSite view

updating, 8-103

REPSITES view, 9-26

resolution methods

additive prebuilt, 6-10

average prebuilt, 6-10

discard, 6-3

earliest timestamp, 6-7

latest timestamp, 6-7

maximum value method, 6-5

minimum value method, 6-5

overwrite, 6-3

resume replication, 3-9

resuming replication activity, 8-155

S

scheduled link, 2-13

set_disabled, 8-39

setup master site, 2-4

site priority

altering, 8-96

site priority groups

adding members to, 8-84

creating

syntax, 8-121

dropping, 8-132

removing members from, 8-133

snapshot group

group owner, 7-5

snapshot logs

master table

purging, 8-255, 8-256, 8-257

snapshot sites

changing masters, 8-161

creating

syntax, 8-114

dropping, 7-9, 8-134

propagating changes to master, 8-37

refreshing

syntax, 8-148

SNAPSHOT_LOGS view, 9-34

snapshots

data dictionary views for, 9-32 to 9-37

offline instantiation of, 8-55, 8-57

refresh groups

data dictionary views, 9-32

refreshing, 8-259, 8-261, 8-263

SNAPSHOTS view, 9-32

statistics

collecting, 8-150

status

propagation, 8-25

T

tables

comparing, 8-60

rectifying, 8-63

Template

See Deployment Template

V

views

REFRESH_CHILDREN, 9-37

REGISTERED_SNAPSHOTS, 9-34

REPCAT_REFRESH_TEMPLATES, 9-6

REPCAT_TEMPLATE_OBJECTS, 9-6

REPCAT_TEMPLATE_PARMS, 9-8

REPCAT_TEMPLATE_SITES, 9-11

REPCAT_USER_PARM_VALUES, 9-13

REPCATLOG, 9-5, 9-6, 9-12, 9-13

REPCOLUMN, 9-15

REPCOLUMN_GROUP, 9-15, 9-16

REPGROUP_PRIVILEGES, 9-17

REPGROUPED_COLUMN, 9-18

REPKEY_COLUMNS, 9-18

replication catalog, 9-2

REPOBJECT, 9-19

REPPARAMETER_COLUMN, 9-20

REPPRIORITY, 9-21

REPPRIORITY_GROUP, 9-22

REPPROP, 9-22

REPRESOL_STATS_CONTROL, 9-24

REPRESOLUTION, 9-23

REPRESOLUTION_METHOD, 9-24

REPRESOLUTION_STATISTICS, 9-25

REPSITES, 9-26

SNAPSHOT_LOGS, 9-34

SNAPSHOT_REFRESH_TIMES, 9-35