Index

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

A

administrative requests

monitoring, 10-16

errors, 10-17

jobs, 10-18

administrators

for materialized view sites

creating, 2-25

ALL_REPCAT_REFRESH_TEMPLATES view, 25-5

ALL_REPCAT_TEMPLATE_OBJECTS view, 25-6

ALL_REPCAT_TEMPLATE_PARMS view, 25-8

ALL_REPCAT_TEMPLATE_SITES view, 25-10

ALL_REPCAT_USER_AUTHORIZATIONS view, 25-11

ALL_REPCAT_USER_PARM_VALUES view, 25-12

ALL_REPCATLOG view, 25-15

ALL_REPCOLUMN view, 25-16

ALL_REPCOLUMN_GROUP view, 25-18

ALL_REPCONFLICT view, 25-19

ALL_REPDDL view, 25-20

ALL_REPGENOBJECTS view, 25-20

ALL_REPGROUP view, 25-21

ALL_REPGROUP_PRIVILEGES view, 25-22

ALL_REPGROUPED_COLUMN view, 25-22

ALL_REPKEY_COLUMNS view, 25-23

ALL_REPOBJECT view, 25-24

ALL_REPPARAMETER_COLUMN view, 25-25

ALL_REPPRIORITY view, 25-26

ALL_REPPRIORITY_GROUP view, 25-27

ALL_REPPROP view, 25-28

ALL_REPRESOL_STATS_CONTROL view, 25-29

ALL_REPRESOLUTION view, 25-30

ALL_REPRESOLUTION_METHOD view, 25-31

ALL_REPRESOLUTION_STATISTICS view, 25-32

gathering statistics, 6-41

ALL_REPSITES view, 25-33

ALTER MATERIALIZED VIEW LOG statement, 8-16

AnyData datatype

replication, 9-16

authorization

template users, 4-12

availability

extended, 6-3, 7-4, 9-2, 20-9, 20-28, 20-81, 20-94, 20-99, 20-104

C

column objects

user-defined conflict resolution, B-3

column subsetting

user-defined conflict resolution methods, B-5

columns

adding to master tables, 20-91

column groups, 6-4, 6-7, 6-11, 6-14, 6-17, 6-22

adding members to, 20-7

creating, 20-56, 20-79

dropping, 20-60

removing members from, 20-61

comments

comments field

updating in views, 7-45

updating, 7-45

comparing

tables, 18-3

conflict resolution, 6-1

additive method, 6-13, 20-17

auditing, 6-41

average method, 6-13

column groups, 6-4, 6-7, 6-11, 6-14, 6-17, 6-22

configuring without quiesce, 6-3

DBA_REPRESOLUTION_STATISTICS view, 6-42

discard method, 6-3

information

viewing, B-12

maximum method, 6-6

minimum method, 6-6

overwrite method, 6-3

preparing for, 6-2

priority groups method, 6-16

procedural replication and, 7-50

site priority method, 6-20

sample trigger, 6-22

statistics, 20-35, 20-87

canceling, 6-42

collecting, 6-41

viewing, 6-41

timestamp method, 6-9

sample trigger, 6-11

uniqueness, 6-25

user-defined methods, B-2

column objects, B-3

column subsetting, B-5

example, B-6

for delete conflicts, B-4

for uniqueness conflicts, B-3

for update conflicts, B-3

multitier materialized views, B-4

parameters, B-2

restrictions, B-5

viewing information, B-12

conflicts

avoiding

delete, 6-31

dynamic ownership, 6-35

notification log table

creating, B-8

sample, B-8

notification methods

user-defined, B-8

notification package

creating, B-9

sample, B-9

token passing, 6-37

workflow, 6-36

D

data definition language

altering replicated objects, 20-25

asynchronous, 20-74

data dictionary views

comments

updating, 7-45

materialized views, 28-1

refresh groups, 28-1

replication, 10-1, 25-1

database links

creating, 2-20, 2-34, 4-20, 5-5, 5-6, 5-12, 5-13

date expressions, 2-7

DBA_REGISTERED_MVIEW_GROUPS view, 25-5

DBA_REPCAT_REFRESH_TEMPLATES view, 25-34

DBA_REPCAT_TEMPLATE_OBJECTS view, 25-34

DBA_REPCAT_TEMPLATE_PARMS view, 25-34

DBA_REPCAT_TEMPLATE_SITES view, 25-35

DBA_REPCAT_USER_AUTHORIZATIONS view, 25-35

DBA_REPCAT_USER_PARM_VALUES view, 25-35

DBA_REPCATLOG view, 25-35

purging requests from, 20-82

DBA_REPCOLUMN view, 25-36

DBA_REPCOLUMN_GROUP view, 25-36

updating, 7-45, 20-36

DBA_REPCONFLICT view, 25-36

DBA_REPDDL view, 25-36

DBA_REPEXTENSIONS view, 25-36

DBA_REPGENOBJECTS view, 25-39

DBA_REPGROUP view, 25-39

updating, 7-45, 20-39

DBA_REPGROUP_PRIVILEGES view, 25-39

DBA_REPGROUPED_COLUMN view, 25-39

DBA_REPKEY_COLUMNS view, 25-39

DBA_REPOBJECT view, 25-40

updating, 7-45, 20-40

DBA_REPPARAMETER_COLUMN view, 25-40

DBA_REPPRIORITY view, 25-40

DBA_REPPRIORITY_GROUP view, 25-40

updating, 7-45, 20-38

DBA_REPPROP view, 25-40

DBA_REPRESOL_STATS_CONTROL view, 25-41

DBA_REPRESOLUTION view, 25-41

updating, 7-45, 20-43

DBA_REPRESOLUTION_METHOD view, 25-41

DBA_REPRESOLUTION_STATISTICS view, 25-41

purging, 6-42, 20-83

DBA_REPSITES view, 25-41

updating, 7-45, 20-41

DBA_REPSITES_NEW view, 25-42

DBMS_DEFER package, 12-1

ANY_CHAR_ARG procedure, 12-5

ANY_CLOB_ARG procedure, 12-5

ANY_VARCHAR2_ARG procedure, 12-5

ANYDATA_ARG procedure, 12-5

BLOB_ARG procedure, 12-5

CALL procedure, 12-3

CHAR_ARG procedure, 12-5

CLOB_ARG procedure, 12-5

COMMIT_WORK procedure, 12-4

datatype_ARG procedure, 12-5

DATE_ARG procedure, 12-5

IDS_ARG procedure, 12-5

IYM_ARG procedure, 12-5

NCHAR_ARG procedure, 12-5

NCLOB_ARG procedure, 12-5

NUMBER_ARG procedure, 12-5

NVARCHAR2_ARG procedure, 12-5

RAW_ARG procedure, 12-5

ROWID_ARG procedure, 12-5

TIMESTAMP_ARG procedure, 12-5

TRANSACTION procedure, 12-6

TSLTZ_ARG procedure, 12-5

TSTZ_ARG procedure, 12-5

VARCHAR2_ARG procedure, 12-5

DBMS_DEFER_QUERY package, 13-1

GET_AnyData_ARG function, 9-16, 13-7

GET_ARG_FORM function, 13-3

GET_ARG_TYPE function, 13-4

GET_BLOB_ARG function, 13-7

GET_CALL_ARGS procedure, 13-6

GET_CHAR_ARG function, 13-7

GET_CLOB_ARG function, 13-7

GET_datatype_ARG function, 13-7

GET_DATE_ARG function, 13-7

GET_IDS_ARG function, 13-7

GET_IYM_ARG function, 13-7

GET_NCHAR_ARG function, 13-7

GET_NCLOB_ARG function, 13-7

GET_NUMBER_ARG function, 13-7

GET_NVARCHAR2_ARG function, 13-7

GET_OBJECT_NULL_VECTOR_ARG function, 13-10

GET_RAW_ARG function, 13-7

GET_ROWID_ARG function, 13-7

GET_TIMESTAMP_ARG function, 13-7

GET_TSLTZ_ARG function, 13-7

GET_TSTZ_ARG function, 13-7

GET_VARCHAR2_ARG function, 13-7

DBMS_DEFER_SYS package

ADD_DEFAULT_DEST procedure, 14-4

CLEAR_PROP_STATISTICS procedure, 10-31, 14-4

DELETE_DEF_DESTINATION procedure, 14-5

DELETE_DEFAULT_DEST procedure, 14-5

DELETE_ERROR procedure, 14-6

DELETE_TRAN procedure, 14-7, 14-9

DISABLED function, 14-7

EXCLUDE_PUSH function, 14-8

EXECUTE_ERROR procedure, 7-37, 9-19, 14-9

EXECUTE_ERROR_AS_USER procedure, 9-20, 14-10

PURGE function, 9-15, 14-11

PUSH function, 9-14, 14-14

REGISTER_PROPAGATOR procedure, 2-7, 2-26, 2-33, 14-16

SCHEDULE_EXECUTION procedure, 14-19

SCHEDULE_PURGE procedure, 2-8, 2-29, 2-35, 14-17

SCHEDULE_PUSH procedure, 2-21, 2-29, 2-35, 14-19

SET_DISABLED procedure, 14-21

UNREGISTER_PROPAGATOR procedure, 14-23

UNSCHEDULE_PURGE procedure, 14-24

UNSCHEDULE_PUSH procedure, 14-24

DBMS_MVIEW package

BEGIN_TABLE_REORGANIZATION procedure, 8-20, 15-3

END_TABLE_REORGANIZATION procedure, 8-20, 15-3

EXPLAIN_MVIEW procedure, 15-4

EXPLAIN_REWRITE procedure, 15-5

I_AM_A_REFRESH function, 15-6

PMARKER function, 15-6

PURGE_DIRECT_LOAD_LOG procedure, 15-7

PURGE_LOG procedure, 8-18, 15-7

PURGE_MVIEW_FROM_LOG procedure, 8-11, 8-13, 8-15, 8-18, 15-8

REFRESH procedure, 8-2, 8-34, 15-9

REFRESH_ALL_MVIEWS procedure, 15-12

REFRESH_DEPENDENT procedure, 15-13

REGISTER_MVIEW procedure, 15-15

UNREGISTER_MVIEW procedure, 8-13, 15-18

DBMS_OFFLINE_OG package

BEGIN_INSTANTIATION procedure, 7-38, 16-3

BEGIN_LOAD procedure, 7-39, 16-4

END_INSTANTIATION procedure, 7-41, 16-5

END_LOAD procedure, 7-40, 16-6

RESUME_SUBSET_OF_MASTERS procedure, 7-39, 16-8

DBMS_OFFLINE_SNAPSHOT package

BEGIN_LOAD procedure, 8-30, 17-3

END_LOAD procedure, 8-32, 17-4

DBMS_RECTIFIER_DIFF package, 9-9

DIFFERENCES procedure, 9-9, 18-3

RECTIFY procedure, 9-9, 18-5

DBMS_REFRESH package

ADD procedure, 5-10, 5-18, 19-3

CHANGE procedure, 19-3

DESTROY procedure, 19-5

MAKE procedure, 5-7, 5-14, 19-6

REFRESH procedure, 8-2, 19-8

SUBTRACT procedure, 19-9

DBMS_REPCAT package

ADD_DELETE_RESOLUTION procedure, 20-17

ADD_GROUPED_COLUMN procedure, 20-7

ADD_MASTER_DATABASE procedure, 3-11, 7-31, 7-33, 20-8

ADD_NEW_MASTERS procedure, 7-13, 7-25, 20-9

ADD_PRIORITY_CHAR procedure, 20-14

ADD_PRIORITY_datatype procedure, 20-14

ADD_PRIORITY_DATE procedure, 20-14

ADD_PRIORITY_NUMBER procedure, 20-14

ADD_PRIORITY_VARCHAR2 procedure, 20-14

ADD_SITE_PRIORITY_SITE procedure, 6-23, 20-16

ADD_UNIQUENESS_RESOLUTION procedure, 20-17

ADD_UPDATE_RESOLUTION procedure, 6-5, 6-8, 6-12, 6-14, 6-19, 6-24, 20-17

ALTER_CATCHUP_PARAMETERS procedure, 20-22

ALTER_MASTER_PROPAGATION procedure, 20-24

ALTER_MASTER_REPOBJECT procedure, 6-10, 6-21, 6-32, 9-2, 20-25

ALTER_MVIEW_PROPAGATION procedure, 20-29

ALTER_PRIORITY procedure, 20-30

ALTER_PRIORITY_CHAR procedure, 20-31

ALTER_PRIORITY_datatype procedure, 20-31

ALTER_PRIORITY_DATE procedure, 20-31

ALTER_PRIORITY_NUMBER procedure, 20-31

ALTER_PRIORITY_RAW procedure, 20-31

ALTER_SITE_PRIORITY procedure, 20-33

ALTER_SITE_PRIORITY_SITE procedure, 20-34

CANCEL_STATISTICS procedure, 6-42, 20-35

comment procedures, 7-45

COMMENT_ON_COLUMN_GROUP procedure, 7-45, 20-36

COMMENT_ON_DELETE_RESOLUTION procedure, 7-45, 20-43

COMMENT_ON_MVIEW_REPSITES procedure, 20-37

COMMENT_ON_PRIORITY_GROUP procedure, 7-45, 20-38

COMMENT_ON_REPGROUP procedure, 7-45, 20-39

COMMENT_ON_REPOBJECT procedure, 7-45, 20-40

COMMENT_ON_REPSITES procedure, 7-45, 20-41

COMMENT_ON_SITE_PRIORITY procedure, 20-38

COMMENT_ON_UNIQUE_RESOLUTION procedure, 7-45, 20-43

COMMENT_ON_UPDATE_RESOLUTION procedure, 7-45, 20-43

COMPARE_OLD_VALUES procedure, 20-44

CREATE_MASTER_REPGROUP procedure, 3-6, 20-47

CREATE_MASTER_REPOBJECT procedure, 6-11, 6-22, 20-48

CREATE_MVIEW_REPGROUP procedure, 5-7, 5-14, 8-30, 8-36, 8-37, 20-52

CREATE_MVIEW_REPOBJECT procedure, 5-8, 5-9, 5-10, 5-16, 5-17, 8-36, 8-39, 20-53

DEFINE_COLUMN_GROUP procedure, 20-56

DEFINE_PRIORITY_GROUP procedure, 20-57

DEFINE_SITE_PRIORITY procedure, 6-23, 20-58

DO_DEFERRED_REPCAT_ADMIN procedure, 6-35, 7-37, 20-59

DROP_COLUMN_GROUP procedure, 20-60

DROP_DELETE_RESOLUTION procedure, 20-72

DROP_GROUPED_COLUMN procedure, 20-61

DROP_MASTER_REPGROUP procedure, 20-62

DROP_MASTER_REPOBJECT procedure, 20-64

DROP_MVIEW_REPGROUP procedure, 8-4, 8-6, 8-9, 20-65

DROP_MVIEW_REPOBJECT procedure, 8-10, 20-66

DROP_PRIORITY procedure, 20-67

DROP_PRIORITY_CHAR procedure, 20-69

DROP_PRIORITY_datatype procedure, 20-69

DROP_PRIORITY_DATE procedure, 20-69

DROP_PRIORITY_GROUP procedure, 20-68

DROP_PRIORITY_NUMBER procedure, 20-69

DROP_PRIORITY_VARCHAR2 procedure, 20-69

DROP_SITE_PRIORITY procedure, 20-70

DROP_SITE_PRIORITY_SITE procedure, 20-71

DROP_UNIQUE_RESOLUTION procedure, 20-72

DROP_UPDATE_RESOLUTION procedure, 20-72

EXECUTE_DDL procedure, 20-74

GENERATE_MVIEW_SUPPORT procedure, 20-75

GENERATE_REPLICATION_SUPPORT procedure, 3-13, 3-14, 9-4, 20-77

MAKE_COLUMN_GROUP procedure, 6-4, 6-7, 6-11, 6-14, 6-17, 6-22, 20-79

PREPARE_INSTANTIATED_MASTER procedure, 7-19, 7-29

PREPARE_INSTANTIATED_MASTERS procedure, 20-81

PURGE_MASTER_LOG procedure, 20-82

PURGE_STATISTICS procedure, 6-42, 20-83

REFRESH_MVIEW_REPGROUP procedure, 20-84

REGISTER_MVIEW_REPGROUP procedure, 20-86

REGISTER_STATISTICS procedure, 6-41, 20-87

RELOCATE_MASTERDEF procedure, 7-2, 20-88

REMOVE_MASTER_DATABASE procedure, 7-42

REMOVE_MASTER_DATABASES procedure, 20-90

RENAME_SHADOW_COLUMN_GROUP procedure, 20-91

REPCAT_IMPORT_CHECK procedure, 20-92

RESUME_MASTER_ACTIVITY procedure, 3-15, 20-93

RESUME_PROPAGATION_TO_MDEF procedure, 7-16, 7-28, 20-94

SEND_OLD_VALUES procedure, 20-95

SET_COLUMNS procedure, 20-47, 20-97

SPECIFY_NEW_MASTERS procedure, 7-12, 7-25, 20-99

SUSPEND_MASTER_ACTIVITY procedure, 20-102

SWITCH_MVIEW_MASTER procedure, 8-2, 20-102

UNDO_ADD_NEW_MASTERS_REQUEST procedure, 20-104

UNREGISTER_MVIEW_REPGROUP procedure, 8-11, 20-105

VALIDATE procedure, 20-106

WAIT_MASTER_LOG procedure, 20-108

DBMS_REPCAT_ADMIN package

GRANT_ADMIN_ANY_SCHEMA procedure, 2-6, 2-26, 2-32, 21-3

GRANT_ADMIN_SCHEMA procedure, 21-3

REGISTER_USER_REPGROUP procedure, 2-7, 2-9, 2-14, 2-19, 2-27, 2-30, 21-4

REVOKE_ADMIN_ANY_SCHEMA procedure, 21-6

REVOKE_ADMIN_SCHEMA procedure, 21-6

UNREGISTER_USER_REPGROUP procedure, 21-7

DBMS_REPCAT_INSTANTIATE package

DROP_SITE_INSTANTIATION procedure, 8-4, 8-6, 22-3

INSTANTIATE_OFFLINE function, 22-3

INSTANTIATE_ONLINE function, 22-6

DBMS_REPCAT_RGT package

ALTER_REFRESH_TEMPLATE procedure, 23-5

ALTER_TEMPLATE_OBJECT procedure, 23-7

ALTER_TEMPLATE_PARM procedure, 23-10

ALTER_USER_AUTHORIZATION procedure, 23-11

ALTER_USER_PARM_VALUE procedure, 23-13

COMPARE_TEMPLATES function, 23-15

COPY_TEMPLATE function, 23-16

CREATE_OBJECT_FROM_EXISTING function, 23-19

CREATE_REFRESH_TEMPLATE function, 23-21

CREATE_REFRESH_TEMPLATE procedure, 4-5

CREATE_TEMPLATE_OBJECT function, 23-23

CREATE_TEMPLATE_OBJECT procedure, 4-7

CREATE_TEMPLATE_PARM function, 23-26

CREATE_USER_AUTHORIZATION function, 23-28

CREATE_USER_AUTHORIZATION procedure, 4-12

CREATE_USER_PARM_VALUE function, 23-29

DELETE_RUNTIME_PARMS procedure, 23-31

DROP_ALL_OBJECTS procedure, 23-32

DROP_ALL_TEMPLATE_PARMS procedure, 23-33

DROP_ALL_TEMPLATE_SITES procedure, 23-34

DROP_ALL_TEMPLATES procedure, 23-35

DROP_ALL_USER_AUTHORIZATIONS procedure, 23-35

DROP_ALL_USER_PARM_VALUES procedure, 23-36

DROP_REFRESH_TEMPLATE procedure, 23-38

DROP_SITE_INSTANTIATION procedure, 23-39

DROP_TEMPLATE_OBJECT procedure, 23-40

DROP_TEMPLATE_PARM procedure, 23-41

DROP_USER_AUTHORIZATION procedure, 23-42

DROP_USER_PARM_VALUE procedure, 23-43

GET_RUNTIME_PARM_ID function, 23-44

INSERT_RUNTIME_PARMS procedure, 23-44

INSTANTIATE_OFFLINE function, 23-46

INSTANTIATE_OFFLINE procedure, 4-15

INSTANTIATE_ONLINE function, 23-49

INSTANTIATE_ONLINE procedure, 4-16

LOCK_TEMPLATE_EXCLUSIVE procedure, 23-51

LOCK_TEMPLATE_SHARED procedure, 23-52

DBMS_REPUTIL package

FROM_REMOTE function, 24-4

GLOBAL_NAME function, 24-4

MAKE_INTERNAL_PKG procedure, 24-4

REPLICATION_IS_ON function, 24-3

REPLICATION_OFF procedure, 7-50, 9-5, 24-3

REPLICATION_ON procedure, 7-50, 9-6, 24-3

SYNC_UP_REP procedure, 24-5

DDL. See data definition language

DEFCALL view, 27-2

DEFCALLDEST view, 27-2

DEFDEFAULTDEST view, 27-2

adding destinations to, 14-4

removing destinations from, 14-5

DEFERRCOUNT view, 27-3

deferred transaction queues

deferred calls

determining value of, 9-16

managing, 9-14

purging propagated transactions, 9-15

pushing, 9-14

deferred transactions

data dictionary views, 27-1

DEFDEFAULTDEST view

adding destination to, 14-4

removing destinations from, 14-5

deferred remote procedure calls (RPCs)

argument types, 13-4

argument values, 13-7

arguments to, 12-5

building, 12-3

executing immediately, 14-14

DEFSCHEDULE view

clearing statistics, 14-4

removing destinations from, 14-5

deleting from queue, 14-7

monitoring, 10-19

purge job, 10-22, 10-23

push jobs, 10-20, 10-21

reexecuting, 14-9

scheduling execution, 14-19

starting, 12-6

DEFERROR view, 9-18, 27-3

deleting transactions from, 14-6

DEFLOB view, 27-3

DEFPROPAGATOR view, 27-4

DEFSCHEDULE view, 27-4

clearing statistics, 10-31, 14-4

DEFTRAN view, 27-6

DEFTRANDEST view, 27-7

deployment templates

adding objects to, 4-6

alter object, 23-7

alter parameters, 23-10

alter template, 23-5

alter user authorization, 23-11

alter user parameter values, 23-13

authorize users, 4-12

compare templates, 23-15

concepts, 4-2

copy template, 23-16

create object from existing, 23-19

create template, 23-21

creating, 4-3, 4-5

data dictionary views for, 25-5

distributing files, 4-18

drop site instantiation, 22-3

dropping, 23-38

dropping all, 23-35

dropping materialized view group, 8-4

flowchart for creating, 4-4

instantiating, 4-19

instantiation script, 4-16

lock template, 23-51, 23-52

monitoring, 10-9

objects

creating, 23-23

dropping, 23-40

dropping all, 23-32

offline instantiation, 4-12, 22-3, 23-46

online instantiation, 22-6, 23-49

packaging, 4-12, 4-14

for offline instantiation, 4-14

for online instantiation, 4-15

parameters

creating, 4-10, 23-26

dropping, 23-41

dropping all, 23-33

user values, 4-11

runtime parameters

creating, 23-44

deleting, 23-31

get ID, 23-44

inserting, 23-44

sites

dropping, 23-39

dropping all, 23-34

user authorizations

creating, 23-28

dropping, 23-42

dropping all, 23-35

user parameter values

creating, 23-29

dropping, 23-43

dropping all, 23-36

user-defined types, 4-2

differences

between tables, 18-3

rectifying, 18-5

disabling

propagation, 14-21

DROP MATERIALIZED VIEW LOG statement, 8-24

dynamic ownership

conflict avoidance and, 6-35

locating owner of a row, 6-39

obtaining ownership, 6-39

workflow partitioning, 6-36

dynamic performance views

replication, 26-1

E

errors

error queues

DEFERROR view, 9-18

managing, 9-18

error transactions

monitoring, 10-24

reexecuting as alternate user, 9-20

reexecuting as receiver, 9-19

reexecuting multiple, 9-19

extended availability, 6-3, 7-4, 9-2, 20-9, 20-28, 20-81, 20-94, 20-99, 20-104

F

foreign key constraints

adding master sites, 7-4

G

generating

replication support, 3-13

procedural replication, 7-50

I

Import

materialized views

offline instantiation and, 17-3, 17-4

replication groups

offline instantiation and, 16-4, 16-6

status check, 20-92

instantiation, 4-19

DROP_SITE_INSTANTIATION procedure, 22-3, 23-39

offline, 4-12

INSTANTIATE_OFFLINE function, 22-3, 23-46

online

INSTANTIATE_ONLINE function, 22-6, 23-49

refreshing after, 4-21

script, 4-16

J

jobs

queues for

removing jobs from, 14-24

L

LONG columns

replication, 9-7

M

master definition site

relocating, 20-88

master groups

adding master sites to

with quiesce, 7-31

without quiesce, 7-4

adding objects to, 3-7

creating, 3-2, 3-6, 20-47

dropping, 20-62

flowchart for creating, 3-5

monitoring, 10-3

quiescing, 20-102

removing master sites from, 7-41

resuming replication activity, 20-93

master materialized views

monitoring, 10-6

reorganizing, 8-20

master sites

adding, 3-11, 7-4

circular dependencies, 3-11, 7-4

flowchart for, 7-10, 7-21

flowchart for determining method, 7-6

foreign key constraints, 7-4

restrictions, 7-7

restrictions for change-based recovery, 7-5

restrictions for full database export/import, 7-5

self-referential constraints, 3-11, 7-4

using change-based recovery, 7-9

using full database export/import, 7-9

using object-level export/import, 7-20

using offline instantiation, 7-35

with quiesce, 7-31

without quiesce, 7-4

changing master definition site, 7-2

cleaning up, 8-10

creating, 20-8

creating users for, 2-8, 2-12, 2-17, 2-30

database links, 2-20

determining differences, 9-9

dropping, 20-90

flowchart for setting up, 2-4

monitoring, 10-2, 10-6

propagating changes between, 14-19

removing, 7-41

scheduled links for, 2-21

scheduled purges for, 2-7

setup, 2-5

master tables

adding columns to, 20-91

redefining online, 8-20

reorganizing, 8-20

methods, 8-21

truncating, 8-20

materialized view groups

adding objects to, 5-8, 5-16, 8-39

changing masters, 8-2

creating, 5-4, 5-6, 5-14, 20-52

dropping, 8-4, 8-9

group owner, 8-36

monitoring, 10-11

refreshing, 20-84

unregistering from master, 8-11

materialized view logs

adding columns, 8-16

altering, 8-16

privileges required, 8-16

dropping, 8-24

managing, 8-16

space, 8-17

master table

purging, 15-7, 15-8

monitoring, 10-7

purging

materialized views from, 8-11, 8-13

privileges required, 8-18

purging rows from

manually, 8-18

reducing space allocated to, 8-18

reorganizing masters with, 8-20

truncating, 8-18

truncating master table with, 8-20

materialized view sites

adding

using offline instantiation, 8-25

administrators

creating, 2-25

changing masters, 20-102

database links

creating, 2-34, 4-20, 5-5, 5-6, 5-12, 5-13

dropping, 8-3, 20-65

dropping objects from, 8-8

flowchart for setting up, 2-24

group owner

using, 8-36

monitoring, 10-10

multitier

setting up, 2-24

propagating changes to master, 14-19

refresher

creating, 2-25, 2-32

schedule purge, 2-28, 2-35

users

creating, 2-25

materialized views

data dictionary views, 28-1

deployment templates

user-defined types, 4-2

dropping, 8-10

generating support for, 20-75

monitoring, 10-10, 10-12

multitier

setting up, 5-4

user-defined conflict resolution, B-4

offline instantiation of, 17-3, 17-4

purging from materialized view logs, 8-11, 8-13

refresh groups

creating, 5-7, 5-14

refreshing, 4-21, 8-2, 8-34, 15-9, 15-12, 15-13

security, A-7

trusted compared with untrusted, A-8

unregistering from master, 8-13

multimaster replication

monitoring, 10-2

security

trusted compared with untrusted, A-3

multitier materialized views

setting up, 2-24

N

notification log table

conflicts

creating, B-8

sample, B-8

notification methods

user-defined, B-8

notification package

conflicts

creating, B-9

O

objects

adding to materialized view sites, 20-53

altering, 20-25

altering replication, 9-2

creating

for master group, 20-47, 20-48

for materialized view sites, 20-53

dropping

from materialized view site, 8-8, 20-66

generating replication support for, 20-77

offline instantiation

adding a master site, 7-35

adding a materialized view site, 8-25

INSTANTIATE_OFFLINE function, 22-3, 23-46

materialized views, 17-3, 17-4

replication groups, 16-3, 16-4, 16-5, 16-6, 16-8

online instantiation

INSTANTIATE_ONLINE function, 22-6, 23-49

online redefinition of tables, 8-20

Oracle Replication Management tool

monitoring replication, 10-1

P

packaging

deployment templates, 4-12

parallel propagation

monitoring, 10-30, 10-31

parameters

deployment templates, 4-10

user values, 4-11

performance

replication

monitoring, 10-28

planning

for replication, 1-4

PRESERVE MATERIALIZED VIEW LOG option

TRUNCATE TABLE statement, 8-21

priority groups

adding members to, 20-14

altering members

priorities, 20-30

values, 20-31

creating, 20-57

dropping, 20-68

removing members from, 20-67, 20-69

site priority groups

adding members to, 20-16

procedural replication

conflicts and, 7-50

generating replication support for, 7-50

restrictions, 7-47

serialization of transactions, 7-50

user-defined types, 7-49

using, 7-47

propagation

altering method, 20-24, 20-29

disabling, 14-21

of changes, 20-24

parallel

monitoring, 10-30, 10-31

status of, 14-7

propagator

registering, 2-6, 2-7, 14-16

proxy materialized view administrator

creating, 2-8, 2-12, 2-17, 2-30

purges

DBA_REPCATLOG table, 20-82

deferred transaction queue, 9-15

master sites, 2-7

materialized view sites, 2-28, 2-35

monitoring, 10-22

pushes

deferred transaction queue, 9-14

Q

quiescing

adding master sites with, 7-31

adding master sites without, 7-4

altering replicated objects without, 9-2

configuring conflict resolution methods without, 6-3

master groups, 20-102

R

receiver

registering, 2-7

rectifying

tables, 9-9, 18-5

redefining tables

online

replication, 8-20

refresh

materialized view sites, 20-84

materialized views, 8-2, 8-34, 15-9, 15-12, 15-13

monitoring, 10-15, 10-16

refresh groups

adding members to, 19-3

adding objects to, 5-10, 5-18

creating, 5-7, 5-14, 19-6

data dictionary views, 28-1

deleting, 19-5

monitoring, 10-14

refresh, 8-2

refresh interval

changing, 19-3

refreshing

manually, 19-8

removing members from, 19-9

refresher

creating, 2-25, 2-32

replication

catalog views, 10-1, 25-1

column groups, 6-4, 6-7, 6-11, 6-14, 6-17, 6-22

conflict resolution, 6-1

uniqueness, 6-25

creating an environment, 1-2

data dictionary views, 10-1, 25-1

database links

creating, 2-20

datetime datatypes

abbreviations, 11-4

deferred transaction queues

managing, 9-14

deferred transactions

data dictionary views, 27-1

deployment templates

user-defined types, 4-2

determining differences between tables, 9-9

disabling, 7-50, 9-5, 24-3

dynamic performance views, 26-1

enabling, 7-50, 9-5, 9-6, 24-3

error queues

managing, 9-18

flowchart for creating environment, 1-2

generating support for, 3-13

interval datatypes

abbreviations, 11-4

LONG column

converting to LOB, 9-7

managing an environment, 43

master groups

creating, 3-2

master sites

adding, 3-11

materialized view groups

creating, 5-4, 5-6, 5-14

materialized view logs

managing, 8-16

monitoring, 10-1

deferred transactions, 10-19

error transactions, 10-24

master environments, 10-2

materialized view environments, 10-10

performance, 10-28

objects

adding to deployment template, 4-6

adding to master group, 3-7

altering, 6-10, 9-2

dropping from master sites, 20-64

parallel propagation

monitoring, 10-30, 10-31

planning for, 1-4

procedural replication, 7-47

restrictions, 7-47

user-defined types, 7-49

propagator

registering, 2-6, 2-7

receiver

registering, 2-7

replicated objects, 9-1

replication queues, 9-1

resuming, 3-15

scheduled links

creating, 2-21

security, A-1

setting up sites, 2-2

sites

setup, 2-2

statistics

clearing, 10-31

triggers, 9-7

replication catalog views, 25-1

comments

updating, 7-45

monitoring replication, 10-1

replication management API, 11-1

conflict resolution, 6-1

deployment templates

creating, 4-3

instantiating, 4-19

packaging, 4-12

examples, 11-2

managing a replication environment, 43

managing replicated objects, 9-1

managing replication queues, 9-1

master groups

creating, 3-2

materialized view groups

creating, 5-4

overview, 1-1

packages, 35, 36, 11-1

setting up replication sites, 2-2

replication objects

altering, 9-2

tables

altering, 9-5

resuming replication activity, 20-93

S

scheduled links

creating, 2-21

security

for materialized view replication, A-7

trusted compared with untrusted, A-8

for multimaster replication, A-2

trusted compared with untrusted, A-3

replication, A-1

trusted compared with untrusted, A-3, A-8

serialization

of transactions, 7-50

site priority

altering, 20-33

site priority groups

adding members to, 20-16

creating

syntax, 20-58

dropping, 20-70

removing members from, 20-71

snapshots. See materialized views

statistics

for conflict resolution

auditing, 6-41

cancelling, 6-42

clearing, 6-42, 20-83

collecting, 6-41, 20-87

viewing, 6-41

for propagation

clearing, 10-31, 14-4

status

propagation, 14-7

storage parameters

materialized view log

altering, 8-16

SYS.ANYDATA, 13-7

T

tables

altering

without replicating changes, 9-5

altering replicated, 9-2

comparing, 18-3

differences between, 9-9

rectifying, 9-9, 18-5

redefining online

replication, 8-20

updating comments, 7-45

templates. See deployment templates

token passing, 6-37

sample implementation, 6-35

transactions

serialization of, 7-50

triggers

for site priority conflict resolution, 6-22

for timestamp conflict resolution, 6-11

replicating, 9-7

TRUNCATE statement, 8-19

TRUNCATE TABLE statement

PRESERVE MATERIALIZED VIEW LOG option, 8-21

trusted security, A-3, A-8

U

USER_REPCAT_REFRESH_TEMPLATES view, 25-43

USER_REPCAT_TEMP_OUTPUT view, 4-14

USER_REPCAT_TEMPLATE_OBJECTS view, 25-44

USER_REPCAT_TEMPLATE_PARMS view, 25-44

USER_REPCAT_TEMPLATE_SITES view, 25-44

USER_REPCAT_USER_AUTHORIZATIONS view, 25-44

USER_REPCAT_USER_PARM_VALUES view, 25-45

USER_REPCATLOG view, 25-45

USER_REPCOLUMN view, 25-45

USER_REPCOLUMN_GROUP view, 25-45

USER_REPCONFLICT view, 25-46

USER_REPDDL view, 25-46

USER_REPGENOBJECTS view, 25-46

USER_REPGROUP view, 25-46

USER_REPGROUP_PRIVILEGES view, 25-46

USER_REPGROUPED_COLUMN view, 25-46

USER_REPKEY_COLUMNS view, 25-47

USER_REPOBJECT view, 25-47

USER_REPPARAMETER_COLUMN view, 25-47

USER_REPPRIORITY view, 25-47

USER_REPPRIORITY_GROUP view, 25-48

USER_REPPROP view, 25-48

USER_REPRESOL_STATS_CONTROL view, 25-48

USER_REPRESOLUTION view, 25-48

USER_REPRESOLUTION_METHOD view, 25-49

USER_REPRESOLUTION_STATISTICS view, 25-49

USER_REPSITES view, 25-49

users

authorize for deployment template, 4-12

master materialized view sites, 2-30

master sites, 2-8, 2-12, 2-17

materialized view sites, 2-25

V

V$MVREFRESH view, 26-2

V$REPLPROP view, 10-31, 26-2

V$REPLQUEUE view, 26-4

W

workflow, 6-36