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

errors, 10-18

jobs, 10-19

administrators

for materialized view sites

creating, 2-20

for replication

creating, 2-4

ALL_MVIEW_LOGS view, 28-3

ALL_MVIEW_REFRESH_TIMES view, 28-4

ALL_MVIEWS view, 28-5

ALL_REFRESH view, 28-9

ALL_REFRESH_CHILDREN view, 28-10

ALL_REGISTERED_MVIEWS view, 28-11

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

ALL_REPCAT_USER_AUTHORIZATIONS view, 25-12

ALL_REPCAT_USER_PARM_VALUES view, 25-13

ALL_REPCATLOG view, 25-15

ALL_REPCOLUMN view, 25-17

ALL_REPCOLUMN_GROUP view, 25-19

ALL_REPCONFLICT view, 25-20

ALL_REPDDL view, 25-21

ALL_REPGENOBJECTS view, 25-22

ALL_REPGROUP view, 25-23

ALL_REPGROUP_PRIVILEGES view, 25-24

ALL_REPGROUPED_COLUMN view, 25-25

ALL_REPKEY_COLUMNS view, 25-26

ALL_REPOBJECT view, 25-27

ALL_REPPARAMETER_COLUMN view, 25-29

ALL_REPPRIORITY view, 25-30

ALL_REPPRIORITY_GROUP view, 25-32

ALL_REPPROP view, 25-33

ALL_REPRESOL_STATS_CONTROL view, 25-34

ALL_REPRESOLUTION view, 25-35

ALL_REPRESOLUTION_METHOD view, 25-36

ALL_REPRESOLUTION_STATISTICS view, 25-37

gathering statistics, 6-41

ALL_REPSITES view, 25-38

ALTER MATERIALIZED VIEW LOG statement, 8-15

AnyData datatype

replication, 9-16

authorization

template users, 4-12

availability

extended, 6-3, 7-4, 9-2, 20-11, 20-31, 20-87, 20-101, 20-107, 20-111

C

column objects

user-defined conflict resolution, B-3

column subsetting

user-defined conflict resolution methods, B-5

columns

adding to master tables, 20-98

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

adding members to, 20-8

creating, 20-61, 20-85

dropping, 20-66

removing members from, 20-67

comments

comments field

updating in views, 7-40

updating, 7-40

comparing

tables, 18-3

conflict resolution, 6-1

additive method, 6-13, 20-20

auditing, 6-41

average method, 6-13

column groups, 6-5, 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-15

procedural replication and, 7-45

site priority method, 6-20

sample trigger, 6-22

statistics, 20-40, 20-94

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

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

asynchronous, 20-80

data dictionary views

comments

updating, 7-40

materialized views, 28-1

refresh groups, 28-1

replication, 10-1, 25-1

database links

creating, 2-15, 2-29, 4-20, 5-5, 5-6, 5-12, 5-13

date expressions, 2-6

DBA_BASE_TABLE_MVIEWS view, 28-12

DBA_MVIEW_LOG_FILTER_COLS view, 28-12

DBA_MVIEW_LOGS view, 28-12

DBA_MVIEW_REFRESH_TIMES view, 28-12

DBA_MVIEWS view, 28-5, 28-13

DBA_REFRESH view, 28-13

DBA_REFRESH_CHILDREN view, 28-13

DBA_REGISTERED_MVIEW_GROUPS view, 28-13

DBA_REGISTERED_MVIEWS view, 28-14

DBA_REPCAT_REFRESH_TEMPLATES view, 25-39

DBA_REPCAT_TEMPLATE_OBJECTS view, 25-39

DBA_REPCAT_TEMPLATE_PARMS view, 25-39

DBA_REPCAT_TEMPLATE_SITES view, 25-39

DBA_REPCAT_USER_AUTHORIZATIONS view, 25-40

DBA_REPCAT_USER_PARM_VALUES view, 25-40

DBA_REPCATLOG view, 25-40

purging requests from, 20-88

DBA_REPCOLUMN view, 25-41

DBA_REPCOLUMN_GROUP view, 25-41

updating, 7-40, 20-41

DBA_REPCONFLICT view, 25-41

DBA_REPDDL view, 25-41

DBA_REPEXTENSIONS view, 25-42

DBA_REPGENOBJECTS view, 25-45

DBA_REPGROUP view, 25-45

updating, 7-40, 20-44

DBA_REPGROUP_PRIVILEGES view, 25-45

DBA_REPGROUPED_COLUMN view, 25-45

DBA_REPKEY_COLUMNS view, 25-45

DBA_REPOBJECT view, 25-45

updating, 7-40, 20-45

DBA_REPPARAMETER_COLUMN view, 25-46

DBA_REPPRIORITY view, 25-46

DBA_REPPRIORITY_GROUP view, 25-46

updating, 7-40, 20-43

DBA_REPPROP view, 25-46

DBA_REPRESOL_STATS_CONTROL view, 25-47

DBA_REPRESOLUTION view, 25-47

updating, 7-40, 20-48

DBA_REPRESOLUTION_METHOD view, 25-47

DBA_REPRESOLUTION_STATISTICS view, 25-47

purging, 6-42, 20-89

DBA_REPSITES view, 25-48

updating, 7-40, 20-46

DBA_REPSITES_NEW view, 25-48

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

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

GET_ARG_FORM function, 13-3

GET_ARG_TYPE function, 13-5

GET_BLOB_ARG function, 13-9

GET_CALL_ARGS procedure, 13-7

GET_CHAR_ARG function, 13-9

GET_CLOB_ARG function, 13-9

GET_datatype_ARG function, 13-9

GET_DATE_ARG function, 13-9

GET_IDS_ARG function, 13-9

GET_IYM_ARG function, 13-9

GET_NCHAR_ARG function, 13-9

GET_NCLOB_ARG function, 13-9

GET_NUMBER_ARG function, 13-9

GET_NVARCHAR2_ARG function, 13-9

GET_OBJECT_NULL_VECTOR_ARG function, 13-12

GET_RAW_ARG function, 13-9

GET_ROWID_ARG function, 13-9

GET_TIMESTAMP_ARG function, 13-9

GET_TSLTZ_ARG function, 13-9

GET_TSTZ_ARG function, 13-9

GET_VARCHAR2_ARG function, 13-9

DBMS_DEFER_SYS package

ADD_DEFAULT_DEST procedure, 14-4

CLEAR_PROP_STATISTICS procedure, 10-33, 14-5

DELETE_DEF_DESTINATION procedure, 14-6

DELETE_DEFAULT_DEST procedure, 14-6

DELETE_ERROR procedure, 14-7

DELETE_TRAN procedure, 14-8, 14-9, 14-11

DISABLED function, 14-9

EXCLUDE_PUSH function, 14-10

EXECUTE_ERROR procedure, 7-33, 9-19, 14-11

EXECUTE_ERROR_AS_USER procedure, 9-20, 14-12

PURGE function, 9-15, 14-13

PUSH function, 9-14, 14-16

REGISTER_PROPAGATOR procedure, 2-6, 2-21, 2-28, 14-19

SCHEDULE_EXECUTION procedure, 14-22

SCHEDULE_PURGE procedure, 2-7, 2-24, 2-30, 14-20

SCHEDULE_PUSH procedure, 2-16, 2-17, 2-25, 2-31, 14-22

SET_DISABLED procedure, 14-24

UNREGISTER_PROPAGATOR procedure, 14-26

UNSCHEDULE_PURGE procedure, 14-27

UNSCHEDULE_PUSH procedure, 14-27

DBMS_MVIEW package

BEGIN_TABLE_REORGANIZATION procedure, 8-19, 15-3

END_TABLE_REORGANIZATION procedure, 8-19, 15-4

EXPLAIN_MVIEW procedure, 15-5

EXPLAIN_REWRITE procedure, 15-6

I_AM_A_REFRESH function, 15-7

PMARKER function, 15-8

PURGE_DIRECT_LOAD_LOG procedure, 15-8

PURGE_LOG procedure, 8-17, 15-9

PURGE_MVIEW_FROM_LOG procedure, 8-10, 8-13, 8-14, 8-17, 15-10

REFRESH procedure, 8-2, 8-32, 15-12

REFRESH_ALL_MVIEWS procedure, 15-15

REFRESH_DEPENDENT procedure, 15-16

REGISTER_MVIEW procedure, 15-18

UNREGISTER_MVIEW procedure, 8-13, 15-21

DBMS_OFFLINE_OG package

BEGIN_INSTANTIATION procedure, 7-33, 16-3

BEGIN_LOAD procedure, 7-35, 16-4

END_INSTANTIATION procedure, 7-36, 16-6

END_LOAD procedure, 7-36, 16-7

RESUME_SUBSET_OF_MASTERS procedure, 7-35, 16-9

DBMS_OFFLINE_SNAPSHOT package

BEGIN_LOAD procedure, 8-29, 17-3

END_LOAD procedure, 8-31, 17-5

DBMS_RECTIFIER_DIFF package, 9-9

DIFFERENCES procedure, 9-9, 18-3

RECTIFY procedure, 9-9, 18-6

DBMS_REFRESH package

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

CHANGE procedure, 19-4

DESTROY procedure, 19-6

MAKE procedure, 5-7, 5-15, 19-7

REFRESH procedure, 8-2, 19-10

SUBTRACT procedure, 19-10

DBMS_REPCAT package

ADD_DELETE_RESOLUTION procedure, 20-20

ADD_GROUPED_COLUMN procedure, 20-8

ADD_MASTER_DATABASE procedure, 3-11, 7-28, 7-30, 20-9

ADD_NEW_MASTERS procedure, 7-12, 7-22, 20-11

ADD_PRIORITY_CHAR procedure, 20-17

ADD_PRIORITY_datatype procedure, 20-17

ADD_PRIORITY_DATE procedure, 20-17

ADD_PRIORITY_NUMBER procedure, 20-17

ADD_PRIORITY_VARCHAR2 procedure, 20-17

ADD_SITE_PRIORITY_SITE procedure, 6-23, 20-19

ADD_UNIQUENESS_RESOLUTION procedure, 20-20

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

ALTER_CATCHUP_PARAMETERS procedure, 20-26

ALTER_MASTER_PROPAGATION procedure, 20-28

ALTER_MASTER_REPOBJECT procedure, 6-10, 6-21, 6-33, 9-2, 20-29

ALTER_MVIEW_PROPAGATION procedure, 20-32

ALTER_PRIORITY procedure, 20-34

ALTER_PRIORITY_CHAR procedure, 20-35

ALTER_PRIORITY_datatype procedure, 20-35

ALTER_PRIORITY_DATE procedure, 20-35

ALTER_PRIORITY_NUMBER procedure, 20-35

ALTER_PRIORITY_RAW procedure, 20-35

ALTER_SITE_PRIORITY procedure, 20-37

ALTER_SITE_PRIORITY_SITE procedure, 20-39

CANCEL_STATISTICS procedure, 6-42, 20-40

comment procedures, 7-40

COMMENT_ON_COLUMN_GROUP procedure, 7-40, 20-41

COMMENT_ON_DELETE_RESOLUTION procedure, 7-40, 20-48

COMMENT_ON_MVIEW_REPSITES procedure, 20-42

COMMENT_ON_PRIORITY_GROUP procedure, 7-40, 20-43

COMMENT_ON_REPGROUP procedure, 7-40, 20-44

COMMENT_ON_REPOBJECT procedure, 7-40, 20-45

COMMENT_ON_REPSITES procedure, 7-40, 20-46

COMMENT_ON_SITE_PRIORITY procedure, 20-43

COMMENT_ON_UNIQUE_RESOLUTION procedure, 7-40, 20-48

COMMENT_ON_UPDATE_RESOLUTION procedure, 7-40, 20-48

COMPARE_OLD_VALUES procedure, 20-50

CREATE_MASTER_REPGROUP procedure, 3-5, 20-52

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

CREATE_MVIEW_REPGROUP procedure, 5-7, 5-14, 8-28, 8-34, 8-35, 20-57

CREATE_MVIEW_REPOBJECT procedure, 5-8, 5-9, 5-10, 5-16, 5-17, 8-34, 8-37, 20-58

DEFINE_COLUMN_GROUP procedure, 20-61

DEFINE_PRIORITY_GROUP procedure, 20-62

DEFINE_SITE_PRIORITY procedure, 6-23, 20-64

DO_DEFERRED_REPCAT_ADMIN procedure, 6-35, 7-33, 20-65

DROP_COLUMN_GROUP procedure, 20-66

DROP_DELETE_RESOLUTION procedure, 20-78

DROP_GROUPED_COLUMN procedure, 20-67

DROP_MASTER_REPGROUP procedure, 20-68

DROP_MASTER_REPOBJECT procedure, 20-69

DROP_MVIEW_REPGROUP procedure, 8-4, 8-6, 8-8, 20-71

DROP_MVIEW_REPOBJECT procedure, 8-9, 20-72

DROP_PRIORITY procedure, 20-73

DROP_PRIORITY_CHAR procedure, 20-75

DROP_PRIORITY_datatype procedure, 20-75

DROP_PRIORITY_DATE procedure, 20-75

DROP_PRIORITY_GROUP procedure, 20-74

DROP_PRIORITY_NUMBER procedure, 20-75

DROP_PRIORITY_VARCHAR2 procedure, 20-75

DROP_SITE_PRIORITY procedure, 20-76

DROP_SITE_PRIORITY_SITE procedure, 20-77

DROP_UNIQUE_RESOLUTION procedure, 20-78

DROP_UPDATE_RESOLUTION procedure, 20-78

EXECUTE_DDL procedure, 20-80

GENERATE_MVIEW_SUPPORT procedure, 20-82

GENERATE_REPLICATION_SUPPORT procedure, 3-12, 3-13, 3-14, 9-4, 20-83

MAKE_COLUMN_GROUP procedure, 6-5, 6-7, 6-11, 6-14, 6-17, 6-22, 20-85

PREPARE_INSTANTIATED_MASTER procedure, 7-18, 7-27

PREPARE_INSTANTIATED_MASTERS procedure, 20-87

PURGE_MASTER_LOG procedure, 20-88

PURGE_STATISTICS procedure, 6-42, 20-89

REFRESH_MVIEW_REPGROUP procedure, 20-90

REGISTER_MVIEW_REPGROUP procedure, 20-92

REGISTER_STATISTICS procedure, 6-41, 20-94

RELOCATE_MASTERDEF procedure, 7-2, 20-95

REMOVE_MASTER_DATABASE procedure, 7-38

REMOVE_MASTER_DATABASES procedure, 20-97

RENAME_SHADOW_COLUMN_GROUP procedure, 20-98

REPCAT_IMPORT_CHECK procedure, 20-99

RESUME_MASTER_ACTIVITY procedure, 3-14, 20-100

RESUME_PROPAGATION_TO_MDEF procedure, 7-15, 7-25, 20-101

SEND_OLD_VALUES procedure, 20-102

SET_COLUMNS procedure, 20-52, 20-105

SPECIFY_NEW_MASTERS procedure, 7-12, 7-22, 20-107

SUSPEND_MASTER_ACTIVITY procedure, 20-109

SWITCH_MVIEW_MASTER procedure, 8-2, 20-110

UNDO_ADD_NEW_MASTERS_REQUEST procedure, 20-111

UNREGISTER_MVIEW_REPGROUP procedure, 8-10, 20-113

VALIDATE procedure, 20-114

WAIT_MASTER_LOG procedure, 20-117

DBMS_REPCAT_ADMIN package

GRANT_ADMIN_ANY_SCHEMA procedure, 2-5, 2-21, 2-27, 21-3

GRANT_ADMIN_SCHEMA procedure, 21-4

REGISTER_USER_REPGROUP procedure, 2-6, 2-8, 2-22, 2-25, 21-5

REVOKE_ADMIN_ANY_SCHEMA procedure, 21-7

REVOKE_ADMIN_SCHEMA procedure, 21-8

UNREGISTER_USER_REPGROUP procedure, 21-9

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

ALTER_USER_PARM_VALUE procedure, 23-14

COMPARE_TEMPLATES function, 23-16

COPY_TEMPLATE function, 23-18

CREATE_OBJECT_FROM_EXISTING function, 23-20

CREATE_REFRESH_TEMPLATE function, 23-22

CREATE_REFRESH_TEMPLATE procedure, 4-6

CREATE_TEMPLATE_OBJECT function, 23-24

CREATE_TEMPLATE_OBJECT procedure, 4-7

CREATE_TEMPLATE_PARM function, 23-27

CREATE_USER_AUTHORIZATION function, 23-30

CREATE_USER_AUTHORIZATION procedure, 4-12

CREATE_USER_PARM_VALUE function, 23-31

DELETE_RUNTIME_PARMS procedure, 23-33

DROP_ALL_OBJECTS procedure, 23-34

DROP_ALL_TEMPLATE_PARMS procedure, 23-36

DROP_ALL_TEMPLATE_SITES procedure, 23-37

DROP_ALL_TEMPLATES procedure, 23-38

DROP_ALL_USER_AUTHORIZATIONS procedure, 23-38

DROP_ALL_USER_PARM_VALUES procedure, 23-39

DROP_REFRESH_TEMPLATE procedure, 23-40

DROP_SITE_INSTANTIATION procedure, 23-41

DROP_TEMPLATE_OBJECT procedure, 23-42

DROP_TEMPLATE_PARM procedure, 23-44

DROP_USER_AUTHORIZATION procedure, 23-45

DROP_USER_PARM_VALUE procedure, 23-46

GET_RUNTIME_PARM_ID function, 23-47

INSERT_RUNTIME_PARMS procedure, 23-47

INSTANTIATE_OFFLINE function, 23-49

INSTANTIATE_OFFLINE procedure, 4-15

INSTANTIATE_ONLINE function, 23-52

INSTANTIATE_ONLINE procedure, 4-16

LOCK_TEMPLATE_EXCLUSIVE procedure, 23-55

LOCK_TEMPLATE_SHARED procedure, 23-55

DBMS_REPUTIL package

FROM_REMOTE function, 24-4

GLOBAL_NAME function, 24-5

MAKE_INTERNAL_PKG procedure, 24-5

REPLICATION_IS_ON function, 24-4

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

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

SYNC_UP_REP procedure, 24-6

DDL. See data definition language

DEFCALL view, 27-2

DEFCALLDEST view, 27-2

DEFDEFAULTDEST view, 27-3

adding destinations to, 14-4

removing destinations from, 14-6

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

deferred remote procedure calls (RPCs)

argument types, 13-5

argument values, 13-9

arguments to, 12-5

building, 12-3

executing immediately, 14-16

DEFSCHEDULE view

clearing statistics, 14-5

removing destinations from, 14-6

deleting from queue, 14-8

monitoring, 10-20

purge job, 10-23, 10-24

push jobs, 10-21, 10-22

reexecuting, 14-11

scheduling execution, 14-22

starting, 12-8

DEFERROR view, 9-18, 27-4

deleting transactions from, 14-7

DEFLOB view, 27-4

DEFPROPAGATOR view, 27-5

DEFSCHEDULE view, 27-5

clearing statistics, 10-33, 14-5

DEFTRAN view, 27-8

DEFTRANDEST view, 27-8

deployment templates

adding objects to, 4-6

alter object, 23-7

alter parameters, 23-10

alter template, 23-5

alter user authorization, 23-12

alter user parameter values, 23-14

authorize users, 4-12

compare templates, 23-16

concepts, 4-2

copy template, 23-18

create object from existing, 23-20

create template, 23-22

creating, 4-3, 4-5

data dictionary views for, 25-5

distributing files, 4-18

drop site instantiation, 22-3

dropping, 23-40

dropping all, 23-38

dropping materialized view group, 8-4

flowchart for creating, 4-4

instantiating, 4-19

instantiation script, 4-16

lock template, 23-55

monitoring, 10-10

objects

creating, 23-24

dropping, 23-42

dropping all, 23-34

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

online instantiation, 22-6, 23-52

packaging, 4-12, 4-14

for offline instantiation, 4-14

for online instantiation, 4-15

parameters

creating, 4-10, 23-27

dropping, 23-44

dropping all, 23-36

user values, 4-11

runtime parameters

creating, 23-47

deleting, 23-33

get ID, 23-47

inserting, 23-47

sites

dropping, 23-41

dropping all, 23-37

user authorizations

creating, 23-30

dropping, 23-45

dropping all, 23-38

user parameter values

creating, 23-31

dropping, 23-46

dropping all, 23-39

user-defined types, 4-2

differences

between tables, 18-3

rectifying, 18-6

disabling

propagation, 14-24

DROP MATERIALIZED VIEW LOG statement, 8-22

dynamic ownership

conflict avoidance and, 6-36

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

reexecuting as alternate user, 9-20

reexecuting as receiver, 9-19

reexecuting multiple, 9-19

extended availability, 6-3, 7-4, 9-2, 20-11, 20-31, 20-87, 20-101, 20-107, 20-111

F

foreign key constraints

adding master sites, 7-4

G

generating

replication support, 3-12

procedural replication, 7-45

I

Import

materialized views

offline instantiation and, 17-3, 17-5

replication groups

offline instantiation and, 16-4, 16-7

status check, 20-99

initialization parameters

replication

monitoring, 10-29

instantiation, 4-19

DROP_SITE_INSTANTIATION procedure, 22-3, 23-41

offline, 4-12

INSTANTIATE_OFFLINE function, 22-3, 23-49

online

INSTANTIATE_ONLINE function, 22-6, 23-52

refreshing after, 4-21

script, 4-16

J

jobs

queues for

removing jobs from, 14-27

L

LONG columns

replication, 9-7

M

master definition site

relocating, 20-95

master groups

adding master sites to

with quiesce, 7-28

without quiesce, 7-4

adding objects to, 3-6

creating, 3-2, 3-5, 20-52

dropping, 20-68

flowchart for creating, 3-4

monitoring, 10-3

quiescing, 20-109

removing master sites from, 7-37

resuming replication activity, 20-100

master materialized views

monitoring, 10-6

reorganizing, 8-19

master sites

adding, 3-10, 7-4

circular dependencies, 3-10, 7-4

flowchart for, 7-10, 7-20

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-10, 7-4

using change-based recovery, 7-9

using full database export/import, 7-9

using object-level export/import, 7-19

using offline instantiation, 7-31

with quiesce, 7-28

without quiesce, 7-4

changing master definition site, 7-2

cleaning up, 8-10

creating, 20-9

creating users for, 2-7, 2-25

database links, 2-15

determining differences, 9-9

dropping, 20-97

flowchart for setting up, 2-3

monitoring, 10-2, 10-6

propagating changes between, 14-22

removing, 7-37

scheduled links for, 2-16

scheduled purges for, 2-6

setup, 2-4

master tables

adding columns to, 20-98

redefining online, 8-19

reorganizing, 8-19

methods, 8-20

truncating, 8-19

materialized view groups

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

changing masters, 8-2

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

dropping, 8-4, 8-8

group owner, 8-34

monitoring, 10-12

refreshing, 20-90

unregistering from master, 8-10

materialized view logs

adding columns, 8-15

altering, 8-15

privileges required, 8-15

dropping, 8-22

managing, 8-15

space, 8-16

master table

purging, 15-8, 15-9, 15-10

monitoring, 10-7

purging

materialized views from, 8-10, 8-13

privileges required, 8-17

purging rows from

manually, 8-17

reducing space allocated to, 8-17

reorganizing masters with, 8-19

truncating, 8-17

truncating master table with, 8-19

materialized view sites

adding

using offline instantiation, 8-23

administrators

creating, 2-20

changing masters, 20-110

database links

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

dropping, 8-3, 20-71

dropping objects from, 8-8

flowchart for setting up, 2-19

group owner

using, 8-34

monitoring, 10-11

multitier

setting up, 2-19

propagating changes to master, 14-22

refresher

creating, 2-20, 2-27

schedule purge, 2-24, 2-30

users

creating, 2-20

materialized views

data dictionary views, 28-1

deployment templates

user-defined types, 4-2

dropping, 8-9

generating support for, 20-82

monitoring, 10-11, 10-13

multitier

setting up, 5-4

user-defined conflict resolution, B-4

offline instantiation of, 17-3, 17-5

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

refresh groups

creating, 5-7, 5-14

refreshing, 4-21, 8-2, 8-32, 15-12, 15-15, 15-16

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

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

altering, 20-29

altering replication, 9-2

creating

for master group, 20-52, 20-53

for materialized view sites, 20-58

dropping

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

generating replication support for, 20-83

offline instantiation

adding a master site, 7-31

adding a materialized view site, 8-23

INSTANTIATE_OFFLINE function, 22-3, 23-49

materialized views, 17-3, 17-5

replication groups, 16-3, 16-4, 16-6, 16-7, 16-9

online instantiation

INSTANTIATE_ONLINE function, 22-6, 23-52

online redefinition of tables, 8-19

Oracle Replication Management tool

monitoring replication, 10-1

P

packaging

deployment templates, 4-12

parallel propagation

monitoring, 10-32, 10-33

parameters

deployment templates, 4-10

user values, 4-11

performance

replication

monitoring, 10-30

planning

for replication, 1-4

PRESERVE MATERIALIZED VIEW LOG option

TRUNCATE TABLE statement, 8-20

priority groups

adding members to, 20-17

altering members

priorities, 20-34

values, 20-35

creating, 20-62

dropping, 20-74

removing members from, 20-73, 20-75

site priority groups

adding members to, 20-19

procedural replication

conflicts and, 7-45

generating replication support for, 7-45

restrictions, 7-42

serialization of transactions, 7-45

user-defined types, 7-44

using, 7-42

propagation

altering method, 20-28, 20-32

disabling, 14-24

of changes, 20-28

parallel

monitoring, 10-32, 10-33

status of, 14-9

propagator

registering, 2-6, 14-19

proxy materialized view administrator

creating, 2-7, 2-25

purges

DBA_REPCATLOG table, 20-88

deferred transaction queue, 9-15

master sites, 2-6

materialized view sites, 2-24, 2-30

monitoring, 10-23

pushes

deferred transaction queue, 9-14

Q

quiescing

adding master sites with, 7-28

adding master sites without, 7-4

altering replicated objects without, 9-2

configuring conflict resolution methods without, 6-3

master groups, 20-109

R

receiver

registering, 2-6

rectifying

tables, 9-9, 18-6

redefining tables

online

replication, 8-19

refresh

materialized view sites, 20-90

materialized views, 8-2, 8-32, 15-12, 15-15, 15-16

monitoring, 10-16, 10-17

refresh groups

adding members to, 19-3

adding objects to, 5-10, 5-18

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

data dictionary views, 28-1

deleting, 19-6

monitoring, 10-15

refresh, 8-2

refresh interval

changing, 19-4

refreshing

manually, 19-10

removing members from, 19-10

refresher

creating, 2-20, 2-27

replication

catalog views, 10-1, 25-1

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

conflict resolution, 6-1

uniqueness, 6-25

creating administrators, 2-4

creating an environment, 1-2

data dictionary views, 10-1, 25-1

database links

creating, 2-15

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-45, 9-5, 24-3

dynamic performance views, 26-1

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

error queues

managing, 9-18

flowchart for creating environment, 1-2

generating support for, 3-12

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

materialized view groups

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

materialized view logs

managing, 8-15

monitoring, 10-1

deferred transactions, 10-20

error transactions, 10-26

initialization parameters, 10-29

master environments, 10-2

materialized view environments, 10-11

performance, 10-30

objects

adding to deployment template, 4-6

adding to master group, 3-6

altering, 6-10, 9-2

dropping from master sites, 20-69

parallel propagation

monitoring, 10-32, 10-33

planning for, 1-4

procedural replication, 7-42

restrictions, 7-42

user-defined types, 7-44

propagator

registering, 2-6

receiver

registering, 2-6

replicated objects, 9-1

replication queues, 9-1

resuming, 3-14

scheduled links

creating, 2-16

security, A-1

setting up sites, 2-2

sites

setup, 2-2

statistics

clearing, 10-33

triggers, 9-7

replication catalog views, 25-1

comments

updating, 7-40

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, 37, 38, 11-1

setting up replication sites, 2-2

replication objects

altering, 9-2

tables

altering, 9-5

resuming replication activity, 20-100

S

scheduled links

creating, 2-16

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

site priority

altering, 20-37

site priority groups

adding members to, 20-19

creating

syntax, 20-64

dropping, 20-76

removing members from, 20-77

snapshots. See materialized views

statistics

for conflict resolution

auditing, 6-41

cancelling, 6-42

clearing, 6-42, 20-89

collecting, 6-41, 20-94

viewing, 6-41

for propagation

clearing, 10-33, 14-5

status

propagation, 14-9

storage parameters

materialized view log

altering, 8-15

SYS.ANYDATA, 13-9

T

tables

altering

without replicating changes, 9-5

altering replicated, 9-2

comparing, 18-3

differences between, 9-9

rectifying, 9-9, 18-6

redefining online

replication, 8-19

updating comments, 7-40

templates. See deployment templates

token passing, 6-37

sample implementation, 6-36

transactions

serialization of, 7-45

triggers

for site priority conflict resolution, 6-22

for timestamp conflict resolution, 6-11

replicating, 9-7

TRUNCATE statement, 8-18

TRUNCATE TABLE statement

PRESERVE MATERIALIZED VIEW LOG option, 8-20

trusted security, A-3, A-8

U

USER_BASE_TABLE_MVIEWS view, 28-14

USER_MVIEW_LOGS view, 28-14

USER_MVIEW_REFRESH_TIMES view, 28-14

USER_MVIEWS view, 28-5, 28-14

USER_REFRESH view, 28-15

USER_REFRESH_CHILDREN view, 28-15

USER_REGISTERED_MVIEWS view, 28-15

USER_REPCAT_REFRESH_TEMPLATES view, 25-49

USER_REPCAT_TEMP_OUTPUT view, 4-14

USER_REPCAT_TEMPLATE_OBJECTS view, 25-50

USER_REPCAT_TEMPLATE_PARMS view, 25-50

USER_REPCAT_TEMPLATE_SITES view, 25-50

USER_REPCAT_USER_AUTHORIZATIONS view, 25-50

USER_REPCAT_USER_PARM_VALUES view, 25-51

USER_REPCATLOG view, 25-51

USER_REPCOLUMN view, 25-51

USER_REPCOLUMN_GROUP view, 25-51

USER_REPCONFLICT view, 25-52

USER_REPDDL view, 25-52

USER_REPGENOBJECTS view, 25-52

USER_REPGROUP view, 25-52

USER_REPGROUP_PRIVILEGES view, 25-53

USER_REPGROUPED_COLUMN view, 25-53

USER_REPKEY_COLUMNS view, 25-53

USER_REPOBJECT view, 25-53

USER_REPPARAMETER_COLUMN view, 25-53

USER_REPPRIORITY view, 25-54

USER_REPPRIORITY_GROUP view, 25-54

USER_REPPROP view, 25-54

USER_REPRESOL_STATS_CONTROL view, 25-55

USER_REPRESOLUTION view, 25-55

USER_REPRESOLUTION_METHOD view, 25-55

USER_REPRESOLUTION_STATISTICS view, 25-56

USER_REPSITES view, 25-56

users

authorize for deployment template, 4-12

master materialized view sites, 2-25

master sites, 2-7

materialized view sites, 2-20

V

V$MVREFRESH view, 26-2

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

V$REPLQUEUE view, 26-4

W

workflow, 6-36