Oracle8 Replication
Release 8.0

A58245-01

Library

Product

Contents

Prev

Index

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


A

accounts
creating for snapshots, 2-4
Add Objects to Group dialog
Replication Manager, 3-19
ADD procedure
DBMS_REFRESH package, 2-38
ADD_MASTER_DATABASE procedure
DBMS_REPCAT package, 3-25
adding
columns in column groups, 5-14
priority group members, 5-24
site priority group members, 5-29
sites
to an advanced replication environment, 7-8
additive prebuilt conflict resolution method, 5-16
Admin Requests folder, 6-5
Administration folder, 6-9, 6-11
administration requests, 1-19, 6-4 to 6-8
applying, 6-5
deleting, 6-6
diagnosing problems with, 6-8
displaying, 6-5
administrator
account
snapshot sites, 4-5, 4-7
administrator accounts
master sites, 3-5
advanced replication, 3-1 to 7-35
asynchronous propagation, 1-21
deferred transactions and, 1-22
disabling, 7-33
hybrid configurations, 1-16
job queues and, 1-22
multimaster, 3-1 to 3-35
multimaster configuration, 1-14
overview (see also "basic replication"), 1-12 to 1-30
procedural replication, 1-28
row-level replication, 1-20
RPCs and, 1-22
snapshot sites
offline instantiation of, 7-17
replication, 4-1 to 4-24
security setup, 7-24
synchronous propagation, 1-28, 7-6
techniques, 7-1 to 7-35
transaction propagation protection, 3-33 to 3-34
updatable snapshots, 1-15
uses for, 1-13
advanced replication systems
monitoring, 6-4
Alter Replication Object dialog
Replication Manager, 3-23
ALTER SNAPSHOT command
REFRESH clause, 2-44
ALTER SNAPSHOT LOG command, 2-28
ALTER_MASTER_REPOBJECT procedure
DBMS_REPCAT package, 3-23
ALTER_SNAPSHOT_PROPAGATION procedure
DBMS_REPCAT package, 4-16
altering
priority group members
priorities, 5-25
values, 5-25
priority levels, 9-91
propagation method, 9-87, 9-99
replicated objects, 9-89
site priority group members
priorities, 5-29
values, 5-30
snapshot definitions, 4-21
snapshots
required privileges, 2-36
alternate keys
detecting conflicts and, 1-26
in replicated tables, 3-20
AND expression
for simple subquery snapshots, 2-24
append sequences
conflict resolution methods, 5-34
append site names
conflict resolution methods, 5-34
assigning
update conflict resolution methods, 5-15
asynchronous
DDL, 9-141
replication, 1-21
RPCs, 8-3
auditing, 6-16
conflict resolution, 6-16
automatic conflict resolution
versus manual, 5-7
automatic refreshes
refresh group, 1-10
refresh interval, 1-10
average
conflict resolution method
use of, 5-38
average prebuilt conflict resolution method, 5-16

B

backups
for replication, 6-15
using multiple conflict resolution methods for, 5-11
basic replication, 1-2, 1-4 to 1-12, 2-1 to 2-44
configuring environment, 2-2 to 2-27
example, 2-2
designing environment, 2-2
environment
read-only snapshots, 2-34 to 2-37
managing environment, 2-27 to 2-44
monitoring environment, 2-44
privileges in, 2-5
SNP background processes for, 2-6
uses of, 1-4
Batch Size setting
Create New Scheduled Link property sheet, 3-10
BEGIN_INSTANTIATION procedure
DBMS_OFFLINE_OG package, 7-16
BEGIN_LOAD procedure
DBMS_OFFLINE_OG package, 7-17
BEGIN_TABLE_REORGANIZATION procedure
DBMS snapshot package, 2-31
BLOBs support, A-3
branch automation, A-2
bulk updates, 6-24

C

catalog, replication, 1-19
CHANGE procedure
DBMS_REFRESH package, 2-38
checking imported data, 6-15
circular dependencies in tables
restrictions on adding sites with to master groups, 3-25
CLOBs support, A-3
Cluster page
Create Snapshot property sheet, 2-15
clustering snapshots, 2-15
column groups, 1-26
adding members to
syntax, 9-75
and update conflict resolution, 5-7
creating
syntax, 9-119, 9-152
dropping, 5-14
syntax, 9-124
removing members from
syntax, 9-125
shadow, 1-27, 5-7
columns
adding and removing in column groups, 5-14
commands, SQL
ALTER SNAPSHOT LOG, 2-28
CREATE SNAPSHOT, 2-7, 2-10, 2-19 to 2-21
CREATE SNAPSHOT LOG, 2-7, 2-17
CREATE TABLE, 2-16
DROP SNAPSHOT, 2-36
DROP SNAPSHOT LOG, 2-33
TRUNCATE, 2-30
TRUNCATE TABLE, 2-31
comments
on Oracle documentation, vi
updating, 6-28
comments field
in views
updating, 6-28
comparing
tables, 9-55
complete refreshes, 1-9
complex snapshots, 1-11, 2-41
value for PCTFREE, 2-43
value for PCTUSED, 2-43
configuration
basic replication environment, 2-2 to 2-27
example, 2-2
Configuration folder, 3-29, 6-5
conflicts
additive resolution method, 5-16
avoidance
dynamic ownership, 7-27
avoiding, 5-4
column groups and, 1-26
data models and, 1-24
delete, 1-24, 5-3
avoiding, 5-5
detecting, 1-26, 5-5, 7-8
master sites, avoiding at, 5-5
detection
identifying rows during, 5-6
how Oracle detects, 5-6
maximum value conflict resolution method, 5-17
minimum value conflict resolution method, 5-17
notification
package, sample, 5-52
notification log
creating, 5-51
notification log table
sample, 5-51
notification methods
user-defined, 5-50
notification package
creating, 5-51
procedural replication, 1-28
replication, 1-24
resolution, 1-26
adding method of, 9-83
auditing, 6-16
automatic versus manual, 5-7
configuration
overview, 5-12
declarative methods, update conflicts, 5-16
delete, 5-8
strategy, 7-25
delete, configuring, 5-36
design and preparation guidelines, 5-12
detecting conflicts, 5-5
gathering statistics, 6-16
highest priority, 5-29
in synchronous propagation, 7-7
information
viewing, 5-54
methods, 1-27
procedural replication and, 7-3
RepResolution_Statistics table, deleting, 6-17
statistics, 9-101, 9-160
canceling, 6-17
uniqueness, 5-8
configuring, 5-33
update
and column groups, 5-7
user-defined routines
parameters, 5-46
user-defined routines, example, 5-49
user-defined routines, restrictions, 5-48
viewing information, 5-54
resolution and notification methods
custom, 5-10
resolution methods, 5-8
average prebuilt, 5-16
delete, assigning, 5-36
delete, removing, 5-36
discard, 5-19
managing, 5-15
multiple
using, 5-10
overwrite, 5-19
prebuilt, restrictions for, 5-9
uniqueness, assigning, 5-33
uniqueness, removing, 5-33
update
prebuilt, 5-8
user-defined, 5-46
using, for notification, 5-11
resolution methods for
removing, 5-15
resolution methods for column groups
ordering, 5-15
row-level replication, 1-26
uniqueness, 1-24, 5-3
avoiding, 5-5
update, 1-24, 5-3
avoiding, 5-5
update resolution
using site priority for, 5-28
connection qualifiers
master groups, 3-16
constraint violations, 6-24
continuous pushes
scheduling, 3-11, 3-13
Create, 3-5
Create Master Sites dialog
setup wizard, 3-24
Create New Master Group property sheet
Destinations page, 3-15
General page, 3-15
Objects page, 3-15
Replication Manager, 3-15
Create New Scheduled Link property sheet, 3-9
General page, 3-9
Options page, 3-9
Create Refresh Group property sheet
General page, 4-22
Next Date field, 2-26
Replication Manager, 4-3
Scheduling page, 4-22
Snapshots page, 4-22
Create Scheduled Link property sheet
setup wizard, 3-11, 3-13
CREATE SNAPSHOT command, 2-7, 2-10, 2-19 to 2-21
REFRESH clause, 2-44
CREATE SNAPSHOT LOG command, 2-17
Create Snapshot Log property sheet
Filter Columns page, 4-11
General page, 4-11
Options page, 2-8
Replication Manager, 4-3, 4-11
Storage page, 2-8
Tablespace and Extents page, 4-11
Create Snapshot property sheet
Cluster page, 2-15
Options page, 2-14
Storage page, 2-14
CREATE TABLE command, 2-16
CREATE_MASTER_REPGROUP procedure
DBMS_REPCAT package, 3-16
creating
basic replication environment, 2-2 to 2-27
example, 2-2
column groups
syntax, 9-119, 9-152
database links for snapshot, 2-2
deferred transactions, 8-3
master sites, 3-5
priority groups, 5-23, 9-120
refresh groups, 9-67
replicated object groups
syntax, 9-110
replicated objects
generating support for, 9-143, 9-144, 9-147
snapshot sites, 9-116
syntax, 9-111
site priority groups, 5-28
syntax, 9-122
snapshot logs, 2-3, 2-6
snapshot refresh groups, 2-3
snapshot sites
syntax, 9-114
snapshots, 2-3, 4-17
simple, 2-10
Customize Master Site property sheet
setup wizard, 3-7
Customize Snapshot Site property sheet
setup wizard, 4-8

D

data
convergence, 5-6
guaranteeing, 5-37
inconsistencies
removing after deleting master sites, 3-26
integrity
ensuring with multiple column groups, 5-7
parallel propagation, 3-34
serial propagation, 3-34
data cluster
creating snapshots as part of, 2-15
data definition language (DDL)
supplying asynchronous, 9-141
data dictionary
DBA_REGISTERED_SNAPSHOTS view, 2-35
data dictionary views, 10-2
DEFCALL, 10-20
DEFCALLDEST, 10-20
DEFDEFAULTDEST, 10-21
DEFERRCOUNT, 10-21
deferred transactions, 10-19
DEFERROR, 10-22
DEFLOB, 10-22
DEFPROPAGATOR, 10-23
DEFSCHEDULE, 10-23
DEFTRAN, 10-24
DEFTRANDEST, 10-24
REFRESH, 10-30
REFRESH_CHILDREN, 10-31
REGISTERED_SNAPSHOTS, 10-27
REPCATLOG, 10-5
REPCOLUMN, 10-6
REPCOLUMN_GROUP, 10-6
REPCONFLICT, 10-7
REPDDL, 10-7
REPGENERATED, 10-8
REPGENOBJECTS, 10-18
REPGROUP, 10-3
REPGROUPED_COLUMN, 10-9
REPKEY_COLUMNS, 10-9
REPOBJECT, 10-10
REPPARAMETER_COLUMN, 10-11
REPPRIORITY, 10-12
REPPRIORITY_GROUP, 10-13
REPPROP, 10-13
REPRESOL_STATS_CONTROL, 10-15
REPRESOLUTION, 10-14
REPRESOLUTION_METHOD, 10-15
REPRESOLUTION_STATISTICS, 10-16
REPSITES, 10-17
SNAPSHOT_REFRESH_TIMES, 10-29
SNAPSHOTS, 10-26
snapshots, 10-25
SNAPSHOTS_LOGS, 10-28
data manipulation language (DML)
minimizing propagation, 5-40
data ownership models, 1-24
dynamic ownership, 1-25
primary ownership, 1-25
shared ownership, 1-25
static ownership, 1-25
data propagation
and dependency maintenance, 3-33
minimizing, 3-28
minimizing for update conflict resolution, 5-40
mode of
altering in a master site, 7-10
reduced, A-2
synchronous, 7-6
data replication
real-time, 7-6
data requirements
evaluating and understanding, 5-2
data subsetting, A-2
data warehouse
basic replication for, 1-5
database
links
using different paths, 3-16
preparing for multimaster replication, 3-4
Database Link setting
Create New Scheduled Link property sheet, 3-9
database link specifications
incomplete, 6-25
database links, 6-22
creating for snapshot site, 2-2
snapshot sites, for, 2-5
database objects
for read-only snapshot, 1-7
Database Objects folder
master definition sites, 3-19
datatypes
allowed in replicated tables, 3-20
allowed in snapshots, 2-12, 4-18
support for, A-3
DBA_REFRESH view, 2-44
DBA_REFRESH_CHILDREN view, 2-44
DBA_REGISTERED_SNAPSHOTS view, 2-35, 2-44
DBA_RGROUP view, 2-44
DBA_SNAPSHOT_LOGS view, 2-35, 2-44
DBA_SNAPSHOTS view, 2-44
DBMS_DEFER package
ADD_DEFAULT_DEST procedure, 8-6
CALL procedure, 9-5
CHAR_ARG procedure, 8-5, 9-8
COMMIT_WORK procedure, 9-7
datatype_ARG procedure, 9-8
DATE_ARG procedure, 8-5, 9-8
NUMBER_ARG procedure, 8-5, 9-8
RAW_ARG procedure, 8-5, 9-8
ROWID_ARG procedure, 8-5, 9-8
TRANSACTION procedure, 8-4, 9-9
VARCHAR2_ARG procedure, 8-5, 9-8
DBMS_DEFER_QUERY package
GET_ARG_TYPE procedure, 9-12
GET_CALL_ARGS procedure, 9-14
GET_CHAR_ARG procedure, 9-16
GET_DATE_ARG procedure, 9-16
GET_NUMBER_ARG procedure, 9-16
GET_RAW_ARG procedure, 9-16
GET_ROWID_ARG procedure, 9-16
GET_VARCHAR2_ARG procedure, 9-16
DBMS_DEFER_SYS package
ADD_DEFAULT_DEST procedure, 9-19
DELETE_DEF_DESTINATION procedure, 9-21
DELETE_DEFAULT_DEST procedure, 8-6, 9-20
DELETE_ERROR procedure, 9-22
DELETE_TRAN procedure, 9-23
DISABLED function, 9-24
DISABLED procedure, 3-12
EXCLUDE_PUSH function, 9-25
EXECUTE_ERROR procedure, 9-26
PURGE procedure, 9-28
PUSH procedure, 9-31
REGISTER PROPAGATOR procedure, 9-34
SCHEDULE_EXECUTION procedure, 3-10, 3-11, 3-13, 3-14, 9-37
SCHEDULE_PURGE procedure, 9-35
SCHEDULE_PUSH procedure, 3-10, 3-11, 3-13, 3-14, 9-37
SET_DISABLED procedure, 3-11, 3-13, 3-14, 9-40
UNSCHEDULE_PURGE procedure, 9-42
UNSCHEDULE_PUSH procedure, 3-12, 9-43
DBMS_OFFLINE_OG package
BEGIN_INSTANTIATION procedure, 7-16, 9-45
BEGIN_LOAD procedure, 7-17, 9-46
END_INSTANTIATION procedure, 7-17, 9-47
END_LOAD procedure, 7-17, 9-48
RESUME_SUBSET_OF_MASTERS procedure, 7-16, 9-49
DBMS_OFFLINE_SNAPSHOT package
BEGIN_LOAD procedure, 9-51
END_LOAD procedure, 9-53
DBMS_RECTIFIER_DIFF package, 3-26, 6-17
DIFFERENCES procedure, 9-55
RECTIFY procedure, 9-59
DBMS_REFRESH package
ADD procedure, 2-38, 9-63
CHANGE procedure, 2-38, 9-64
DESTROY procedure, 2-38, 9-66
MAKE procedure, 4-22, 9-67
REFRESH procedure, 2-39, 9-70
SUBTRACT procedure, 2-38, 9-71
DBMS_REPCAT package, 6-6
ADD_DELETE_RESOLUTION procedure, 9-83
ADD_GROUPED_COLUMN procedure, 9-75
ADD_MASTER_DATABASE procedure, 3-25, 9-77
ADD_PRIORITY_CHAR procedure, 5-24, 9-79
ADD_PRIORITY_DATE procedure, 5-24, 9-79
ADD_PRIORITY_NUMBER procedure, 5-24, 9-79
ADD_PRIORITY_RAW procedure, 5-24, 9-79
ADD_PRIORITY_VARCHAR2 procedure, 5-24, 9-79
ADD_SITE_PRIORITY_SITE procedure, 5-29, 9-81
ADD_UNIQUE_RESOLUTION procedure, 9-83
ADD_UPDATE_RESOLUTION procedure, 9-83
ALTER_MASTER_PROPAGATION procedure, 9-87
ALTER_MASTER_REPOBJECT procedure, 3-23, 9-89
ALTER_PRIORITY procedure, 5-25, 9-91
ALTER_PRIORITY_CHAR procedure, 5-25, 9-93
ALTER_PRIORITY_DATE procedure, 5-25, 9-93
ALTER_PRIORITY_NUMBER procedure, 5-25, 9-93
ALTER_PRIORITY_RAW procedure, 5-25, 9-93
ALTER_PRIORITY_VARCHAR2 procedure, 5-25, 9-93
ALTER_SITE_PRIORITY procedure, 5-29, 9-95
ALTER_SITE_PRIORITY_SITE procedure, 5-30, 9-97
ALTER_SNAPSHOT_PROPAGATION procedure, 9-99
CANCEL_STATISTICS procedure, 6-17, 9-101
COMMENT_ON_COLUMN_GROUP procedure, 6-28, 9-102
COMMENT_ON_DELETE resolution package, 6-28
COMMENT_ON_DELETE_RESOLUTION procedure, 9-108
COMMENT_ON_PRIORITY_GROUP procedure, 6-28, 9-103
COMMENT_ON_REPCAT procedure, 6-28
COMMENT_ON_REPGROUP procedure, 9-105
COMMENT_ON_REPOBJECT procedure, 6-28, 9-107
COMMENT_ON_REPSCHEMA procedure, 6-28
COMMENT_ON_REPSITES procedure, 9-106
COMMENT_ON_SITE_PRIORITY procedure, 9-103
COMMENT_ON_UNIQUE resolution package, 6-28
COMMENT_ON_UNIQUE_RESOLUTION procedure, 9-108
COMMENT_ON_UPDATE resolution package, 6-28
COMMENT_ON_UPDATE_RESOLUTION procedure, 9-108
CREATE_MASTER_REPGROUP procedure, 3-16, 9-110
CREATE_MASTER_REPOBJECT procedure, 9-111
CREATE_SNAPSHOT_REPGROUP procedure, 9-114
CREATE_SNAPSHOT_REPOBJECT procedure, 9-116
DEFINE_COLUMN_GROUP procedure, 9-119
DEFINE_PRIORITY_GROUP procedure, 5-23, 9-120
DEFINE_SITE_PRIORITY procedure, 5-28, 9-122
DO_DEFERRED_REPCAT_ADMIN procedure, 6-5, 6-6 to 6-7, 9-123
DROP_COLUMN_GROUP procedure, 9-124
DROP_GROUPED_COLUMN procedure, 9-125
DROP_MASTER_REPGROUP procedure, 3-17, 9-127
DROP_MASTER_REPOBJECT procedure, 3-24, 9-129
DROP_PRIORITY procedure, 5-27, 9-131
DROP_PRIORITY_CHAR procedure, 5-26, 9-133
DROP_PRIORITY_DATE procedure, 5-26, 9-133
DROP_PRIORITY_GROUP procedure, 5-27, 9-132
DROP_PRIORITY_NUMBER procedure, 5-26, 9-133
DROP_PRIORITY_RAW procedure, 5-26, 9-133
DROP_PRIORITY_VARCHAR2 procedure, 5-26, 9-133
DROP_SITE_PRIORITY procedure, 5-30, 9-135
DROP_SITE_PRIORITY_SITE procedure, 5-30, 9-136
DROP_SNAPSHOT_REPGROUP procedure, 9-137
DROP_SNAPSHOT_REPOBJECT procedure, 4-21, 9-138
EXECUTE_DDL procedure, 6-2, 9-141
GENERATE_REPLICATION_PACKAGE procedure, 9-143
GENERATE_REPLICATION_SUPPORT procedure, 3-28, 9-144
GENERATE_REPLICATION_TRIGGER procedure, 9-147
GENERATE_SNAPSHOT_SUPPORT, 9-150
MAKE_COLUMN_GROUP procedure, 9-152
PURGE_MASTER_LOG procedure, 9-154
PURGE_STATISTICS procedure, 6-17, 9-155
REFRESH_SNAPSHOT_REPGROUP procedure, 9-156
REGISTER_STATISTICS procedure, 6-16, 9-160
RELOCATE_MASTERDEF procedure, 6-3, 9-161
REMOVE_MASTER_DATABASES procedure, 3-25, 9-163
REPCAT_IMPORT_CHECK procedure, 6-15, 9-165
RESUME_MASTER_ACTIVITY procedure, 3-19, 9-166
SET_COLUMNS procedure, 3-20, 9-169
SUSPEND_MASTER_ACTIVITY procedure, 3-18, 9-171
SWITCH_SNAPSHOT_MASTER procedure, 4-16, 6-3, 9-172
VALIDATE procedure, 9-174
WAIT_MASTER_LOG procedure, 9-177
DBMS_REPCAT_ADMIN package
GRANT_ADMIN_ANY_SCHEMA procedure, 9-179
GRANT_ADMIN_SCHEMA procedure, 9-180
REVOKE_ADMIN_ANY_SCHEMA procedure, 9-181
REVOKE_ADMIN_SCHEMA procedure, 9-182
DBMS_REPCAT_AUTH package
GRANT_SURROGATE_REPCAT procedure, 9-184
REVOKE_SURROGATE_REPCAT procedure, 9-185
DBMS_REPUTIL package
FROM_REMOTE variable, 9-201
GLOBAL_NAME variable, 9-201
REPLICATION_IS_ON variable, 9-201
REPLICATION_OFF procedure, 7-33, 9-187
REPLICATION_ON procedure, 7-34, 9-188
DBMS_SNAPSHOT package
BEGIN_TABLE_REORGANIZATION procedure, 2-31, 9-190
END_TABLE_REORGANIZATION procedure, 2-31, 9-191
I_AM_A_REFRESH function, 9-192
PURGE_LOG procedure, 2-29, 9-193
REFRESH procedure, 9-194
REGISTER_SNAPSHOT procedure, 2-36, 9-197
SET_I_AM_A_REFRESH procedure, 9-199
UNREGISTER_SNAPSHOT, 9-200
UNREGISTER_SNAPSHOT procedure, 2-36
DDL
changes not propagated to master site, 6-23
executing within a master group, 6-2
propagating statements to master sites, 6-2
deadlocks
resolving
in synchronous propagation, 7-7
decision support application
basic replication for, 1-5
DEFCALL view, 10-20
DefDefaultDest table
adding destinations to, 8-6, 9-19
removing destinations from, 8-6, 9-20, 9-21
DEFDEFAULTDEST view, 10-21
DEFERRCOUNT view, 10-21
deferred constraints and updatable snapshots, A-4
deferred RPCs, 8-3
deferred transactions, 1-22
creating, 8-3
DefCall table, 8-5
DefCallDest table, 8-5
DEFCALLDEST view, 10-20
DefDefaultDest table
adding destination to, 8-6, 9-19
removing destinations from, 8-6, 9-20, 9-21
DEFDEFAULTDEST view, 10-21
deferred remote procedure calls (RPCs)
argument types, 9-12
argument values, 9-16
arguments to, 8-5, 9-8
building, 8-5, 9-5
executing immediately, 9-31
DEFERROR view, 10-22
DefTran table, 8-4
DEFTRAN view, 10-24
DEFTRANDEST view, 10-24
deleting, 6-10
diagnosing problems with, 6-25
displaying, 6-9
executing, 6-9
managing, 6-8
purging, 3-12
queue
clearing after deleting master sites, 3-26
purging, 1-23, 3-14
push, 1-22
re-executing, 9-26
removing from queue, 9-23
scheduling execution, 9-37
starting, 8-4, 9-9
views for, 10-19 to 10-24
Deferred Transactions by Dest folder, 6-9
DefError table
deleting transactions from, 9-22
DEFERROR view, 10-22
defining query
snapshots, 1-7, 2-12
definition sites
relocating for a master group, 6-3
DEFLOB, 10-22
DEFSCHEDULE, 10-23
DEFTRAN, 10-24
DEFTRANDEST view, 10-24
delay seconds
setup wizard, 3-13
Delay Seconds setting
Create New Scheduled Link property sheet, 3-10
delete conflicts, 1-24, 5-3
avoiding, 5-5, 7-25
resolution, 5-8
configuring, 5-36
methods, assigning, 5-36
resolution methods
removing, 5-36
resolving, 5-48
deleting
master groups, 3-17
scheduled links, 3-12
snapshot logs, 4-12
snapshots, 4-21
dependency
ordering
replicated transactions, 3-33
tracking
parallel propagation, 3-34
Destination Map folder, 3-29
destination maps
displaying for master groups, 3-29
destination master sites
adding to master groups, 3-15, 3-25
Destinations page
Create New Master Group property sheet, 3-15
Edit Master Group property sheet, 3-25, 6-3
DESTROY procedure
DBMS_REFRESH package, 2-38
detecting conflicts, 5-5, 5-6
diagnosing problems with, 6-22
DIFFERENCES
procedure, 6-17
differences
between tables, 9-55
rectifying, 9-59
DISABLED procedure
DBMS_DEFER_SYS package, 3-12
disabling
propagation, 9-40
disabling replication, 7-32
discard
conflict resolution method, 5-19
use of, 5-38
discard uniqueness
conflict resolution method, 5-35
disconnected environments
as in advanced replication, 1-13
distributed transactions
problems with, 6-25
distributing application loads
as in advanced replication, 1-13
DML
changes not propagated to other sites, 6-23
DO_DEFERRED_REPCAT_ADMIN package, 6-6
DO_DEFERRED_REPCAT_ADMIN procedure
DBMS_REPCAT package, 6-5, 6-6 to 6-7
DROP SNAPSHOT command, 2-36
DROP SNAPSHOT LOG command, 2-33
DROP_MASTER_REPGROUP procedure
DBMS_REPCAT package, 3-17
DROP_MASTER_REPOBJECT procedure
DBMS_REPCAT package, 3-24
DROP_SNAPSHOT_REPOBJECT procedure
DBMS_REPCAT package, 4-21
dropping
column groups, 5-14
syntax, 9-124
master sites, 9-163
priority group members
by priority, 5-27
by value, 5-26
priority groups, 5-27, 9-132
replicated objects
from master sites
syntax, 9-129
from snapshot sites
syntax, 9-138
groups of, 9-127
site priority groups, 5-30, 9-135
members of, 5-30
sites
by priority level, 5-30
snapshot logs, 2-33
snapshot sites, 9-137
snapshots, 2-36
dynamic ownership, 1-25
conflict avoidance and, 7-27
workflow partitioning, 7-27
dynamic sites
ownership, 5-4

E

earliest and latest timestamp
conflict resolution methods, 5-18
Edit Database Destination property sheet
Replication Manager, 3-30
Edit DB Connection property sheet
Replication Manager, 3-14
setup wizard, 3-13
Edit Master Group property sheet
Destinations page, 3-25, 6-3
Operations page, 3-18, 3-28
Replication Manager, 3-18, 3-19
setup wizard, 3-25
Edit Replication Object property sheet
General page, 3-23, 3-27, 4-20
Min(imize) Communications setting, 3-28
Edit Scheduled Link property sheet
Replication Manager, 3-11
setup wizard, 3-11
Edit Snapshot Log property sheet
Filter Columns page, 4-11
General page, 4-11
Replication Manager, 4-11
Tablespace and Extents page, 4-11
Edit Snapshot property sheet
Tablespace and Extents page, 4-20
Enabled setting
Create New Scheduled Link property sheet, 3-9
enabling replication, 7-32
END_INSTANTIATION procedure
DBMS_OFFLINE_OG package, 7-17
END_LOAD procedure
DBMS_OFFLINE_OG package, 7-17
END_TABLE_REORGANIZATION procedure
DBMS_SNAPSHOT package, 2-31
enhancements
new features, A-2
error
transactions
managing, 6-10
errors
avoid with VALIDATE, A-4
transactions
displaying, 6-11
resolving, 6-11
examples
minimizing
communication, 5-41
Execute DDL dialog
Replication Manager, 6-2
EXECUTE_DDL procedure
DBMS_REPCAT package, 6-2
EXIST clause
for simple subquery snapshots, 2-24
Export utility
offline instantiation of master site, 7-16

F

fail-over sites
implementing, 7-14
failover sites
as in advanced replication, 1-13
failure, media
recovering read-only snapshots from, 2-37
fast refreshes, 1-9
and table reorg, A-4
snapshot requirements for, 2-17
features requiring migration, B-11
Feedback
on ORACLE documentation, vi
filter columns
for simple subquery snapshots, 2-9, 2-24
Filter Columns page
Create Snapshot Log property sheet, 4-11
Edit Snapshot Log property sheet, 4-11
fine grained quiesce, A-3
Finish page
Replication Manager, 3-7
setup wizard, 3-7

G

gen_rep_pack, 5-22
General page
Create New Master Group property sheet, 3-15
Create Snapshot Log property sheet, 4-11
Edit Replication Object property sheet, 3-27, 4-20
Edit Snapshot Log property sheet, 4-11
Snapshot Log property sheet, 2-35
GENERATE_REPLICATION_SUPPORT procedure
DBMS_REPCAT package, 3-28
generated objects
displaying for master groups, 3-30
Generated Objects folder, 3-30
generated replication objects
wrapper package, 1-20
generating
replication support
procedural replication, 7-3
replication support and migration, B-3
snapshot support, 9-150
generating replication support
migration and, B-8

H

hybrid configurations
advanced replication, 1-16

I

identity columns
detecting conflicts and, 1-26
Import utility
offline instantiation of master site, 7-17
import_check, 6-15
importing
object groups
offline instantiation and, 9-46, 9-48
snapshots
offline instantiation and, 9-51, 9-53
status check, 9-165
in basic replication, 1-5
incremental migration, B-4
indexes
partitioned tables and, A-4
snapshots, 2-40
information
consolidation
advanced replication and, 1-15
distribution
in basic replication, 1-4
off-loading
in basic replication, 1-5
transport, 1-5
information distribution
basic replication for, 1-4
initialization parameters
JOB_QUEUE_INTERVAL, 2-6, 4-10, 6-6
JOB_QUEUE_PROCESSES, 2-6, 4-10, 6-6
PARALLEL_MAX_SERVERS, 3-32
PARALLEL_MIN_SERVERS, 3-32
PARALLEL_SERVER_IDLE_TIME, 3-32
INIT.ORA, 3-17
instantiation
offline, 7-14
in advanced replication, 7-17
of an advanced replication master site, 7-16
instantiation offline, A-4
internal snapshot objects, 1-7
internal triggers, A-2
intersection tables, 2-20 to 2-23
Interval Expression setting
Create New Scheduled Link property sheet, 3-9
Setup wizard, 3-12

J

job queue process, 3-8, 4-10
job queues, 1-22
JOB_QUEUE_INTERVAL initialization parameters, 2-6, 4-10, 6-6
JOB_QUEUE_PROCESSES initialization parameters, 2-6, 4-10, 6-6
jobs
breaking, 6-14
checking for scheduled links, 6-25
diagnosing problems with, 6-14
enabling, 6-14
local
displaying, 6-12
editing properties of, 6-13
manually executing, 6-14
queues for
removing jobs from, 9-42 to 9-43
joins
for simple subquery snapshots, 2-24

L

large object types
allowed in replicated tables, 3-20
latest timestamp
conflict resolution method, 5-18
link specifications
incomplete, 6-25
LOBs
omitting old values for, 5-40
support for, A-3
Local Errors folder, 6-11
local jobs
displaying, 6-12
editing properties of, 6-13

M

MAKE procedure
DBMS_REFRESH package, 2-26, 4-22
NEXT_DATE parameter, 2-26
management
basic replication environment, 2-27 to 2-44
management and use new features, A-3
management of master and snapshot groups
advanced, 6-2
managing update conflict resolution, 5-15
manual conflict resolution
versus automatic, 5-7
manual refreshes, 1-11
many-to-many references
simple subquery snapshots, 2-23
many-to-one references
simple subquery snapshots, 2-23
mass deployment, A-2
master and snapshot groups
advanced management of, 6-2
master definition sites, 1-19
relocating, 6-3, 9-161
master groups, 1-18
adding destination master sites, 3-24, 3-25
adding replication objects, 3-15, 3-19
adding sites with tables having circular dependencies, 3-25
adding sites with tables having self-referential constraints, 3-25
administration requests
deleting, 6-6
altering object definition, 3-23
applying administration requests for, 6-5
choosing, for snapshot groups, 4-4
connection qualifiers, 3-16
creating, 3-15
definition sites for
relocating, 6-3
deleting, 3-17
deleting master sites from, 3-25
destination master sites, 3-15
displaying destination maps for, 3-29
displaying generated objects, 3-30
executing DDL within, 6-2
generating replication support for changes, 3-26
listing, 3-29
listing objects in, 3-29
managing, 3-15 to 3-30
objects
generating support for, 3-27
propagating DDL to sites in, 6-2
relocating master definition sites, 6-3
removing replication objects, 3-24
resuming replication activity, 3-19
suspending replication activity, 3-17
validating, 6-2
viewing information about, 3-29
Master Groups folder, 3-29, 6-5
master sites, 1-18
adding to master groups, 3-24
administrator accounts, 3-5
choosing, for snapshot groups, 4-4
creating, 9-77
creating, for multimaster replication, 3-5
customizing settings, 3-7
default propagation characteristics, 3-6
deleting from master groups, 3-25
determining differences, 6-17
diagnosing problems with, 6-22
dropping, 9-163
fine grained quiesce, A-3
incremental migration of, B-6
manually loading table data from, 3-22
master groups
managing, 3-15 to 3-30
minimizing data propagation, 3-28
offline instantiation, 7-16 to 7-17
propagating changes between, 9-37
propagator accounts, 3-5
receiver accounts, 3-5
replicating data to, 3-22
replicating object definitions to, 3-21
manual, 3-21
scheduled links for, 3-9
guidelines, 3-10
scheduled purges for
guidelines, 3-13
schema creation for, 3-6
snapshot registration, A-3
specifying for snapshot sites, 4-6
master sites and migration, B-2
master table
columns
number restriction for simple subquery snapshots, 2-24
datatypes allowed in, 2-12
dropping, 2-36
PRIMARY KEY constraint for snapshot, 2-12
reorganizing, 2-30
requirements for primary key snapshots, 2-8
master tables
reorganizing
methods, 2-31 to 2-33
snapshot logs, 1-9
snapshot logs for, 2-6
truncating, 2-31
maximum value conflict resolution method, 5-17
media failure
recovery
read-only snapshots, 2-37
members
altering priority for, 5-25
migration
features requiring, B-11
incremental, B-4
master sites, B-2
obsolete procedures, B-12
overview, B-2
snapshot sites, B-5
upgrading to primary key snapshots, B-10
using import and export, B-9
Min(imize) Communications setting
Edit Replication Object property sheet, 3-28
min_communication
examples of, 5-41
Minimize Communication setting
Replication Manager, 4-19
minimizing
updates and min_communication, 5-41
minimum value conflict resolution method, 5-17
mode of propagation, 7-8
modifying
tables
without replicating changes, 7-32
monitoring
environment in basic replication, 2-44
multimaster replication, 1-14
advanced options, 3-31 to 3-35
building environment, 3-1 to 3-3
example, 3-2
creating
master groups, 3-15
customizing master site settings, 3-7
database preparation, 3-4
local job queues, 6-12
master site creation, 3-5
monitoring system, 3-29 to 3-30
monitoring systems, 6-4 to 6-15
reviewing configuration settings, 3-7
scheduled links, 3-9
schema creation for, 3-6
security for, 7-18
setup wizard, 3-4
transaction propagation protection, 3-33 to 3-34
multiple column groups
ensuring data integrity with, 5-7
multiple conflicts
resolution methods
for backups, 5-11
using, 5-10
using for notification, 5-11

N

naming
snapshots, 2-11
NCLOB support, A-3
new features
data subsetting and subqueries, A-2
enhanced security, A-4
for management and use, A-3
LOB support, A-3
performance, A-2
subqueries for snapshots, A-2
subquery snapshots, A-2
New Master Site dialog
setup wizard, 3-5
New Replicated Object Schema dialog
setup wizard, 3-6
New Snapshot Site dialog
setup wizard, 4-6
Next Date field
Create Refresh Group property sheet, 2-26
Next Date setting
Create New Scheduled Link property sheet, 3-9
Setup wizard, 3-12
NEXT_DATE parameter
DBMS_REFRESH package
MAKE procedure, 2-26
notification
methods
custom, for conflict resolution, 5-10
using multiple conflict resolution methods for, 5-11
notification log
conflict
creating, 5-51
notification log table
conflict
sample, 5-51
notification methods
user-defined, 5-50
notification package
conflict
creating, 5-51

O

objects
altering in a master group, 3-23
definitions
replication to master sites, 3-21
master groups
generating support for, 3-27
removing from master groups, 3-24
replicated
re-creating, 6-24
Objects page
Create New Master Group property sheet, 3-15
obsolete procedures, B-12
offline instantiation, 3-22
master sites, 7-16 to 7-17
replicated object groups, 9-45, 9-46, 9-47, 9-48, 9-49
snapshots, 9-51, 9-53
support for, A-4
OPEN_LINKS initialization parameters
initialization parameters
OPEN_LINK, 3-17
Operations page
Edit Master Group property sheet, 3-18, 3-28, 6-2
Options page, 2-28
Create Snapshot property sheet, 2-14
Oracle Replication Manager, 1-18
Oracle7
and min_communication, 4-19
Oracle8
features and migration, B-11
ordering
conflict resolution methods for column groups, 5-15
ordering conflicts
avoiding, 5-38
overwrite
conflict resolution method
use of, 5-38
conflict resolution methods, 5-19

P

package variables
from_remote, 9-201
global_name, 9-201
i_am_a_refresh, 9-192
i_am_a_snapshot, 9-201
replication_is_on, 9-201
parallel propagation, 1-22, A-2
advanced replication environment, 3-31 to 3-32
dependency
tracking, 3-34
planning for, 3-31
Parallel Propagation setting
Create New Scheduled Link property sheet, 3-10
parallel server processes
configuring for advanced replication environments, 3-32
PARALLEL_MAX_SERVERS initialization parameters, 3-32
PARALLEL_MIN_SERVERS initialization parameters, 3-32
PARALLEL_SERVER_IDLE_TIME initialization parameters, 3-32
partitioned tables
indexes and, A-4
partitions
replication and, 3-21
PCTFREE
value for complex snapshots, 2-43
value for snapshot log, 2-9
PCTUSED
value for complex snapshots, 2-43
value for snapshot log, 2-9
performance enhancements, A-2
performance tuning
simple subquery snapshots, 2-41
snapshots, 2-40
periodic purges
scheduling, 3-14
periodic pushes
scheduling, 3-11
pgroup, 5-22
PL/SQL triggers
using with snapshot base tables, 4-21
prebuilt conflicts
resolution methods
restrictions for, 5-9
prebuilt uniqueness conflicts
resolution methods, 5-9
prebuilt update conflict resolution methods, 5-16
prebuilt update conflicts
resolution methods, 5-8
preface
Send Us Your Comments, xxiii
preparing for, 2-4
PRESERVE SNAPSHOT LOG option
TRUNCATE TABLE command, 2-31
PRIMARY KEY constraint
simple subquery snapshots and, 2-23
snapshot requirement for, 2-12
primary key snapshots, 1-12, A-3
requirements for creating log, 2-8
primary keys
missing from replicated tables, 3-16
upgrading snapshots, B-10
primary ownership, 1-25
primary sites
ownership, 5-4
priority group members
dropping, 5-27
dropping by value, 5-26
priority groups, 5-22
adding members to, 5-24, 9-79
altering members
priorities, 5-25, 9-91
values, 5-25, 9-93
and site priority, 5-20
creating, 5-23, 9-120
dropping, 5-27, 9-132
dropping members
by priority, 5-27
by value, 5-26
removing members from, 9-131, 9-133
site priority groups
adding members to, 9-81
using for conflict resolution, 5-22
priority level of sites
altering, 5-29
priority_groups, 5-20
privileges
altering snapshots, 2-36
basic replication environment, 2-3, 2-5
deleting rows from snapshot logs, 2-30
dropping snapshots, 2-37
snapshot creation, 2-11
snapshot log creation, 2-8
procedural replication, 1-28
conflicts and, 7-3
deleting and, 7-25
detecting conflicts, 1-28
generating support for, 7-3
restrictions, 7-2
using, 7-2
wrapper, 1-28
Processes setting
Create New Scheduled Link property sheet, 3-10
propagating changes
altering propagation method, 9-99
propagation
disabling, 9-40
minimizing data, 5-40
mode of, 7-8
altering in a master site, 7-10
of changes
altering propagation method, 9-87
parallel, 1-22, A-2
security context of propagator, 7-6
serial, 1-22
setting default characteristics, 3-6
status of, 9-24
propagation reduction, A-2
propagator, 1-24
account
snapshot sites, 4-5, 4-7
registering, 9-34
propagator accounts
master sites, 3-5
PURGE SNAPSHOT LOG option
TRUNCATE TABLE command, 2-31
PURGE_LOG procedure
DBMS_SNAPSHOT package, 2-29
purges
manual, 3-14
periodic
scheduling, 3-14, 4-8
purging
deferred transaction queue, 3-12
RepCatLog table, 9-154
snapshot logs, 2-29
statistics, 9-155
pushes
continuous
scheduling, 3-11, 3-13
periodic
scheduling, 3-11

Q

query defining
for snapshots, 2-12
queue
deferred transactions, 1-22
quiescing
and fine grained quiesce, A-3
master groups, 3-17
replicated schemas, 9-171

R

read-only replication, 1-2, 1-4 to 1-8
uses of, 1-4
read-only snapshots, 1-6
altering
privileges required, 2-36
base table, 1-7
dropping, 2-36
index, 1-8
managing, 2-34 to 2-37
privileges required to query, 2-34
recovery from media failure, 2-37
refresh types, 1-11
registration, 2-35
manual, 2-36
unregistering, 2-36
using, 2-34
view, 1-8
real-time
data replication, 1-29
replication, 1-28, 7-6
receiver, 1-24
accounts
master sites, 3-5
recovery, 6-15
for replication, 6-15
RECTIFY
procedure, 6-18
rectifying
tables, 6-18, 9-59
re-enabling
advanced replication, 7-34
refresh
failures, 2-39
fast and table reorg, A-4
retries, 2-39
snapshot sites
syntax, 9-156
snapshots, 9-194
REFRESH clause
ALTER SNAPSHOT command, 2-44
CREATE SNAPSHOT command, 2-44
refresh groups, 1-10
adding members, 2-38
adding members to, 9-63
adding snapshots, 4-22
altering settings, 2-38
automatic refreshes, 1-10
creating, 2-3, 2-24, 4-3
for snapshot sites, 4-22
creating new, 9-67
data dictionary views, 10-25
deleting, 2-38, 9-66
deleting members, 2-38
designing, 2-5
listing group members, 10-31
managing, 2-5 to 2-40
manual refresh, 1-11, 2-39
refresh interval, 2-26
changing, 9-64
REFRESH view, 10-30
REFRESH_CHILDREN view, 10-31
refreshing
manually, 9-70
removing members from, 9-71
settings
next date, 2-26
snapshots, 4-22
troubleshooting refresh, 2-39
refresh intervals
listing, 10-30
parameter constraints, 1-10
REFRESH view, 10-30
snapshot refresh groups, 1-10
REFRESH procedure
DBMS_REFRESH package, 2-39
refresh settings
snapshots, 2-12
refresh types
default, 1-11
manual, 1-11
read-only snapshots, 1-11
snapshot, 2-27
REFRESH view, 10-30
refresh, planning for, 2-5
REFRESH_CHILDREN view, 10-31
refreshes
snapshot, 4-9
REGISTER_SNAPSHOT procedure
DBMS_SNAPSHOT package, 2-36
REGISTERED_SNAPSHOTS, 10-27
registering
propagator for local database, 9-34
snapshots, A-3
RELOCATE_MASTERDEF procedure
DBMS_REPCAT package, 6-3
remote data
referencing for snapshots, 2-13
remote procedure calls, 1-22
deferring, 8-5
REMOVE_MASTER_DATABASES procedure
DBMS_REPCAT package, 3-25
removing
columns in column groups, 5-14
conflict resolution methods, 5-15
RepCat table
updating, 6-28
REPCATLOG view, 3-30, 6-6 to 6-7, 10-5
RepCatLog view
purging, 9-154
REPCOLUMN view, 10-6
RepColumn_Group table
updating, 6-28, 9-102
REPCOLUMN_GROUP view, 10-6
REPCONFLICT view, 10-7
REPDDL view, 10-7
REPGENOBJECTS view, 10-18
REPGERATED view, 10-8
REPGROUP view, 3-30, 10-3
RepGroup view
updating, 9-105
REPGROUPED_COLUMN view, 10-9
REPKEY_COLUMNS view, 10-9
replicated environment
determining differences in tables, 6-17
replicated object groups
dropping, 9-127
offline instantiation of, 9-45, 9-46, 9-47, 9-48, 9-49
replicated objects
altering, 9-89
at snapshot sites
problems creating, 6-26
creating
master sites, 9-111
snapshot sites, 9-116
DROP_MASTER_REPOBJECT and, 9-129
dropping
snapshot site, 9-138
generating support for, 9-143, 9-144, 9-147
groups
creating
master sites, 9-110
re-creating, 6-24
replicated procedures
generating support for, 7-3
replicated tables
alternate keys for, 3-20
and DML incompatibility, 6-24
datatypes allowed, 3-20
differences between, 6-17
populating manually, 3-22
replicated transactions
dependency ordering, 3-33
replication
administrator, 1-23
advanced
introduction to conflicts, 5-2
re-enabling, 7-34
advanced techniques, 7-1 to 7-35
advanced, uses for, 1-13
backup and recovery for, 6-15
basic, 1-2, 1-4 to 1-12, 2-1 to 2-44
catalog, 1-19
catalog views, 10-2
conflicts, 1-24
avoiding, 1-26
column groups, 1-26
data models and, 1-24
detecting, 1-26
procedural replication, 1-28
resolution methods, 1-27
resolving, 1-26
row-level replication, 1-26
definition, 1-2
disabling, 7-32, 7-33
enabling, 7-32
environment
advanced
adding new sites to, 7-8
group, 1-18
multimaster, 3-1 to 3-35
advanced options, 3-31 to 3-35
building environment
example, 3-2
monitoring, 3-29 to 3-30, 6-4 to 6-15
objects
generated, 1-20
of object definitions to master sites, 3-21
manual, 3-21
off/on affects current session, 7-33
procedural, 1-28
propagator, 1-24
real-time, 1-28, 7-6
receiver, 1-24
resuming for master groups, 3-19
sites, 1-18
suspending for master groups, 3-17
triggers, 7-34
uses of read-only, 1-4
replication catalog view
incorrect, 6-25
replication groups
master sites
managing, 3-15 to 3-30
replication management API, 1-19, 9-1
Replication Manager, 1-18
Add Objects to Group dialog, 3-19
administration requests, 6-4 to 6-8
Alter Replication Object dialog, 3-23
Create New Master Group property sheet, 3-15
Create New Scheduled Link property sheet, 3-9
Create Refresh Group property sheet, 4-3
Create Snapshot Log property sheet, 4-11
Edit Database Destination property sheet, 3-30
Edit Master Group property sheet, 3-18, 3-19
Edit Replication Object property sheet, 3-23
Edit Snapshot Log property sheet, 4-11
Execute DDL dialog, 6-2
Finish page, 3-7
Scheduled Links folder, 3-12
Scheduling folder, 3-12
Set Alternate Key Columns dialog, 3-16, 3-20
Set Date dialog, 3-9, 3-12
Set Interval dialog, 3-9, 3-12
Set Scheduled Link dialog, 3-9
setup wizard, 3-4
replication objects, 1-18
adding to master groups, 3-15, 3-19
altering definition, 3-23
deleting from master groups, 3-24
replication support
for tables
unable to generate, 6-24
generating for all master group tables, 3-28
generating for master groups, 3-26
generation for objects, 3-27
replication tables
updating Comments, 6-28
replication triggers, A-2
RepObject table
updating, 6-28, 9-107
REPOBJECT view, 3-30, 10-10
REPPARAMETER_COLUMN view, 10-11
REPPRIORITY view, 10-12
RepPriority_Group table
updating, 6-28, 9-103
REPPRIORITY_GROUP view, 10-13
REPPROP view, 10-13
REPRESOL_STATS_CONTROL view, 10-15
RepResolution table
updating, 6-28, 9-108
REPRESOLUTION view, 10-14
REPRESOLUTION_METHOD view, 10-15
RepResolution_Statistics table
purging, 6-17, 9-155
REPRESOLUTION_STATISTICS view, 10-16
RepResolution_Statistics view
gathering statistics, 6-16
RepSchema table
updating, 6-28
RepSite view
updating, 9-106
REPSITES view, 3-30, 10-17
resolution methods
additive prebuilt, 5-16
average prebuilt, 5-16
discard, 5-19
earliest timestamp, 5-18
for column groups
ordering, 5-15
for conflicts
removing, 5-15
latest timestamp, 5-18
managing, 5-15
maximum value method, 5-17
minimum value method, 5-17
overwrite, 5-19
resolution statistics
gathering, 6-16
viewing, 6-16
restrictions
procedural replication, 7-2
RESUME_MASTER_ACTIVITY procedure
DBMS_REPCAT package, 3-19
RESUME_SUBSET_OF_MASTERS procedure
DBMS_OFFLINE_OG package, 7-16
resuming replication activity, 9-166
rollback segments
setting for snapshot, 2-27
setup wizard, 3-12
ROWID snapshots, 1-12, 2-43
row-level replication, 1-20
detecting conflicts, 1-26, 5-5
rows
identifying during conflict detection, 5-6
RPC, 1-22

S

SCHEDULE_EXECUTION procedure
DBMS_DEFER_SYS package, 3-10, 3-11, 3-13, 3-14
SCHEDULE_PUSH procedure
DBMS_DEFER_SYS package, 3-10, 3-11, 3-13, 3-14
scheduled links
continuous pushes, 3-11, 3-13
creating, 3-9
snapshot site, 4-7
database link to use, 3-9
deleting, 3-12
editing, 3-11
guidelines, 3-10
managing, 3-9
number of background processes used, 3-10
parallel propagation, 3-10, 3-31 to 3-32
periodic pushes, 3-11
serial propagation, 3-10, 3-31
viewing status, 3-12
Scheduled Links folder
Replication Manager, 3-12
scheduled purges
editing, 3-14
guidelines, 3-13
periodic purges, 3-14
Scheduling folder
Replication Manager, 3-12
Scheduling page
Create Refresh Group property sheet, 4-22
schema
creating for snapshots, 2-4
for snapshot sites, 2-2, 2-4
Schema Manager
Create Refresh Group property sheet, 2-26
Create Snapshot Log property sheet, 2-8
Create Snapshot property sheet, 2-14, 2-15
creating snapshots with, 2-7, 2-10
snapshot log creation, 2-7
Snapshot Log property sheet, 2-35
schemas
creating for multimaster replication, 3-6
creating for snapshot sites, 4-7
security, A-4
for multimaster replication, 7-18
for snapshot replication, 7-22
setup
alternative, 7-24
Select from Master Schemas list
setup wizard, 4-7
self-referential constraints in tables
adding sites with to master groups, 3-25
Send Us Your Comments
boilerplate, xxiii
serial propagation, 1-22
scheduled links, 3-10
serialization
of transactions, 7-3
Set Alternate Key Columns dialog
Replication Manager, 3-16, 3-20
Set Date dialog
Replication Manager, 3-9, 3-12
Set Interval dialog
Replication Manager, 3-9, 3-12
Set Scheduled Link dialog
Replication Manager, 3-9
SET_COLUMNS procedure
DBMS_REPCAT package, 3-20
set_disabled, 9-40
SET_DISABLED procedure
DBMS_DEFER_SYS package, 3-11, 3-13, 3-14
setup wizard
configuring snapshot sites, 4-3
Create Master Sites page, 3-24
Create Scheduled Link property sheet, 3-11, 3-13
creating
administrator accounts, 3-5, 4-7
propagator accounts, 3-5, 4-7
receiver accounts, 3-5
Customize Master Site property sheet, 3-7
Customize Snapshot property sheet, 4-8
Edit DB Connection property sheet, 3-13, 3-14
Edit Master Group property sheet, 3-25
Edit Scheduled Link property sheet, 3-11
Finish page, 3-7
New Master Site dialog, 3-5
New Replicated Object Schema dialog, 3-6
Replication Manager, 3-4
Select from Master Schemas list, 4-7
shadow column groups, 1-27, 5-7
shared ownership, 1-25
simple snapshots
refresh groups
creating, 2-24
SQL restrictions, 2-13
structure, 1-7
simple subquery snapshots
many-to-many references, 2-20, 2-23
many-to-one references, 2-19, 2-23
requirements, 2-9
tuning, 2-41
site ownership
dynamic, 5-4
primary, 5-4
site priority
altering, 9-95
as a backup method during timestamp conflict resolution, 5-18
managing, 5-28
site priority groups, 5-28
adding members to, 5-29, 9-81
altering members
priorities, 5-29
values, 5-30
creating, 5-28
syntax, 9-122
dropping, 5-30, 9-135
dropping members, 5-30
removing members from, 9-136
using, 5-28
sites
dropping by priority level, 5-30
snapshot group wizard
Replication Manager, 4-3
snapshot groups
choosing master sites, 4-4
choosing objects to replicate, 4-4
managing, 4-12 to 4-16
selecting master group, 4-4
Snapshot Log property sheet, 2-28
General page, 2-35
Options page, 2-28
Storage page, 2-28
snapshot logs
altering, 2-28, 4-11
privileges required, 2-28
contents of, 1-9
creating, 2-3, 2-6, 4-3, 4-11
privileges required, 2-8
deleting, 4-12
deleting rows
privileges required, 2-30
dropping, 2-33
privileges required, 2-33
filter columns
adding, 2-28
internal operations, 2-10
managing space, 2-28
master table
dropping, 2-33
purging, 2-29, 9-193
naming, 2-8
purging, 2-29
manual, 2-29
privileges required, 2-29
reducing space allocated to, 2-30
reorganizing master tables with, 2-30
storage parameters, 2-8
truncating, 2-30
privileges required, 2-30
truncating master table with, 2-31
underlying table for, 1-10
when to create, 2-8
snapshot refresh groups
adding members, 2-38
altering settings, 2-38
creating, 2-3
deleting, 2-38
deleting members, 2-38
managing, 2-5 to 2-40
manual refresh, 2-39
snapshot refreshes, 4-9
complete, 1-9
fast, 1-9
group
refresh interval, 1-10
groups, 1-10
snapshot logs and, 1-9
snapshot registration at master sites, A-3
snapshot site replication, 4-1 to 4-24
snapshot sites
account configurations, 4-7
adding to advanced replication environments, 4-2 to 4-10
advanced
alternative security setup, 7-24
changing masters, 9-172
configuration, 4-3
creating
syntax, 9-114
creating refresh groups for, 4-22
customizing settings, 4-8
database links for, 2-2, 2-5
designing, 4-2
dropping, 9-137
offline instantiation
advanced replication, 7-17
preparing for replication, 4-5
propagating changes to master, 9-37
refreshing
syntax, 9-156
replication administrator, 4-5
replication propagator, 4-5
reviewing settings, 4-8
scheduled links for, 3-9
guidelines, 3-10
scheduled purge for
guidelines, 3-13
schema creation for, 4-7
schema for, 2-2
SNP background processes for, 4-10
specifying master site for, 4-6
snapshot sites and migration, B-5
snapshots, 2-5
altering
privileges required, 2-36
altering definition, 4-21
assigning to refresh groups, 2-3
cloning
offline instantiation, 7-14
cloning for basic replication, 7-15
clustered, 2-15
complex, 1-11, 2-41
value for PCTFREE, 2-43
value for PCTUSED, 2-43
creating, 2-3, 4-17
privileges required, 2-11
with subquery, 4-20
with WHERE clause, 4-18
creating schema for, 2-4
creating synonyms based on, 2-35
creating views based on, 2-35
creating with subqueries, 2-16
data dictionary views for, 10-25 to 10-31
data load options, 2-15
datatypes supported, 4-18
defining query, 1-7, 2-12
deleting from snapshot groups, 4-21
dropping
privileges required, 2-37
dropping master table for, 2-36
editing, 4-20
editing storage settings, 4-20
enabling/disabling replication for, 7-35
granting access, 2-3
granting access to, 4-4
group, 1-19
groups
advanced management of, 6-2
indexing, 2-40
managing, 4-16 to 4-21
managing base table, 4-21
naming, 2-11
offline instantiation of, 9-51, 9-53
performance tuning, 2-40
primary key, 1-12, 2-12, A-3
requirements for creating log, 2-8
read-only, 1-6
altering, 2-36
base table, 1-7
dropping, 2-36
index, 1-8
managing, 2-34 to 2-37
privileges required to query, 2-34
registration, 2-35, 2-36
simple with subqueries, A-2
unregistering, 2-36
using, 2-34
view, 1-8
referencing remote data, 2-13
refresh, 1-9, 1-11
failures, 2-39
individual snapshot, 2-44
problems with, 6-26
querying for last refresh time, 2-35
retries, 2-39
rollback segment for, 2-27
troubleshooting, 2-39, 2-40
refresh groups, 4-22
adding members, 2-38
altering settings, 2-38
creating, 2-24
data dictionary views, 10-25
deleting, 2-38
deleting members, 2-38
designing, 2-5
manual refresh, 2-39
refresh setting, 2-12
refresh types, 2-27
refreshing, 9-194
replication
security for, 7-22
requirements for fast refresh, 2-17
ROWID, 2-43
rowid, 1-12
simple
structure, 1-7
simple subquery
advanced subsetting, 2-16
AND expression and, 2-24
examples, 2-16 to 2-21
EXISTS clause and, 2-24
filter columns requirement, 2-9, 2-24
joins and, 2-24
number of columns in master tables, 2-24
requirements, 2-9
site, 1-19
sites
changing masters, 6-3
schema for, 2-4
SNAPSHOTS view, 10-26
SQL
restrictions for simple, 2-13
storage options, 2-14
subquery, 1-7, 2-16
many-to-many references, 2-20
many-to-one references, 2-19
subquery snapshots, restrictions for, 2-23
trace file, 2-40
troubleshooting, 6-26
tuning, 2-41
underlying objects for, 1-7
updatable, 1-15
deferred constraints, A-4
propagation mechanism, 1-23
updating, 1-9
upgrading to primary key, B-10
using PL/SQL triggers with base tables, 4-21
viewing information about, 2-35
Snapshots page
Create Refresh Group property sheet, 4-22
SNAPSHOTS view, 10-26
SNAPSHOTS_LOGS view, 10-28
SNP background processes, 3-8, 4-10
basic replication
environment, 2-6
for automatic snapshot refresh, 1-11
snapshot sites, 4-10
space
reducing snapshot log, 2-30
SQL
commands
snapshot creation, 2-16 to 2-21
restrictions for simple snapshots, 2-13
static ownership, 1-25
statistics
auditing conflict resolution, 6-16
collecting, 9-160
deleting, 6-17
for conflict resolution, 6-16
status
propagation, 9-24
Stop on Error setting
Create New Scheduled Link property sheet, 3-10
storage options
PCTFREE, 2-9
PCTUSED, 2-9
Storage page
Create Snapshot Property Sheet, 2-14
Snapshot Log property sheet, 2-28
storage parameters
snapshot log
altering, 2-28
snapshot logs, 2-8
snapshots, 2-14
storage settings
editing for snapshots, 4-20
store-and-forward replication, 1-21
subqueries for snapshots, A-2
subquery
creating snapshots with, 4-20
subquery snapshots, 1-7, 2-16
advanced subsetting, 2-16
AND expression and, 2-24
creating, 4-20
EXIST clause and, 2-24
filter columns requirement, 2-9, 2-24
joins for, 2-24
many-to-many references, 2-20, 2-23
many-to-one references, 2-19, 2-23
number of columns in master tables, 2-24
requirements, 2-9
tuning, 2-41
SUBTRACT procedure
DBMS_REFRESH package, 2-38
survivability, 7-11
design considerations, 7-13
Parallel Server and, 7-12
SUSPEND_MASTER_ACTIVITY procedure
DBMS_REPCAT package, 3-18
SWITCH_SNAPSHOT_MASTER procedure
DBMS_REPCAT package
ALTER_SNAPSHOT_PROPAGATION procedure, 4-16
synchronous data propagation, 1-28, 7-6
synchronously replicated transactions
destination of, 7-7
synonyms
creating, based on snapshot, 2-35
system-based security, A-4

T

table data
replicating to master sites, 3-22
tables
comparing, 9-55
intersection, 2-20 to 2-23
master groups
generating replication support for, 3-28
modifying
without replicating changes, 7-32
partitioned
replicating, 3-21
partitioned and indexes, A-4
problems generating replication support for, 6-24
rectifying, 6-18, 9-59
reorg, A-4
Tablespace and Extents page
Create Snapshot Log property sheet, 4-11
Edit Snapshot Log property sheet, 4-11
Edit Snapshot property sheet, 4-20
timestamp conflict resolution methods
sample trigger, 5-31
token passing, 7-28
sample implementation, 7-27
trace file
snapshots, 2-40
transactions
deferred
deleting, 6-10
executing, 6-9
error
displaying, 6-11
propagation
protection mechanisms, 3-33 to 3-34
queue for
deferred, diagnosing problems with, 6-25
serialization of, 7-3
triggers
internal, A-2
replicating, 7-34
troubleshooting, 6-22
TRUNCATE command, 2-30
TRUNCATE TABLE command
PRESERVE SNAPSHOT LOG option, 2-31
PURGE SNAPSHOT LOG option, 2-31

U

Ungrouped Snapshots folder, 4-22
UNIQUE constraint
simple subquery snapshots and, 2-23
uniqueness conflicts, 1-24, 5-3
avoiding, 5-5
resolution, 5-8
configuring, 5-33
resolution methods, 5-9
assigning, 5-33
removing, 5-33
resolving, 5-47
UNREGISTER_SNAPSHOT procedure
DBMS_SNAPSHOT package, 2-36
UNSCHEDULE_PUSH procedure
DBMS_DEFER_SYS package, 3-12
updatable snapshots, 1-15
generating replication support for, 4-20
propagation mechanism, 1-23
properties of, 1-15
update conflicts, 1-24, 5-3
avoiding, 5-5
resolution
and column groups, 5-7
using site priority for, 5-28
resolution methods
assigning, 5-15
prebuilt, 5-8
resolution of
minimizing data propagation for, 5-40
resolving, 5-47
updates
and min_communication, 5-41
minimizing communication, 5-41
updating
Comments, 6-28
replication tables, 6-28
USER_REFRESH view, 2-40
USER_REFRESH_CHILDREN view, 2-40
user-defined
notification methods, 5-50
user-defined conflict resolution method, 5-46

V

VALIDATE procedure, A-4
View Database Destination property sheet, 6-10
views
creating, based on snapshot, 2-35
DBA_REFRESH, 2-44
DBA_REFRESH_CHILDREN, 2-44
DBA_REGISTERED_SNAPSHOTS, 2-35, 2-44
DBA_RGROUP, 2-44
DBA_SNAPSHOT_LOGS, 2-35, 2-44
DBA_SNAPSHOTS, 2-44
DEFCALL, 10-20
DEFCALLDEST, 10-20
DEFDEFAULTDEST, 10-21
DEFERRCOUNT, 10-21
DEFERROR, 10-22
DEFLOB, 10-22
DEFPROPAGATOR, 10-23
DEFSCHEDULE, 10-23
DEFTRAN, 10-24
DEFTRANDEST, 10-24
REFRESH, 10-30
REFRESH_CHILDREN, 10-31
REGISTERED_SNAPSHOTS, 10-27
REPCATLOG, 3-30, 6-6 to 6-7, 10-5
REPCOLUMN, 10-6
REPCOLUMN_GROUP, 10-6
REPCONFLICT, 10-7
REPDDL, 10-7
REPGENERATED, 10-8
REPGENOBJECTS, 10-18
REPGROUP, 3-30, 10-3
REPGROUPED_COLUMN, 10-9
REPKEY_COLUMNS, 10-9
replication catalog, 10-2
REPOBJECT, 3-30, 10-10
REPPARAMETER_COLUMN, 10-11
REPPRIORITY, 10-12
REPPRIORITY_GROUP, 10-13
REPPROP, 10-13
REPRESOL_STATS_CONTROL, 10-15
REPRESOLUTION, 10-14
REPRESOLUTION_METHOD, 10-15
REPRESOLUTION_STATISTICS, 10-16
REPSITES, 3-30, 10-17
SNAPSHOT_REFRESH_TIMES
SNAPSHOT_REFRESH_TIMES view, 10-29
SNAPSHOTS, 10-26
SNAPSHOTS_LOGS, 10-28
USER_REFRESH, 2-40
USER_REFRESH_CHILDREN, 2-40

W

WHERE clause
creating updatable snapshots with
updatable snapshots
creating with WHERE clause, 4-18
workflow, 7-27
wrapper
procedural replication, 1-28


Prev
Oracle
Copyright © 1997 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents