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