Index

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

A

ADD procedure, 5-18, 8-37, 17-3

ADD_DEFAULT_DEST procedure, 14-4

ADD_DELETE_RESOLUTION procedure, 18-19

ADD_GROUPED_COLUMN procedure, 18-8

ADD_MASTER_DATABASE procedure, 3-11, 7-34, 7-36, 18-9

ADD_NEW_MASTERS procedure, 7-13, 7-28, 18-11

ADD_PRIORITY_CHAR procedure, 18-17

ADD_PRIORITY_datatype procedure, 18-17

ADD_PRIORITY_DATE procedure, 18-17

ADD_PRIORITY_NUMBER procedure, 18-17

ADD_PRIORITY_VARCHAR2 procedure, 18-17

ADD_SITE_PRIORITY_SITE procedure, 6-25, 18-18

ADD_UNIQUENESS_RESOLUTION procedure, 18-19

ADD_UPDATE_RESOLUTION procedure, 6-5, 6-8, 6-13, 6-16, 6-20, 6-26, 18-19

administrative requests

ALL_REPCATLOG view, 23-14

executing, 7-39, 18-62

monitoring, 10-17

errors, 10-18

jobs, 10-19

purging, 18-87

administrators

for materialized view sites

creating, 2-21

Advanced Replication

migrating to Streams, 18-106

ALL_REPCAT_REFRESH_TEMPLATES view, 23-5

ALL_REPCAT_TEMPLATE_OBJECTS view, 23-6

ALL_REPCAT_TEMPLATE_PARMS view, 23-8

ALL_REPCAT_TEMPLATE_SITES view, 23-10

ALL_REPCAT_USER_AUTHORIZATIONS view, 23-11

ALL_REPCAT_USER_PARM_VALUES view, 23-12

ALL_REPCATLOG view

administrative requests, 23-14

ALL_REPCOLUMN view, 23-16

ALL_REPCOLUMN_GROUP view, 23-18

ALL_REPCONFLICT view, 23-18

ALL_REPDDL view, 23-19

ALL_REPGENOBJECTS view, 23-20

ALL_REPGROUP view, 23-21

ALL_REPGROUP_PRIVILEGES view, 23-22

ALL_REPGROUPED_COLUMN view, 23-23

ALL_REPKEY_COLUMNS view, 23-24

ALL_REPOBJECT view, 23-25

ALL_REPPARAMETER_COLUMN view, 23-26

ALL_REPPRIORITY view, 23-27

ALL_REPPRIORITY_GROUP view, 23-29

ALL_REPPROP view, 23-29

ALL_REPRESOL_STATS_CONTROL view, 23-30

ALL_REPRESOLUTION view, 23-31

ALL_REPRESOLUTION_METHOD view, 23-32

ALL_REPRESOLUTION_STATISTICS view, 23-33

gathering statistics, 6-44

ALL_REPSITES view, 23-34

ALTER MATERIALIZED VIEW LOG statement, 8-17

ALTER_CATCHUP_PARAMETERS procedure, 18-24

ALTER_MASTER_PROPAGATION procedure, 18-26

ALTER_MASTER_REPOBJECT procedure, 6-11, 6-23, 6-35, 9-2, 18-28

ALTER_MVIEW_PROPAGATION procedure, 18-31

ALTER_PRIORITY procedure, 18-33

ALTER_PRIORITY_CHAR procedure, 18-34

ALTER_PRIORITY_datatype procedure, 18-34

ALTER_PRIORITY_DATE procedure, 18-34

ALTER_PRIORITY_NUMBER procedure, 18-34

ALTER_PRIORITY_RAW procedure, 18-34

ALTER_REFRESH_TEMPLATE procedure, 21-5

ALTER_SITE_PRIORITY procedure, 18-35

ALTER_SITE_PRIORITY_SITE procedure, 18-37

ALTER_TEMPLATE_OBJECT procedure, 21-7

ALTER_TEMPLATE_PARM procedure, 21-10

ALTER_USER_AUTHORIZATION procedure, 21-11

ALTER_USER_PARM_VALUE procedure, 21-13

ANY_CHAR_ARG procedure, 12-5

ANY_CLOB_ARG procedure, 12-5

ANY_VARCHAR2_ARG procedure, 12-5

AnyData datatype

replication, 9-16

ANYDATA_ARG procedure, 12-5

authorization

template users, 4-12

availability

extended, 6-3, 7-4, 9-2, 18-11, 18-30, 18-85, 18-98, 18-104, 18-109

B

BEGIN_INSTANTIATION procedure, 7-40, 15-3

BEGIN_LOAD procedure, 7-43, 15-4

BEGIN_TABLE_REORGANIZATION, 8-21

BLOB_ARG procedure, 12-5

C

CALL procedure, 12-3

CANCEL_STATISTICS procedure, 6-45, 18-38

CHANGE procedure, 17-4

CHAR_ARG procedure, 12-5

CLEAR_PROP_STATISTICS procedure, 10-33, 14-4

CLOB_ARG procedure, 12-5

column objects

user-defined conflict resolution, B-3

column subsetting

user-defined conflict resolution methods, B-5

columns

adding to master tables, 18-95

column groups, 6-5, 6-8, 6-12, 6-15, 6-18, 6-24

adding members to, 18-8

creating, 18-59, 18-83

dropping, 18-63

removing members from, 18-64

COMMENT_ON_COLUMN_GROUP procedure, 7-48, 18-38

COMMENT_ON_DELETE_RESOLUTION procedure, 7-48, 18-46

COMMENT_ON_MVIEW_REPSITES procedure, 18-39

COMMENT_ON_PRIORITY procedure, 18-40

COMMENT_ON_PRIORITY_GROUP procedure, 7-48

COMMENT_ON_REPGROUP procedure, 7-48, 18-41

COMMENT_ON_REPOBJECT procedure, 7-48, 18-42

COMMENT_ON_REPSITES procedure, 7-48, 18-43

COMMENT_ON_SITE_PRIORITY procedure, 18-45

COMMENT_ON_UNIQUE_RESOLUTION procedure, 7-48, 18-46

COMMENT_ON_UPDATE_RESOLUTION procedure, 7-48, 18-46

comments

comments field

updating in views, 7-48

updating, 7-48

COMMIT_WORK procedure, 12-4

COMPARE_OLD_VALUES procedure, 18-48

COMPARE_TEMPLATES function, 21-15

comparing

tables, 16-3

conflict resolution, 6-1

additive method, 6-14, 18-19

auditing, 6-44

average method, 6-14

column groups, 6-5, 6-8, 6-12, 6-15, 6-18, 6-24

configuring without quiesce, 6-3

DBA_REPRESOLUTION_STATISTICS view, 6-45

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

procedural replication and, 7-53

site priority method, 6-21

sample trigger, 6-24

statistics, 18-38, 18-91

canceling, 6-45

collecting, 6-44

viewing, 6-44

timestamp method, 6-9

sample trigger, 6-12

uniqueness, 6-27

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

dynamic ownership, 6-38

notification log table

creating, B-8

sample, B-9

notification methods

user-defined, B-8

notification package

creating, B-9

sample, B-9

token passing, 6-39

workflow, 6-38

COPY_TEMPLATE function, 21-17

CREATE_MASTER_REPGROUP procedure, 3-6, 18-50

CREATE_MASTER_REPOBJECT procedure, 6-12, 6-24, 18-51

CREATE_MVIEW_REPGROUP procedure, 5-7, 8-33, 8-39, 8-42, 18-55

CREATE_MVIEW_REPOBJECT procedure, 5-9, 5-10, 5-16, 5-17, 8-39, 8-44, 18-56

CREATE_OBJECT_FROM_EXISTING function, 21-19

CREATE_REFRESH_TEMPLATE function, 21-21

CREATE_REFRESH_TEMPLATE procedure, 4-6

CREATE_TEMPLATE_OBJECT function, 21-23

CREATE_TEMPLATE_OBJECT procedure, 4-7

CREATE_TEMPLATE_PARM function, 21-26

CREATE_USER_AUTHORIZATION function, 21-28

CREATE_USER_AUTHORIZATION procedure, 4-12

CREATE_USER_PARM_VALUE function, 21-29

D

data definition language

altering replicated objects, 18-28

asynchronous, 18-78

data dictionary views

comments

updating, 7-48

materialized views, 26-1

refresh groups, 26-1

replication, 10-1, 23-1

database links

creating, 2-16, 2-29, 4-20, 5-6, 5-13, 8-41

datatype_ARG procedure, 12-5

date expressions, 2-6

DATE_ARG procedure, 12-5

DBA_REGISTERED_MVIEW_GROUPS view, 23-5

DBA_REPCAT_REFRESH_TEMPLATES view, 23-35

DBA_REPCAT_TEMPLATE_OBJECTS view, 23-35

DBA_REPCAT_TEMPLATE_PARMS view, 23-35

DBA_REPCAT_TEMPLATE_SITES view, 23-36

DBA_REPCAT_USER_AUTHORIZATIONS view, 23-36

DBA_REPCAT_USER_PARM_VALUES view, 23-36

DBA_REPCATLOG view, 23-36

purging requests from, 18-87

DBA_REPCOLUMN view, 23-37

DBA_REPCOLUMN_GROUP view, 23-37

updating, 7-48, 18-38

DBA_REPCONFLICT view, 23-37

DBA_REPDDL view, 23-37

DBA_REPEXTENSIONS view, 23-37

DBA_REPGENOBJECTS view, 23-40

DBA_REPGROUP view, 23-40

updating, 7-48, 18-41

DBA_REPGROUP_PRIVILEGES view, 23-40

DBA_REPGROUPED_COLUMN view, 23-40

DBA_REPKEY_COLUMNS view, 23-40

DBA_REPOBJECT view, 23-41

updating, 7-48, 18-42

DBA_REPPARAMETER_COLUMN view, 23-41

DBA_REPPRIORITY view, 23-41

DBA_REPPRIORITY_GROUP view, 23-41

updating, 7-48

DBA_REPPRIORITYGROUP view

updating, 18-40, 18-45

DBA_REPPROP view, 23-41

DBA_REPRESOL_STATS_CONTROL view, 23-42

DBA_REPRESOLUTION view, 23-42

updating, 7-48, 18-46

DBA_REPRESOLUTION_METHOD view, 23-42

DBA_REPRESOLUTION_STATISTICS view, 23-42

purging, 6-45, 18-88

DBA_REPSITES view, 23-43

updating, 7-48, 18-43

DBA_REPSITES_NEW view, 23-43

DBMS_DEFER package, 12-1

DBMS_DEFER_QUERY package, 13-1

GET_AnyData_ARG function, 9-16

DBMS_DEFER_SYS package, 14-1

CLEAR_PROP_STATISTICS procedure, 10-33

EXECUTE_ERROR procedure, 7-39, 9-19

EXECUTE_ERROR_AS_USER procedure, 9-20

PURGE function, 9-15

PUSH function, 9-14

REGISTER_PROPAGATOR procedure, 2-5, 2-22, 2-28

SCHEDULE_PURGE procedure, 2-7, 2-25, 2-30

SCHEDULE_PUSH procedure, 2-17, 2-25, 2-31

DBMS_MVIEW package

BEGIN_TABLE_REORGANIZATION procedure, 8-21

END_TABLE_REORGANIZATION procedure, 8-21

PURGE_LOG procedure, 8-19

PURGE_MVIEW_FROM_LOG procedure, 8-11, 8-15, 8-16, 8-19

REFRESH procedure, 8-2, 8-38

UNREGISTER_MVIEW procedure, 8-15

DBMS_OFFLINE_OG package, 15-1

BEGIN_INSTANTIATION procedure, 7-40

BEGIN_LOAD procedure, 7-43

END_INSTANTIATION procedure, 7-44

END_LOAD procedure, 7-43

RESUME_SUBSET_OF_MASTERS procedure, 7-42

DBMS_OFFLINE_SNAPSHOT package

END_LOAD procedure, 8-35, 8-36

DBMS_RECTIFIER_DIFF package, 9-9, 16-1

DIFFERENCES procedure, 9-9

RECTIFY procedure, 9-10

DBMS_REFRESH package, 17-1

ADD procedure, 5-18, 8-37

MAKE procedure, 5-7, 5-15, 8-33

REFRESH procedure, 8-2

DBMS_REPCAT package, 18-1

ADD_MASTER_DATABASE procedure, 3-11, 7-34, 7-36

ADD_NEW_MASTERS procedure, 7-13, 7-28

ADD_SITE_PRIORITY_SITE procedure, 6-25

ADD_UPDATE_RESOLUTION procedure, 6-5, 6-8, 6-13, 6-16, 6-20, 6-26

ALTER_MASTER_REPOBJECT procedure, 6-11, 6-23, 6-35, 9-2

CANCEL_STATISTICS procedure, 6-45

comment procedures, 7-48

COMMENT_ON_COLUMN_GROUP procedure, 7-48

COMMENT_ON_DELETE_RESOLUTION procedure, 7-48

COMMENT_ON_PRIORITY_GROUP procedure, 7-48

COMMENT_ON_REPGROUP procedure, 7-48

COMMENT_ON_REPOBJECT procedure, 7-48

COMMENT_ON_REPSITES procedure, 7-48

COMMENT_ON_UNIQUE_RESOLUTION procedure, 7-48

COMMENT_ON_UPDATE_RESOLUTION procedure, 7-48

CREATE_MASTER_REPGROUP procedure, 3-6

CREATE_MASTER_REPOBJECT procedure, 6-12, 6-24

CREATE_MVIEW_REPGROUP procedure, 5-7, 8-33, 8-39, 8-42

CREATE_MVIEW_REPOBJECT procedure, 5-9, 5-10, 5-16, 5-17, 8-39, 8-44

DEFINE_SITE_PRIORITY procedure, 6-25

DO_DEFERRED_REPCAT_ADMIN procedure, 6-37, 7-40

DROP_MVIEW_REPGROUP procedure, 8-4, 8-7, 8-9

DROP_MVIEW_REPOBJECT procedure, 8-10

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

MAKE_COLUMN_GROUP procedure, 6-5, 6-8, 6-12, 6-15, 6-18, 6-24

PREPARE_INSTANTIATED_MASTER procedure, 7-20, 7-32

PURGE_STATISTICS procedure, 6-45

REGISTER_STATISTICS procedure, 6-44

RELOCATE_MASTERDEF procedure, 7-2

REMOVE_MASTER_DATABASE procedure, 7-45

RESUME_MASTER_ACTIVITY procedure, 3-15

RESUME_PROPAGATION_TO_MDEF procedure, 7-17, 7-31

SPECIFY_NEW_MASTERS procedure, 7-12, 7-27

SWITCH_MVIEW_MASTER procedure, 8-3

UNREGISTER_MVIEW_REPGROUP procedure, 8-11

DBMS_REPCAT_ADMIN package, 19-1

GRANT_ADMIN_ANY_SCHEMA procedure, 2-5, 2-22, 2-28

REGISTER_USER_REPGROUP procedure, 2-6, 2-7, 2-11, 2-15, 2-23, 2-26

DBMS_REPCAT_INSTANTIATE package, 20-1

DROP_SITE_INSTANTIATION procedure, 8-4, 8-7

DBMS_REPCAT_RGT package, 21-1

CREATE_REFRESH_TEMPLATE procedure, 4-6

CREATE_TEMPLATE_OBJECT procedure, 4-7

CREATE_USER_AUTHORIZATION procedure, 4-12

INSTANTIATE_OFFLINE procedure, 4-15

INSTANTIATE_ONLINE procedure, 4-16

DBMS_REPUTIL package, 22-1

REPLICATION_OFF procedure, 7-54, 9-6

REPLICATION_ON procedure, 7-54, 9-7

DDL. See data definition language

DEFCALL view, 25-2

DEFCALLDEST view, 25-2

DEFDEFAULTDEST view, 25-3

adding destinations to, 14-4

removing destinations from, 14-5, 14-6

DEFERRCOUNT view, 25-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, 25-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-8

arguments to, 12-5

building, 12-3

executing immediately, 14-14

DEFSCHEDULE view

clearing statistics, 14-4

removing destinations from, 14-6

deleting from queue, 14-7

monitoring, 10-21

purge job, 10-24, 10-25

push jobs, 10-22, 10-23

reexecuting, 14-10

scheduling execution, 14-20

starting, 12-8

DEFERROR view, 9-18, 25-3

deleting transactions from, 14-6

DEFINE_COLUMN_GROUP procedure, 18-59

DEFINE_PRIORITY_GROUP procedure, 18-60

DEFINE_SITE_PRIORITY procedure, 6-25, 18-61

DEFLOB view, 25-4

DEFPROPAGATOR view, 25-4

DEFSCHEDULE view, 25-4

clearing statistics, 10-33, 14-4

DEFTRAN view, 25-7

DEFTRANDEST view, 25-8

DELETE_DEF_DESTINATION procedure, 14-6

DELETE_DEFAULT_DEST procedure, 14-5

DELETE_ERROR procedure, 14-6

DELETE_RUNTIME_PARMS procedure, 21-31

DELETE_TRAN procedure, 14-7

deployment templates

alter object, 21-7

alter parameters, 21-10

alter template, 21-5

alter user authorization, 21-11

alter user parameter values, 21-13

authorize users, 4-12

compare templates, 21-15

concepts, 4-2

copy template, 21-17

create object from existing, 21-19

create template, 21-21

creating, 4-3, 4-5

data dictionary views for, 23-5

distributing files, 4-18

drop site instantiation, 20-3

dropping, 21-37

dropping all, 21-35

dropping materialized view group, 8-4

flowchart for creating, 4-4

instantiating, 4-19

instantiation script, 4-16

lock template, 21-51

monitoring, 10-9

objects

creating, 21-23

dropping, 21-39

dropping all, 21-32

offline instantiation, 4-12, 20-3, 21-46

online instantiation, 20-6, 21-48

packaging, 4-12, 4-14

for offline instantiation, 4-14

for online instantiation, 4-15

parameters

creating, 4-10, 21-26

dropping, 21-40

dropping all, 21-33

user values, 4-11

runtime parameters

creating, 21-44

deleting, 21-31

get ID, 21-43

inserting, 21-44

sites

dropping, 21-38

dropping all, 21-34

user authorizations

creating, 21-28

dropping, 21-41

dropping all, 21-35

user parameter values

creating, 21-29

dropping, 21-42

dropping all, 21-36

user-defined types, 4-2

DESTROY procedure, 17-6

differences

between tables, 16-3

rectifying, 16-6

DIFFERENCES procedure, 9-9, 16-3

DISABLED function, 14-8

disabling

propagation, 14-22

DO_DEFERRED_REPCAT_ADMIN procedure, 6-37, 7-40, 18-62

DROP MATERIALIZED VIEW LOG statement, 8-25

DROP_ALL_OBJECTS procedure, 21-32

DROP_ALL_TEMPLATE_PARMS procedure, 21-33

DROP_ALL_TEMPLATE_SITES procedure, 21-34

DROP_ALL_TEMPLATES procedure, 21-35

DROP_ALL_USER_AUTHORIZATIONS procedure, 21-35

DROP_ALL_USER_PARM_VALUES procedure, 21-36

DROP_COLUMN_GROUP procedure, 18-63

DROP_DELETE_RESOLUTION procedure, 18-76

DROP_GROUPED_COLUMN procedure, 18-64

DROP_MASTER_REPGROUP procedure, 18-66

DROP_MASTER_REPOBJECT procedure, 18-67

DROP_MVIEW_REPGROUP procedure, 8-4, 8-7, 18-69

DROP_MVIEW_REPOBJECT procedure, 8-10, 18-70

DROP_PRIORITY procedure, 18-71

DROP_PRIORITY_CHAR procedure, 18-73

DROP_PRIORITY_datatype procedure, 18-73

DROP_PRIORITY_DATE procedure, 18-73

DROP_PRIORITY_GROUP procedure, 18-72

DROP_PRIORITY_NUMBER procedure, 18-73

DROP_PRIORITY_VARCHAR2 procedure, 18-73

DROP_REFRESH_TEMPLATE procedure, 21-37

DROP_SITE_INSTANTIATION procedure, 8-4, 8-7, 20-3, 21-38

DROP_SITE_PRIORITY procedure, 18-74

DROP_SITE_PRIORITY_SITE procedure, 18-75

DROP_TEMPLATE_OBJECT procedure, 21-39

DROP_TEMPLATE_PARM procedure, 21-40

DROP_UNIQUE_RESOLUTION procedure, 18-76

DROP_UPDATE_RESOLUTION procedure, 18-76

DROP_USER_AUTHORIZATION procedure, 21-41

DROP_USER_PARM_VALUE procedure, 21-42

dynamic ownership

conflict avoidance and, 6-38

locating owner of a row, 6-42

obtaining ownership, 6-42

workflow partitioning, 6-38

dynamic performance views

replication, 24-1

E

END_INSTANTIATION procedure, 7-44, 15-5

END_LOAD procedure, 7-43, 8-35, 8-36, 15-7

END_TABLE_REORGANIZATION procedure, 8-21

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

EXCLUDE_PUSH function, 14-9

EXECUTE_DDL procedure, 18-78

EXECUTE_ERROR procedure, 7-39, 9-19, 14-10

EXECUTE_ERROR_AS_USER procedure, 9-20, 14-11

extended availability, 6-3, 7-4, 9-2, 18-11, 18-30, 18-85, 18-98, 18-104, 18-109

F

foreign key constraints

adding master sites, 7-4

FROM_REMOTE function, 22-4

G

GENERATE_MVIEW_SUPPORT procedure, 18-80

GENERATE_REPLICATION_SUPPORT procedure, 3-13, 3-14, 9-4, 18-81

generating

replication support, 3-12

procedural replication, 7-54

GET_AnyData_ARG function, 9-16, 13-8

GET_ARG_FORM function, 13-3

GET_ARG_TYPE function, 13-4

GET_BLOB_ARG function, 13-8

GET_CALL_ARGS procedure, 13-6

GET_CHAR_ARG function, 13-8

GET_CLOB_ARG function, 13-8

GET_datatype_ARG function, 13-8

GET_DATE_ARG function, 13-8

GET_IDS_ARG function, 13-8

GET_IYM_ARG function, 13-8

GET_NCHAR_ARG function, 13-8

GET_NCLOB_ARG function, 13-8

GET_NUMBER_ARG function, 13-8

GET_NVARCHAR2_ARG function, 13-8

GET_OBJECT_NULL_VECTOR_ARG function, 13-11

GET_RAW_ARG function, 13-8

GET_ROWID_ARG function, 13-8

GET_RUNTIME_PARM_ID function, 21-43

GET_TIMESTAMP_ARG function, 13-8

GET_TSLTZ_ARG function, 13-8

GET_TSTZ_ARG function, 13-8

GET_VARCHAR2_ARG function, 13-8

GLOBAL_NAME function, 22-4

GRANT_ADMIN_ANY_SCHEMA procedure, 2-5, 2-22, 2-28, 19-3

GRANT_ADMIN_SCHEMA procedure, 19-3

I

IDS_ARG procedure, 12-5

Import

replication groups

offline instantiation and, 15-4, 15-7

status check, 18-96

INSERT_RUNTIME_PARMS procedure, 21-44

INSTANTIATE_OFFLINE function, 20-3, 21-46

INSTANTIATE_OFFLINE procedure, 4-15

INSTANTIATE_ONLINE function, 20-6, 21-48

INSTANTIATE_ONLINE procedure, 4-16

instantiation, 4-19

DROP_SITE_INSTANTIATION procedure, 20-3, 21-38

offline, 4-12

INSTANTIATE_OFFLINE function, 20-3, 21-46

online

INSTANTIATE_ONLINE function, 20-6, 21-48

refreshing after, 4-21

script, 4-16

IYM_ARG procedure, 12-5

J

jobs

queues for

removing jobs from, 14-25

L

LOCK_TEMPLATE_EXCLUSIVE procedure, 21-51

LOCK_TEMPLATE_SHARED procedure, 21-51

LONG columns

replication, 9-7

M

MAKE procedure, 5-7, 5-15, 8-33, 17-6

MAKE_COLUMN_GROUP procedure, 6-5, 6-8, 6-12, 6-15, 6-24, 18-83

MAKE_INTERNAL_PKG procedure, 22-5

master definition site

relocating, 18-92

master groups

adding master sites to

with quiesce, 7-34

without quiesce, 7-4

adding objects to, 3-6

creating, 3-2, 3-6, 18-50

dropping, 18-66

flowchart for creating, 3-4

monitoring, 10-3

quiescing, 18-106

removing master sites from, 7-44

resuming replication activity, 18-97

master materialized views

monitoring, 10-6

reorganizing, 8-21

master sites

adding, 3-10, 7-4

circular dependencies, 3-10, 7-4

flowchart for, 7-22

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

using offline instantiation, 7-37

with quiesce, 7-34

without quiesce, 7-4

changing master definition site, 7-2

cleaning up, 8-11

creating, 18-9

creating users for, 2-7, 2-11, 2-14, 2-25

database links, 2-16

determining differences, 9-9

dropping, 18-94

flowchart for setting up, 2-3

monitoring, 10-2, 10-6

propagating changes between, 14-20

removing, 7-44

scheduled links for, 2-17

scheduled purges for, 2-6

setup, 2-4

master tables

adding columns to, 18-95

redefining online, 8-21

reorganizing, 8-21

methods, 8-22

truncating, 8-21

materialized view groups

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

changing masters, 8-3

creating, 5-4, 5-6, 5-14, 18-55

dropping, 8-4, 8-9

group owner, 8-39

monitoring, 10-12

refreshing, 18-88

unregistering from master, 8-11

materialized view logs

adding columns, 8-17

altering, 8-17

privileges required, 8-17

dropping, 8-25

managing, 8-17

space, 8-18

monitoring, 10-7

purging

materialized views from, 8-11, 8-15

privileges required, 8-19

purging rows from

manually, 8-19

reducing space allocated to, 8-19

reorganizing masters with, 8-21

truncating, 8-19

truncating master table with, 8-21

materialized view sites

adding

using offline instantiation, 8-26

administrators

creating, 2-21

changing masters, 18-107

database links

creating, 2-29, 4-20, 5-6, 5-13, 8-41

dropping, 8-4, 18-69

dropping objects from, 8-9

flowchart for setting up, 2-20

group owner

using, 8-39

monitoring, 10-11

multitier

setting up, 2-20

propagating changes to master, 14-20

refresher

creating, 2-21, 2-27

schedule purge, 2-24, 2-30

users

creating, 2-21

materialized views

data dictionary views, 26-1

deployment templates

user-defined types, 4-2

dropping, 8-10

generating support for, 18-80

monitoring, 10-11, 10-13

multitier

setting up, 5-4

user-defined conflict resolution, B-4

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

refresh groups

creating, 5-7, 5-14

refreshing, 4-21, 8-2, 8-38

security, A-8

trusted compared with untrusted, A-9

unregistering from master, 8-15

multimaster replication

monitoring, 10-2

security

trusted compared with untrusted, A-3

multitier materialized views

setting up, 2-20

N

NCHAR_ARG procedure, 12-5

NCLOB_ARG procedure, 12-5

notification log table

conflicts

creating, B-8

sample, B-9

notification methods

user-defined, B-8

notification package

conflicts

creating, B-9

NUMBER_ARG procedure, 12-5

NVARCHAR2_ARG procedure, 12-5

O

objects

adding to materialized view sites, 18-56

altering, 18-28

altering replication, 9-2

creating

for master group, 18-50, 18-51

for materialized view sites, 18-56

dropping

from materialized view site, 8-9, 18-70

generating replication support for, 18-81

offline instantiation

adding a master site, 7-37

adding a materialized view site, 8-26

INSTANTIATE_OFFLINE function, 20-3, 21-46

replication groups, 15-3, 15-4, 15-5, 15-7, 15-8

online instantiation

INSTANTIATE_ONLINE function, 20-6, 21-48

online redefinition of tables, 8-21

Oracle Replication Management tool

monitoring replication, 10-1

Oracle Streams

migrating to, 18-106

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

PREPARE_INSTANTIATED_MASTER procedure, 7-20, 7-32

PREPARE_INSTANTIATED_MASTERS procedure, 18-85

PRESERVE MATERIALIZED VIEW LOG option

TRUNCATE TABLE statement, 8-22

priority groups

adding members to, 18-17

altering members

priorities, 18-33

values, 18-34

creating, 18-60

dropping, 18-72

removing members from, 18-71, 18-73

site priority groups

adding members to, 18-18

procedural replication

conflicts and, 7-53

generating replication support for, 7-54

restrictions, 7-50

serialization of transactions, 7-53

user-defined types, 7-52

using, 7-50

propagation

altering method, 18-26, 18-31

disabling, 14-22

of changes, 18-26

parallel

monitoring, 10-32, 10-33

status of, 14-8

propagator

registering, 2-5, 2-6, 14-17

proxy materialized view administrator

creating, 2-7, 2-11, 2-14, 2-25

PURGE function, 9-15, 14-12

PURGE_LOG procedure, 8-19

PURGE_MASTER_LOG procedure, 18-87

PURGE_MVIEW_FROM_LOG procedure, 8-11, 8-15, 8-16, 8-19

PURGE_STATISTICS procedure, 6-45, 18-88

purges

DBA_REPCATLOG table, 18-87

deferred transaction queue, 9-15

master sites, 2-6

materialized view sites, 2-24, 2-30

monitoring, 10-24

PUSH function, 9-14, 14-14

pushes

deferred transaction queue, 9-14

Q

quiescing

adding master sites with, 7-34

adding master sites without, 7-4

altering replicated objects without, 9-2

configuring conflict resolution methods without, 6-3

master groups, 18-106

R

RAW_ARG procedure, 12-5

receiver

registering, 2-6

RECTIFY procedure, 9-10, 16-6

rectifying

tables, 9-10, 16-6

redefining tables

online

replication, 8-21

refresh

materialized view sites, 18-88

materialized views, 8-2, 8-38

monitoring, 10-16, 10-17

refresh groups

adding members to, 17-3

adding objects to, 5-10, 5-18, 8-36

creating, 5-7, 5-14, 17-6

data dictionary views, 26-1

deleting, 17-6

monitoring, 10-15

refresh, 8-2

refresh interval

changing, 17-4

refreshing

manually, 17-9

removing members from, 17-10

REFRESH procedure, 8-2, 8-38, 17-9

REFRESH_ALL_MVIEWS procedure, 8-2

REFRESH_DEPENDENT procedure, 8-2

REFRESH_MVIEW_REPGROUP procedure, 18-88

refresher

creating, 2-21, 2-27

REGISTER_MVIEW_REPGROUP procedure, 18-90

REGISTER_PROPAGATOR procedure, 2-5, 2-22, 2-28, 14-17

REGISTER_STATISTICS procedure, 6-44, 18-91

REGISTER_USER_REPGROUP procedure, 2-6, 2-7, 2-11, 2-15, 2-23, 2-26, 19-4

RELOCATE_MASTERDEF procedure, 7-2, 18-92

REMOVE_MASTER_DATABASE procedure, 7-45

REMOVE_MASTER_DATABASES procedure, 18-94

RENAME_SHADOW_COLUMN_GROUP procedure, 18-95

REPCAT_IMPORT_CHECK procedure, 18-96

replication

catalog views, 10-1, 23-1

column groups, 6-5, 6-8, 6-12, 6-15, 6-18, 6-24

conflict resolution, 6-1

uniqueness, 6-27

creating an environment, 1-2

data dictionary views, 10-1, 23-1

database links

creating, 2-16

datetime datatypes

abbreviations, 11-4

deferred transaction queues

managing, 9-14

deferred transactions

data dictionary views, 25-1

deployment templates

user-defined types, 4-2

determining differences between tables, 9-9

disabling, 7-54, 9-5, 9-6, 22-3

dynamic performance views, 24-1

enabling, 7-54, 9-5, 9-7, 22-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, 6-1

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

monitoring, 10-1

deferred transactions, 10-21

error transactions, 10-26

master environments, 10-2

materialized view environments, 10-11

performance, 10-30

objects

adding to master group, 3-6

altering, 9-2

dropping from master sites, 18-67

parallel propagation

monitoring, 10-32, 10-33

planning for, 1-4

procedural replication, 7-50

restrictions, 7-50

user-defined types, 7-52

propagator

registering, 2-5, 2-6

receiver

registering, 2-6

replicated objects, 9-1

replication queues, 9-1

resuming, 3-14

scheduled links

creating, 2-17

security, A-1

setting up sites, 2-2

sites

setup, 2-2

statistics

clearing, 10-33

triggers, 9-7

replication catalog views, 23-1

comments

updating, 7-48

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

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, 10-1, 10-2

setting up replication sites, 2-2

replication objects

altering, 9-2

tables

altering, 9-5

REPLICATION_IS_ON function, 22-3

REPLICATION_OFF procedure, 22-3

REPLICATION_ON procedure, 7-54, 22-3

RESUME_MASTER_ACTIVITY procedure, 3-15, 18-97

RESUME_PROPAGATION_TO_MDEF procedure, 7-17, 7-31, 18-98

RESUME_SUBSET_OF_MASTERS procedure, 7-42, 15-8

resuming replication activity, 18-97

REVOKE_ADMIN_ANY_SCHEMA procedure, 19-6

REVOKE_ADMIN_SCHEMA procedure, 19-7

ROWID_ARG procedure, 12-5

S

SCHEDULE_PURGE procedure, 2-7, 2-25, 2-30, 14-18

SCHEDULE_PUSH procedure, 2-17, 2-25, 2-31, 14-20

scheduled links

creating, 2-17

security

for materialized view replication, A-8

trusted compared with untrusted, A-9

for multimaster replication, A-2

trusted compared with untrusted, A-3

replication, A-1

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

SEND_OLD_VALUES procedure, 18-99

serialization

of transactions, 7-53

SET_COLUMNS procedure, 18-50, 18-102

SET_DISABLED procedure, 14-22

site priority

altering, 18-35

site priority groups

adding members to, 18-18

creating

syntax, 18-61

dropping, 18-74

removing members from, 18-75

snapshots. See materialized views

SPECIFY_NEW_MASTERS procedure, 7-12, 18-104

statistics

for conflict resolution

auditing, 6-44

cancelling, 6-45

clearing, 6-45, 18-88

collecting, 6-44, 18-91

viewing, 6-44

for propagation

clearing, 10-33, 14-4

status

propagation, 14-8

storage parameters

materialized view log

altering, 8-17

STREAMS_MIGRATION procedure, 18-106

SUBTRACT procedure, 17-10

SUSPEND_MASTER_ACTIVITY procedure, 18-106

SWITCH_MVIEW_MASTER procedure, 8-3, 18-107

SYNC_UP_REP procedure, 22-6

SYS.ANYDATA

GET_AnyData_ARG function, 13-8

T

tables

altering

without replicating changes, 9-5

altering replicated, 9-2

comparing, 16-3

differences between, 9-9

rectifying, 9-10, 16-6

redefining online

replication, 8-21

updating comments, 7-48

templates. See deployment templates

TIMESTAMP_ARG procedure, 12-5

token passing, 6-39

sample implementation, 6-38

TRANSACTION procedure, 12-8

transactions

serialization of, 7-53

triggers

for site priority conflict resolution, 6-24

for timestamp conflict resolution, 6-12

replicating, 9-7

TRUNCATE statement, 8-20

TRUNCATE TABLE statement

PRESERVE MATERIALIZED VIEW LOG option, 8-22

trusted security, A-3, A-9

TSLTZ_ARG procedure, 12-5

TSTZ_ARG procedure, 12-5

U

UNDO_ADD_NEW_MASTERS_REQUEST procedure, 18-109

UNREGISTER_MVIEW procedure, 8-15

UNREGISTER_MVIEW_REPGROUP procedure, 8-11, 18-110

UNREGISTER_PROPAGATOR procedure, 14-24

UNREGISTER_USER_REPGROUP procedure, 19-7

UNSCHEDULE_PURGE procedure, 14-25

UNSCHEDULE_PUSH procedure, 14-25

USER_REPCAT_REFRESH_TEMPLATES view, 23-44

USER_REPCAT_TEMP_OUTPUT view, 4-14

USER_REPCAT_TEMPLATE_OBJECTS view, 23-45

USER_REPCAT_TEMPLATE_PARMS view, 23-45

USER_REPCAT_TEMPLATE_SITES view, 23-45

USER_REPCAT_USER_AUTHORIZATIONS view, 23-45

USER_REPCAT_USER_PARM_VALUES view, 23-46

USER_REPCATLOG view, 23-46

USER_REPCOLUMN view, 23-46

USER_REPCOLUMN_GROUP view, 23-46

USER_REPCONFLICT view, 23-47

USER_REPDDL view, 23-47

USER_REPGENOBJECTS view, 23-47

USER_REPGROUP view, 23-47

USER_REPGROUP_PRIVILEGES view, 23-47

USER_REPGROUPED_COLUMN view, 23-47

USER_REPKEY_COLUMNS view, 23-48

USER_REPOBJECT view, 23-48

USER_REPPARAMETER_COLUMN view, 23-48

USER_REPPRIORITY view, 23-48

USER_REPPRIORITY_GROUP view, 23-49

USER_REPPROP view, 23-49

USER_REPRESOL_STATS_CONTROL view, 23-49

USER_REPRESOLUTION view, 23-49

USER_REPRESOLUTION_METHOD view, 23-50

USER_REPRESOLUTION_STATISTICS view, 23-50

USER_REPSITES view, 23-50

users

authorize for deployment template, 4-12

master materialized view sites, 2-25

master sites, 2-7, 2-11, 2-14

materialized view sites, 2-21

V

V$MVREFRESH view, 24-2

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

V$REPLQUEUE view, 24-4

VALIDATE procedure, 18-111

VARCHAR2_ARG procedure, 12-5

W

WAIT_MASTER_LOG procedure, 18-114

workflow, 6-38