Skip Headers

Oracle® Database Advanced Replication Management API Reference
10g Release 1 (10.1)

Part Number B10733-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
View PDF

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