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.2.2, 8.5, 17

ADD_DEFAULT_DEST procedure, 14

ADD_DELETE_RESOLUTION procedure, 18

ADD_GROUPED_COLUMN procedure, 18

ADD_MASTER_DATABASE procedure, 3.2, 7.2.2, 7.2.2.1, 18

ADD_NEW_MASTERS procedure, 7.2.1.1, 7.2.1.2, 18

ADD_PRIORITY_CHAR procedure, 18

ADD_PRIORITY_datatype procedure, 18

ADD_PRIORITY_DATE procedure, 18

ADD_PRIORITY_NUMBER procedure, 18

ADD_PRIORITY_VARCHAR2 procedure, 18

ADD_SITE_PRIORITY_SITE procedure, 6.2.6, 18

ADD_UNIQUENESS_RESOLUTION procedure, 18

ADD_UPDATE_RESOLUTION procedure, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6, 18

administrative requests

ALL_REPCATLOG view, 23

executing, 7.2.2.2, 18

monitoring, 10.3

errors, 10.3.2

jobs, 10.3.3

purging, 18

administrators

for materialized view sites

creating, 2.3.1

Advanced Replication

migrating to Streams, 18

Advanced Replication interface

monitoring replication, 10

ALL_REPCAT_REFRESH_TEMPLATES view, 23

ALL_REPCAT_TEMPLATE_OBJECTS view, 23

ALL_REPCAT_TEMPLATE_PARMS view, 23

ALL_REPCAT_TEMPLATE_SITES view, 23

ALL_REPCAT_USER_AUTHORIZATIONS view, 23

ALL_REPCAT_USER_PARM_VALUES view, 23

ALL_REPCATLOG view

administrative requests, 23

ALL_REPCOLUMN view, 23

ALL_REPCOLUMN_GROUP view, 23

ALL_REPCONFLICT view, 23

ALL_REPDDL view, 23

ALL_REPGENOBJECTS view, 23

ALL_REPGROUP view, 23

ALL_REPGROUP_PRIVILEGES view, 23

ALL_REPGROUPED_COLUMN view, 23

ALL_REPKEY_COLUMNS view, 23

ALL_REPOBJECT view, 23

ALL_REPPARAMETER_COLUMN view, 23

ALL_REPPRIORITY view, 23

ALL_REPPRIORITY_GROUP view, 23

ALL_REPPROP view, 23

ALL_REPRESOL_STATS_CONTROL view, 23

ALL_REPRESOLUTION view, 23

ALL_REPRESOLUTION_METHOD view, 23

ALL_REPRESOLUTION_STATISTICS view, 23

gathering statistics, 6.6

ALL_REPSITES view, 23

ALTER MATERIALIZED VIEW LOG statement, 8.4.1.1, 8.4.1.2

ALTER_CATCHUP_PARAMETERS procedure, 18

ALTER_MASTER_PROPAGATION procedure, 18

ALTER_MASTER_REPOBJECT procedure, 6.2.3, 6.2.6, 6.4, 9.1, 18

ALTER_MVIEW_PROPAGATION procedure, 18

ALTER_PRIORITY procedure, 18

ALTER_PRIORITY_CHAR procedure, 18

ALTER_PRIORITY_datatype procedure, 18

ALTER_PRIORITY_DATE procedure, 18

ALTER_PRIORITY_NUMBER procedure, 18

ALTER_PRIORITY_RAW procedure, 18

ALTER_REFRESH_TEMPLATE procedure, 21

ALTER_SITE_PRIORITY procedure, 18

ALTER_SITE_PRIORITY_SITE procedure, 18

ALTER_TEMPLATE_OBJECT procedure, 21

ALTER_TEMPLATE_PARM procedure, 21

ALTER_USER_AUTHORIZATION procedure, 21

ALTER_USER_PARM_VALUE procedure, 21

ANY_CHAR_ARG procedure, 12

ANY_CLOB_ARG procedure, 12

ANY_VARCHAR2_ARG procedure, 12

ANYDATA

GET_ANYDATA_ARG function, 13

ANYDATA data type

replication, 9.5.3

ANYDATA_ARG procedure, 12

authorization

template users, 4.3

availability

extended, 6.2, 7.2.1, 9.1, 18, 18, 18, 18, 18, 18

B

BEGIN_INSTANTIATION procedure, 7.2.2.2, 15

BEGIN_LOAD procedure, 7.2.2.2, 15

BEGIN_TABLE_REORGANIZATION, 8.4.3.1

BLOB_ARG procedure, 12

C

CALL procedure, 12

CANCEL_STATISTICS procedure, 6.6.3, 18

CHANGE procedure, 17

CHAR_ARG procedure, 12

CLEAR_PROP_STATISTICS procedure, 10.6.6, 14

CLOB_ARG procedure, 12

column objects

user-defined conflict resolution, B.1.1

column subsetting

user-defined conflict resolution methods, B.1.6.2

columns

adding to master tables, 18

column groups, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6

adding members to, 18

creating, 18, 18

dropping, 18

removing members from, 18

COMMENT_ON_COLUMN_GROUP procedure, 18

COMMENT_ON_DELETE_RESOLUTION procedure, 18

COMMENT_ON_MVIEW_REPSITES procedure, 18

COMMENT_ON_PRIORITY procedure, 18

COMMENT_ON_REPGROUP procedure, 18

COMMENT_ON_REPOBJECT procedure, 18

COMMENT_ON_REPSITES procedure, 18

COMMENT_ON_SITE_PRIORITY procedure, 18

COMMENT_ON_UNIQUE_RESOLUTION procedure, 18

COMMENT_ON_UPDATE_RESOLUTION procedure, 18

comments

comments field

updating in views, 7.4

updating, 7.4

COMMIT_WORK procedure, 12

COMPARE_OLD_VALUES procedure, 18, 18

COMPARE_TEMPLATES function, 21

comparing

tables, 16

conflict resolution, 6

additive method, 6.2.4, 18

auditing, 6.6, 6.6

average method, 6.2.4

column groups, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6

configuring without quiesce, 6.2

DBA_REPRESOLUTION_STATISTICS view, 6.6.4

discard method, 6.2.1

information

viewing, B.3

maximum method, 6.2.2

minimum method, 6.2.2

overwrite method, 6.2.1

preparing for, 6.1

priority groups method, 6.2.5

procedural replication and, 7.5.3

site priority method, 6.2.6

sample trigger, 6.2.6

statistics, 18, 18

canceling, 6.6.3

collecting, 6.6.1

viewing, 6.6.2

time stamp method

sample trigger, 6.2.3

timestamp method, 6.2.3

uniqueness, 6.3

user-defined methods, B.1

column objects, B.1.1

column subsetting, B.1.6.2

example, B.1.7

for delete conflicts, B.1.4

for uniqueness conflicts, B.1.3

for update conflicts, B.1.2

multitier materialized views, B.1.5

parameters, B.1.1

restrictions, B.1.6

viewing information, B.3

conflicts

avoiding

delete, 6.4

dynamic ownership, 6.5

notification log table

creating, B.2.1

sample, B.2.1.1

notification methods

user-defined, B.2

notification package

creating, B.2.2

sample, B.2.2.1

token passing, 6.5.2

workflow, 6.5.1

COPY_TEMPLATE function, 21

CREATE_MASTER_REPGROUP procedure, 3.2, 18

CREATE_MASTER_REPOBJECT procedure, 6.2.3, 6.2.6, 18

CREATE_MVIEW_REPGROUP procedure, 5.2.1, 8.5, 8.6, 8.6, 18

CREATE_MVIEW_REPOBJECT procedure, 5.2.1, 5.2.1, 5.2.2, 5.2.2, 8.6, 8.6, 18

CREATE_OBJECT_FROM_EXISTING function, 21

CREATE_REFRESH_TEMPLATE function, 21

CREATE_REFRESH_TEMPLATE procedure, 4.3

CREATE_TEMPLATE_OBJECT function, 21

CREATE_TEMPLATE_OBJECT procedure, 4.3

CREATE_TEMPLATE_PARM function, 21

CREATE_USER_AUTHORIZATION function, 21

CREATE_USER_AUTHORIZATION procedure, 4.3

CREATE_USER_PARM_VALUE function, 21

D

data definition language

altering replicated objects, 18

asynchronous, 18

data dictionary views

comments

updating, 7.4

materialized views, 26

refresh groups, 26

replication, 10, 23

database links

creating, 2.2.4, 2.3.2, 4.6, 5.2.1, 5.2.2, 8.6

datatype_ARG procedure, 12

date expressions, 2.2.1

DATE_ARG procedure, 12

DBA_REGISTERED_MVIEW_GROUPS view, 23

DBA_REPCAT_REFRESH_TEMPLATES view, 23

DBA_REPCAT_TEMPLATE_OBJECTS view, 23

DBA_REPCAT_TEMPLATE_PARMS view, 23

DBA_REPCAT_TEMPLATE_SITES view, 23

DBA_REPCAT_USER_AUTHORIZATIONS view, 23

DBA_REPCAT_USER_PARM_VALUES view, 23

DBA_REPCATLOG view, 23

purging requests from, 18

DBA_REPCOLUMN view, 23

DBA_REPCOLUMN_GROUP view, 23

updating, 18

DBA_REPCONFLICT view, 23

DBA_REPDDL view, 23

DBA_REPEXTENSIONS view, 23

DBA_REPGENOBJECTS view, 23

DBA_REPGROUP view, 23

updating, 18

DBA_REPGROUP_PRIVILEGES view, 23

DBA_REPGROUPED_COLUMN view, 23

DBA_REPKEY_COLUMNS view, 23

DBA_REPOBJECT view, 23

updating, 18

DBA_REPPARAMETER_COLUMN view, 23

DBA_REPPRIORITY view, 23

DBA_REPPRIORITY_GROUP view, 23

DBA_REPPRIORITYGROUP view

updating, 18, 18

DBA_REPPROP view, 23

DBA_REPRESOL_STATS_CONTROL view, 23

DBA_REPRESOLUTION view, 23

updating, 18

DBA_REPRESOLUTION_METHOD view, 23, 23

DBA_REPRESOLUTION_STATISTICS view, 23

purging, 6.6.4, 18

DBA_REPSITES view, 23

updating, 18

DBA_REPSITES_NEW view, 23

DBMS_DEFER package, 12

DBMS_DEFER_QUERY package, 13

GET_ANYDATA_ARG function, 9.5.3

DBMS_DEFER_SYS package, 14

CLEAR_PROP_STATISTICS procedure, 10.6.6

EXECUTE_ERROR procedure, 7.2.2.2, 9.6.1

EXECUTE_ERROR_AS_USER procedure, 9.6.2

PURGE function, 9.5.2

PUSH function, 9.5.1

REGISTER_PROPAGATOR procedure, 2.2.1, 2.3.1, 2.3.2

SCHEDULE_PURGE procedure, 2.2.1, 2.3.1, 2.3.2

SCHEDULE_PUSH procedure, 2.2.4, 2.2.4, 2.3.1, 2.3.2

DBMS_MVIEW package

BEGIN_TABLE_REORGANIZATION procedure, 8.4.3.1

END_TABLE_REORGANIZATION procedure, 8.4.3.1

PURGE_LOG procedure, 8.4.2.1

PURGE_MVIEW_FROM_LOG procedure, 8.3.3.1, 8.3.3.2, 8.3.3.2, 8.4.2.1

REFRESH procedure, 8.1, 8.5

UNREGISTER_MVIEW procedure, 8.3.3.2

DBMS_OFFLINE_OG package, 15

BEGIN_INSTANTIATION procedure, 7.2.2.2

BEGIN_LOAD procedure, 7.2.2.2

END_INSTANTIATION procedure, 7.2.2.2

END_LOAD procedure, 7.2.2.2

RESUME_SUBSET_OF_MASTERS procedure, 7.2.2.2

DBMS_OFFLINE_SNAPSHOT package

END_LOAD procedure, 8.5, 8.5, 8.5, 8.5, 8.5, 8.5, 8.5

DBMS_RECTIFIER_DIFF package, 9.4, 16

DIFFERENCES procedure, 9.4.1

RECTIFY procedure, 9.4.2

DBMS_REFRESH package, 17

ADD procedure, 5.2.2, 8.5

MAKE procedure, 5.2.1, 5.2.2, 8.5

REFRESH procedure, 8.1

DBMS_REPCAT package, 7.4, 18

ADD_MASTER_DATABASE procedure, 3.2, 7.2.2, 7.2.2.1

ADD_NEW_MASTERS procedure, 7.2.1.1, 7.2.1.2

ADD_SITE_PRIORITY_SITE procedure, 6.2.6

ADD_UPDATE_RESOLUTION procedure, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6

ALTER_MASTER_REPOBJECT procedure, 6.2.3, 6.2.6, 6.4, 9.1

CANCEL_STATISTICS procedure, 6.6.3

CREATE_MASTER_REPGROUP procedure, 3.2

CREATE_MASTER_REPOBJECT procedure, 6.2.3, 6.2.6

CREATE_MVIEW_REPGROUP procedure, 5.2.1, 8.5, 8.6, 8.6

CREATE_MVIEW_REPOBJECT procedure, 5.2.1, 5.2.1, 5.2.1, 5.2.1, 5.2.1, 5.2.1, 5.2.2, 5.2.2, 5.2.2, 5.2.2, 5.2.2, 5.2.2, 5.2.2, 8.6, 8.6

DEFINE_SITE_PRIORITY procedure, 6.2.6

DO_DEFERRED_REPCAT_ADMIN procedure, 6.4, 7.2.2.2

DROP_MVIEW_REPGROUP procedure, 8.3.1.1, 8.3.1.2, 8.3.2.1

DROP_MVIEW_REPOBJECT procedure, 8.3.2.2

GENERATE_REPLICATION_SUPPORT procedure, 3.2, 3.2, 3.2, 3.2, 3.2, 3.2, 3.2, 9.1

MAKE_COLUMN_GROUP procedure, 6.2.1, 6.2.2, 6.2.3, 6.2.3, 6.2.4, 6.2.5, 6.2.6

PREPARE_INSTANTIATED_MASTER procedure, 7.2.1.1, 7.2.1.2

PURGE_STATISTICS procedure, 6.6.4

REGISTER_STATISTICS procedure, 6.6.1

RELOCATE_MASTERDEF procedure, 7.1.1

REMOVE_MASTER_DATABASE procedure, 7.3

RESUME_MASTER_ACTIVITY procedure, 3.2

RESUME_PROPAGATION_TO_MDEF procedure, 7.2.1.1, 7.2.1.2

SPECIFY_NEW_MASTERS procedure, 7.2.1.1, 7.2.1.2

SWITCH_MVIEW_MASTER procedure, 8.2

UNREGISTER_MVIEW_REPGROUP procedure, 8.3.3.1

DBMS_REPCAT_ADMIN package, 20

GRANT_ADMIN_ANY_SCHEMA procedure, 2.2.1, 2.3.1, 2.3.2

REGISTER_USER_REPGROUP procedure, 2.2.1, 2.2.1, 2.2.2, 2.2.3, 2.3.1, 2.3.1

DBMS_REPCAT_INSTANTIATE package, 19

DROP_SITE_INSTANTIATION procedure, 8.3.1.1, 8.3.1.2

DBMS_REPCAT_RGT package, 21

CREATE_REFRESH_TEMPLATE procedure, 4.3

CREATE_TEMPLATE_OBJECT procedure, 4.3

CREATE_USER_AUTHORIZATION procedure, 4.3

INSTANTIATE_OFFLINE procedure, 4.4.1.1

INSTANTIATE_ONLINE procedure, 4.4.1.2

DBMS_REPUTIL package, 22

REPLICATION_OFF procedure, 7.5.4, 9.2.1

REPLICATION_ON procedure, 7.5.4, 9.2.2

DDL. See data definition language

DEFCALL view, 25

DEFCALLDEST view, 25

DEFDEFAULTDEST view, 25

adding destinations to, 14

removing destinations from, 14, 14

DEFERRCOUNT view, 25

deferred transaction queues

deferred calls

determining value of, 9.5.3

managing, 9.5

purging propagated transactions, 9.5.2

pushing, 9.5.1

deferred transactions

data dictionary views, 25

DEFDEFAULTDEST view

adding destination to, 14

removing destinations from, 14

deferred remote procedure calls (RPCs)

argument types, 13

argument values, 13

arguments to, 12

building, 12

executing immediately, 14

DEFSCHEDULE view

clearing statistics, 14

removing destinations from, 14

deleting from queue, 14

monitoring, 10.4

purge job, 10.4.2.1, 10.4.2.2

push jobs, 10.4.1.2, 10.4.1.3

reexecuting, 14

scheduling execution, 14

starting, 12

DEFERROR view, 9.6, 25

deleting transactions from, 14

DEFINE_COLUMN_GROUP procedure, 18

DEFINE_PRIORITY_GROUP procedure, 18

DEFINE_SITE_PRIORITY procedure, 6.2.6, 18

DEFLOB view, 25

DEFPROPAGATOR view, 25, 25

DEFSCHEDULE view, 25

clearing statistics, 10.6.6, 14

DEFTRAN view, 25

DEFTRANDEST view, 25

DELETE_DEF_DESTINATION procedure, 14

DELETE_DEFAULT_DEST procedure, 14

DELETE_ERROR procedure, 14

DELETE_RUNTIME_PARMS procedure, 21

DELETE_TRAN procedure, 14

deployment templates

alter object, 21

alter parameters, 21

alter template, 21

alter user authorization, 21

alter user parameter values, 21

authorize users, 4.3

compare templates, 21

concepts, 4.1

copy template, 21

create object from existing, 21

create template, 21

creating, 4.3, 4.3

data dictionary views for, 23

distributing files, 4.5

drop site instantiation, 19

dropping, 21

dropping all, 21

dropping materialized view group, 8.3.1

flowchart for creating, 4.3

instantiating, 4.6

instantiation script, 4.4.2

lock template, 21, 21

monitoring, 10.1.3.4

objects

creating, 21

dropping, 21

dropping all, 21

offline instantiation, 4.4, 19, 21

online instantiation, 19, 21

packaging, 4.4, 4.4.1

for offline instantiation, 4.4.1.1

for online instantiation, 4.4.1.2

parameters

creating, 4.3, 21

dropping, 21

dropping all, 21

user values, 4.3

runtime parameters

creating, 21

deleting, 21

get ID, 21

inserting, 21

sites

dropping, 21

dropping all, 21

user authorizations

creating, 21

dropping, 21

dropping all, 21

user parameter values

creating, 21

dropping, 21

dropping all, 21

user-defined types, 4.1

DESTROY procedure, 17

differences

between tables, 16

rectifying, 16

DIFFERENCES procedure, 9.4.1, 16

DISABLED function, 14

disabling

propagation, 14

DO_DEFERRED_REPCAT_ADMIN procedure, 6.4, 7.2.2.2, 18

DROP MATERIALIZED VIEW LOG statement, 8.4.4

DROP_ALL_OBJECTS procedure, 21

DROP_ALL_TEMPLATE_PARMS procedure, 21

DROP_ALL_TEMPLATE_SITES procedure, 21

DROP_ALL_TEMPLATES procedure, 21

DROP_ALL_USER_AUTHORIZATIONS procedure, 21

DROP_ALL_USER_PARM_VALUES procedure, 21

DROP_COLUMN_GROUP procedure, 18

DROP_DELETE_RESOLUTION procedure, 18

DROP_GROUPED_COLUMN procedure, 18

DROP_MASTER_REPGROUP procedure, 18

DROP_MASTER_REPOBJECT procedure, 18

DROP_MVIEW_REPGROUP procedure, 8.3.1.1, 8.3.1.2, 18

DROP_MVIEW_REPOBJECT procedure, 8.3.2.2, 18

DROP_PRIORITY procedure, 18

DROP_PRIORITY_CHAR procedure, 18

DROP_PRIORITY_datatype procedure, 18

DROP_PRIORITY_DATE procedure, 18

DROP_PRIORITY_GROUP procedure, 18

DROP_PRIORITY_NUMBER procedure, 18

DROP_PRIORITY_VARCHAR2 procedure, 18

DROP_REFRESH_TEMPLATE procedure, 21

DROP_SITE_INSTANTIATION procedure, 8.3.1.1, 8.3.1.2, 19, 21

DROP_SITE_PRIORITY procedure, 18

DROP_SITE_PRIORITY_SITE procedure, 18

DROP_TEMPLATE_OBJECT procedure, 21

DROP_TEMPLATE_PARM procedure, 21

DROP_UNIQUE_RESOLUTION procedure, 18

DROP_UPDATE_RESOLUTION procedure, 18

DROP_USER_AUTHORIZATION procedure, 21

DROP_USER_PARM_VALUE procedure, 21

dynamic ownership

conflict avoidance and, 6.5

locating owner of a row, 6.5.3

obtaining ownership, 6.5.4

workflow partitioning, 6.5.1

dynamic performance views

replication, 24

E

END_INSTANTIATION procedure, 7.2.2.2, 15

END_LOAD procedure, 7.2.2.2, 8.5, 8.5, 15

END_TABLE_REORGANIZATION procedure, 8.4.3.1

Enterprise Manager

Advanced Replication interface, 10

errors

error queues

DEFERROR view, 9.6

managing, 9.6

error transactions

monitoring, 10.5

reexecuting as alternate user, 9.6.2

reexecuting as receiver, 9.6.1

EXCLUDE_PUSH function, 14

EXECUTE_DDL procedure, 18

EXECUTE_ERROR procedure, 7.2.2.2, 9.6.1, 14

EXECUTE_ERROR_AS_USER procedure, 9.6.2, 14

extended availability, 6.2, 7.2.1, 9.1, 18, 18, 18, 18, 18, 18

F

foreign key constraints

adding master sites, 7.2

FROM_REMOTE function, 22

G

GENERATE_MVIEW_SUPPORT procedure, 18

GENERATE_REPLICATION_SUPPORT procedure, 3.2, 3.2, 9.1, 18

generating

replication support, 3.2

procedural replication, 7.5.4

GET_ANYDATA_ARG function, 9.5.3, 13

GET_ARG_FORM function, 13

GET_ARG_TYPE function, 13

GET_BLOB_ARG function, 13

GET_CALL_ARGS procedure, 13

GET_CHAR_ARG function, 13

GET_CLOB_ARG function, 13

GET_datatype_ARG function, 13

GET_DATE_ARG function, 13

GET_IDS_ARG function, 13

GET_IYM_ARG function, 13

GET_NCHAR_ARG function, 13

GET_NCLOB_ARG function, 13

GET_NUMBER_ARG function, 13

GET_NVARCHAR2_ARG function, 13

GET_OBJECT_NULL_VECTOR_ARG function, 13

GET_RAW_ARG function, 13

GET_ROWID_ARG function, 13

GET_RUNTIME_PARM_ID function, 21

GET_TIMESTAMP_ARG function, 13

GET_TSLTZ_ARG function, 13

GET_TSTZ_ARG function, 13

GET_VARCHAR2_ARG function, 13

GLOBAL_NAME function, 22

GRANT_ADMIN_ANY_SCHEMA procedure, 2.2.1, 2.3.1, 2.3.2, 20

GRANT_ADMIN_SCHEMA procedure, 20

I

IDS_ARG procedure, 12

Import

replication groups

offline instantiation and, 15, 15

status check, 18

INSERT_RUNTIME_PARMS procedure, 21

INSTANTIATE_OFFLINE function, 19, 21

INSTANTIATE_OFFLINE procedure, 4.4.1.1

INSTANTIATE_ONLINE function, 19, 21

INSTANTIATE_ONLINE procedure, 4.4.1.2

instantiation, 4.6

DROP_SITE_INSTANTIATION procedure, 19, 21

offline, 4.4

INSTANTIATE_OFFLINE function, 19, 21

online

INSTANTIATE_ONLINE function, 19, 21

refreshing after, 4.7

script, 4.4.2

IYM_ARG procedure, 12

J

jobs

queues for

removing jobs from, 14, 14

L

LOCK_TEMPLATE_EXCLUSIVE procedure, 21

LOCK_TEMPLATE_SHARED procedure, 21

LONG columns

replication, 9.3

M

MAKE procedure, 5.2.1, 5.2.2, 8.5, 17

MAKE_COLUMN_GROUP procedure, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.6, 18

MAKE_INTERNAL_PKG procedure, 22

master definition site

relocating, 18

master groups

adding master sites to

with quiesce, 7.2.2

without quiesce, 7.2.1

adding objects to, 3.2

creating, 3.1, 3.2, 18

dropping, 18

flowchart for creating, 3.1.1

monitoring, 10.1.2

quiescing, 18

removing master sites from, 7.3

resuming replication activity, 18

master materialized views

monitoring, 10.1.3

reorganizing, 8.4.3

master sites

adding, 3.2, 7.2

circular dependencies, 3.2, 7.2

flowchart for, 7.2.1.2

flowchart for determining method, 7.2.1

foreign key constraints, 7.2

restrictions, 7.2.1

restrictions for change-based recovery, 7.2.1

restrictions for full database export/import, 7.2.1

self-referential constraints, 3.2, 7.2

using change-based recovery, 7.2.1.1

using full database export/import, 7.2.1.1

using object-level export/import, 7.2.1.2

using offline instantiation, 7.2.2.2

with quiesce, 7.2.2

without quiesce, 7.2.1

changing master definition site, 7.1

cleaning up, 8.3.3

creating, 18

creating users for, 2.2.1, 2.2.1, 2.2.2, 2.2.2, 2.2.3, 2.2.3, 2.3.1

database links, 2.2.4

determining differences, 9.4

dropping, 18

flowchart for setting up, 2.1

monitoring, 10.1.1, 10.1.3

propagating changes between, 14

removing, 7.3

scheduled links for, 2.2.4

scheduled purges for, 2.2.1

setup, 2.2

master tables

adding columns to, 18

redefining online, 8.4.3

reorganizing, 8.4.3

methods, 8.4.3.3

truncating, 8.4.3.2

materialized view groups

adding objects to, 5.2.1, 5.2.2, 8.6

changing masters, 8.2

creating, 5.2, 5.2.1, 5.2.2, 18

dropping, 8.3.1, 8.3.2.1

group owner, 8.6

monitoring, 10.2.2

refreshing, 18

materialized view logs

adding columns, 8.4.1.2

altering, 8.4.1

privileges required, 8.4.1

dropping, 8.4.4

managing, 8.4

space, 8.4.2

monitoring, 10.1.3.2

purging

materialized views from, 8.3.3.1, 8.3.3.2

privileges required, 8.4.2.1

purging rows from

manually, 8.4.2.1

reducing space allocated to, 8.4.2.2

reorganizing masters with, 8.4.3

truncating, 8.4.2.2

truncating master table with, 8.4.3.2

materialized view sites

adding

using offline instantiation, 8.5

administrators

creating, 2.3.1

changing masters, 18

database links

creating, 2.3.2, 4.6, 5.2.1, 5.2.2, 8.6

dropping, 8.3, 18

dropping objects from, 8.3.2

flowchart for setting up, 2.3

group owner

using, 8.6

monitoring, 10.2.1

multitier

setting up, 2.3

propagating changes to master, 14

refresher

creating, 2.3.1, 2.3.2

schedule purge, 2.3.1, 2.3.1, 2.3.2, 2.3.2

users

creating, 2.3.1

materialized views

data dictionary views, 26

deployment templates

user-defined types, 4.1

dropping, 8.3.2.2

generating support for, 18

monitoring, 10.2, 10.2.3

multitier

setting up, 5.2

user-defined conflict resolution, B.1.5

purging from materialized view logs, 8.3.3.1, 8.3.3.2

refresh groups

creating, 5.2.1, 5.2.2

refreshing, 4.7, 8.1, 8.5

security, A.2

trusted compared with untrusted, A.2.1

unregistering from master, 8.3.3.2

monitoring replication, 10

Advanced Replication interface, 10

multimaster replication

monitoring, 10.1

security

trusted compared with untrusted, A.1.1

multitier materialized views

setting up, 2.3

N

NCHAR_ARG procedure, 12

NCLOB_ARG procedure, 12

notification log table

conflicts

creating, B.2.1

sample, B.2.1.1

notification methods

user-defined, B.2

notification package

conflicts

creating, B.2.2

NUMBER_ARG procedure, 12

NVARCHAR2_ARG procedure, 12

O

objects

adding to materialized view sites, 18

altering, 18

creating

for master group, 18, 18

for materialized view sites, 18

dropping

from materialized view site, 8.3.2, 18

generating replication support for, 18, 18

offline instantiation

adding a master site, 7.2.2.2

adding a materialized view site, 8.5

INSTANTIATE_OFFLINE function, 19, 21

replication groups, 15, 15, 15, 15, 15

online instantiation

INSTANTIATE_ONLINE function, 19, 21

online redefinition of tables, 8.4.3

Oracle Streams

migrating to, 18

P

packaging

deployment templates, 4.4

parallel propagation

monitoring, 10.6.5, 10.6.7

parameters

deployment templates, 4.3

user values, 4.3

performance

replication

monitoring, 10.6

planning

for replication, 1.2

PREPARE_INSTANTIATED_MASTER procedure, 7.2.1.1, 7.2.1.2

PREPARE_INSTANTIATED_MASTERS procedure, 18

PRESERVE MATERIALIZED VIEW LOG option

TRUNCATE TABLE statement, 8.4.3.2

priority groups

adding members to, 18

altering members

priorities, 18

values, 18

creating, 18

dropping, 18

removing members from, 18, 18

site priority groups

adding members to, 18

procedural replication

conflicts and, 7.5.3

generating replication support for, 7.5.4

restrictions, 7.5.1

serialization of transactions, 7.5.3

user-defined types, 7.5.2

using, 7.5

propagation

altering method, 18, 18

disabling, 14

of changes, 18

parallel

monitoring, 10.6.5, 10.6.7

status of, 14

propagator

registering, 2.2.1, 2.2.1, 14

proxy materialized view administrator

creating, 2.2.1, 2.2.1, 2.2.2, 2.2.2, 2.2.3, 2.2.3, 2.3.1

PURGE function, 9.5.2, 14

PURGE_LOG procedure, 8.4.2.1

PURGE_MASTER_LOG procedure, 18

PURGE_MVIEW_FROM_LOG procedure, 8.3.3.1, 8.3.3.2, 8.3.3.2, 8.4.2.1

PURGE_STATISTICS procedure, 6.6.4, 18

purges

DBA_REPCATLOG table, 18

deferred transaction queue, 9.5.2

master sites, 2.2.1

materialized view sites, 2.3.1, 2.3.2

monitoring, 10.4.2

PUSH function, 9.5.1, 14

pushes

deferred transaction queue, 9.5.1

Q

quiescing

adding master sites with, 7.2.2

adding master sites without, 7.2.1

altering replicated objects without, 9.1

configuring conflict resolution methods without, 6.2

master groups, 18

R

RAW_ARG procedure, 12

receiver

registering, 2.2.1

RECTIFY procedure, 9.4.2, 16

rectifying

tables, 9.4.2, 16

redefining tables

online

replication, 8.4.3

refresh

materialized view sites, 18

materialized views, 8.1, 8.5

monitoring, 10.2.5, 10.2.6

refresh groups

adding members to, 17

adding objects to, 5.2.1, 5.2.2, 8.5

creating, 5.2.1, 5.2.2, 17

data dictionary views, 26

deleting, 17

monitoring, 10.2.4

refresh, 8.1

refresh interval

changing, 17

refreshing

manually, 17

removing members from, 17

REFRESH procedure, 8.1, 8.1, 8.5, 17

REFRESH_ALL_MVIEWS procedure, 8.1

REFRESH_DEPENDENT procedure, 8.1

REFRESH_MVIEW_REPGROUP procedure, 18

refresher

creating, 2.3.1, 2.3.2

REGISTER_MVIEW_REPGROUP procedure, 18

REGISTER_PROPAGATOR procedure, 2.2.1, 2.3.1, 2.3.2, 14

REGISTER_STATISTICS procedure, 6.6.1, 18

REGISTER_USER_REPGROUP procedure, 2.2.1, 2.2.1, 2.2.2, 2.2.3, 2.3.1, 2.3.1, 20

RELOCATE_MASTERDEF procedure, 7.1.1, 18

REMOVE_MASTER_DATABASE procedure, 7.3

REMOVE_MASTER_DATABASES procedure, 18

RENAME_SHADOW_COLUMN_GROUP procedure, 18

REPCAT_IMPORT_CHECK procedure, 18

replication

catalog views, 10, 23

column groups, 6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6

conflict resolution, 6

uniqueness, 6.3

creating an environment, 1.1

data dictionary views, 10, 23

database links

creating, 2.2.4

datetime data types

abbreviations, 11.4

deferred transaction queues

managing, 9.5

deferred transactions

data dictionary views, 25

deployment templates

user-defined types, 4.1

determining differences between tables, 9.4

disabling, 7.5.4, 9.2, 9.2.1, 22

dynamic performance views, 24

enabling, 7.5.4, 9.2, 9.2.2, 22

error queues

managing, 9.6

flowchart for creating environment, 1.1

generating support for, 3.2

interval data types

abbreviations, 11.4

LONG column

converting to LOB, 9.3

managing an environment, 6

master groups

creating, 3.1

master sites

adding, 3.2

materialized view groups

creating, 5.2, 5.2.1, 5.2.2

materialized view logs

managing, 8.4

monitoring, 10

deferred transactions, 10.4

error transactions, 10.5

master environments, 10.1

materialized view environments, 10.2

performance, 10.6

objects

adding to master group, 3.2

dropping from master sites, 18

parallel propagation

monitoring, 10.6.5, 10.6.7

planning for, 1.2

procedural replication, 7.5

restrictions, 7.5.1

user-defined types, 7.5.2

propagator

registering, 2.2.1, 2.2.1

receiver

registering, 2.2.1

replicated objects, 9

replication queues, 9

resuming, 3.2

scheduled links

creating, 2.2.4

security, A

setting up sites, 2.1

sites

setup, 2.1

statistics

clearing, 10.6.6

triggers, 9.2.3

replication catalog views, 23

comments

updating, 7.4, 7.4

monitoring replication, 10

replication management API, 11

conflict resolution, 6

deployment templates

creating, 4.3

instantiating, 4.6

packaging, 4.4

examples, 11.1

managing a replication environment, 6

managing replicated objects, 9

managing replication queues, 9

master groups

creating, 3.1

materialized view groups

creating, 5.2

overview, 1

packages, 10

setting up replication sites, 2.1

replication objects

altering, 9.1

tables

altering, 9.2

REPLICATION_IS_ON function, 22

REPLICATION_OFF procedure, 22

REPLICATION_ON procedure, 7.5.4, 7.5.4, 22

RESUME_MASTER_ACTIVITY procedure, 3.2, 18

RESUME_PROPAGATION_TO_MDEF procedure, 7.2.1.1, 7.2.1.2, 18

RESUME_SUBSET_OF_MASTERS procedure, 7.2.2.2, 15

resuming replication activity, 18

REVOKE_ADMIN_ANY_SCHEMA procedure, 20

REVOKE_ADMIN_SCHEMA procedure, 20

ROWID_ARG procedure, 12

S

SCHEDULE_PURGE procedure, 2.2.1, 2.3.1, 2.3.2, 14

SCHEDULE_PUSH procedure, 2.2.4, 2.3.1, 2.3.2, 14

scheduled links

creating, 2.2.4

security

for materialized view replication, A.2

trusted compared with untrusted, A.2.1

for multimaster replication, A.1

trusted compared with untrusted, A.1.1

replication, A

trusted compared with untrusted, A.1.1, A.2.1

SEND_OLD_VALUES procedure, 18

serialization

of transactions, 7.5.3

SET_COLUMNS procedure, 18, 18

SET_DISABLED procedure, 14

site priority

altering, 18

site priority groups

adding members to, 18

creating

syntax, 18

dropping, 18

removing members from, 18

snapshots. See materialized views

SPECIFY_NEW_MASTERS procedure, 7.2.1.1, 18

statistics

for conflict resolution

auditing, 6.6

cancelling, 6.6.3

clearing, 6.6.4, 18

collecting, 6.6.1, 18

viewing, 6.6.2

for propagation

clearing, 10.6.6, 14

status

propagation, 14

storage parameters

materialized view log

altering, 8.4.1.1

STREAMS_MIGRATION procedure, 18

SUBTRACT procedure, 17

SUSPEND_MASTER_ACTIVITY procedure, 18

SWITCH_MVIEW_MASTER procedure, 8.2, 18

SYNC_UP_REP procedure, 22

T

tables

altering

without replicating changes, 9.2

altering replicated, 9.1

comparing, 16

differences between, 9.4

rectifying, 9.4.2, 16

redefining online

replication, 8.4.3

updating comments, 7.4, 7.4

templates. See deployment templates

TIMESTAMP_ARG procedure, 12

token passing, 6.5.2

sample implementation, 6.5

TRANSACTION procedure, 12

transactions

serialization of, 7.5.3

triggers

for site priority conflict resolution, 6.2.6

for time stamp conflict resolution, 6.2.3

replicating, 9.2.3

TRUNCATE statement, 8.4.2.2

TRUNCATE TABLE statement

PRESERVE MATERIALIZED VIEW LOG option, 8.4.3.2

trusted security, A.1.1, A.2.1

TSLTZ_ARG procedure, 12

U

UNDO_ADD_NEW_MASTERS_REQUEST procedure, 18

UNREGISTER_MVIEW procedure, 8.3.3.2

UNREGISTER_MVIEW_REPGROUP procedure, 18

UNREGISTER_PROPAGATOR procedure, 14

UNREGISTER_USER_REPGROUP procedure, 20

UNSCHEDULE_PURGE procedure, 14

UNSCHEDULE_PUSH procedure, 14

USER_REPCAT_REFRESH_TEMPLATES view, 23

USER_REPCAT_TEMP_OUTPUT view, 4.4.1

USER_REPCAT_TEMPLATE_OBJECTS view, 23

USER_REPCAT_TEMPLATE_PARMS view, 23

USER_REPCAT_TEMPLATE_SITES view, 23

USER_REPCAT_USER_AUTHORIZATIONS view, 23

USER_REPCAT_USER_PARM_VALUES view, 23

USER_REPCATLOG view, 23

USER_REPCOLUMN view, 23

USER_REPCOLUMN_GROUP view, 23

USER_REPCONFLICT view, 23, 23

USER_REPDDL view, 23, 23

USER_REPGENOBJECTS view, 23, 23

USER_REPGROUP view, 23

USER_REPGROUP_PRIVILEGES view, 23

USER_REPGROUPED_COLUMN view, 23

USER_REPKEY_COLUMNS view, 23

USER_REPOBJECT view, 23

USER_REPPARAMETER_COLUMN view, 23

USER_REPPRIORITY view, 23

USER_REPPRIORITY_GROUP view, 23

USER_REPPROP view, 23

USER_REPRESOL_STATS_CONTROL view, 23

USER_REPRESOLUTION view, 23

USER_REPRESOLUTION_METHOD view, 23

USER_REPRESOLUTION_STATISTICS view, 23

USER_REPSITES view, 23

users

authorize for deployment template, 4.3

master materialized view sites, 2.3.1

master sites, 2.2.1, 2.2.1, 2.2.2, 2.2.2, 2.2.3, 2.2.3

materialized view sites, 2.3.1

V

V$MVREFRESH view, 24

V$REPLPROP view, 10.6.7, 24

V$REPLQUEUE view, 24

VALIDATE procedure, 18

VARCHAR2_ARG procedure, 12

W

WAIT_MASTER_LOG procedure, 18

workflow, 6.5.1