Oracle8i Replication
Release 8.1.5

A67791-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, 3-25
ADD_MASTER_DATABASE procedure
DBMS_REPCAT package, 2-33
adding
columns in column groups, 6-14
priority group members, 6-25
site priority group members, 6-30
sites
to an advanced replication environment, 8-8
additive prebuilt conflict resolution method, 6-18
administration requests, 1-13, 7-4 to 7-8
applying, 7-5
deleting, 7-6
diagnosing problems with, 7-8
displaying, 7-5
administrator accounts
master sites, 2-8
advanced replication, 2-1 to 8-37
asynchronous propagation, 2-3
deferred transactions and, 2-4
disabling, 8-35
hybrid configurations, 1-12
job queues and, 2-4
multimaster, 2-1 to 2-44
multimaster configuration, 1-5
procedural replication, 1-14
row-level replication, 2-2
RPCs and, 2-4
snapshot sites
offline instantiation of, 8-17
replication, 5-1 to 5-32
synchronous propagation, 1-15, 8-6
techniques, 8-1 to 8-37
transaction propagation protection, 2-42 to 2-44
uses for, 1-5, 1-11
advanced replication systems
monitoring, 7-4
ALTER SNAPSHOT LOG command, 7-23
ALTER_MASTER_REPOBJECT procedure
DBMS_REPCAT package, 2-29
altering
priority group members
priorities, 6-27
values, 6-26
site priority group members
priorities, 6-30
values, 6-31
snapshot definitions, 5-27
alternate keys
in replicated tables, 2-25
AND expression
for simple subquery snapshots, 3-13
append sequences
conflict resolution methods, 6-36
append site names
conflict resolution methods, 6-36
assigning
update conflict resolution methods, 6-17
asynchronous
replication, 2-3
RPCs, 9-2
auditing, 7-18
conflict resolution, 7-18
automatic conflict resolution
versus manual, 6-7
automatic refreshes
refresh interval, 3-24
average
conflict resolution method
use of, 6-39
average prebuilt conflict resolution method, 6-18

B

backups
for replication, 7-17
using multiple conflict resolution methods for, 6-11
basic replication, 3-1 to ??
uses of, 1-10
Batch Size setting
Create New Scheduled Link property sheet, 2-13
BEGIN_INSTANTIATION procedure
DBMS_OFFLINE_OG package, 8-16
BEGIN_LOAD procedure
DBMS_OFFLINE_OG package, 8-17
BEGIN_TABLE_REORGANIZATION procedure
DBMS snapshot package, 7-25
BLOBs support, A-3
branch automation, A-3
bulk updates, 7-31

C

catalog, replication, 1-13
checking imported data, 7-17
circular dependencies in tables
restrictions on adding sites with to master groups, 2-33
CLOBs support, A-3
column groups
and update conflict resolution, 6-7
dropping, 6-15
shadow, 6-8
columns
adding and removing in column groups, 6-14
commands, SQL
ALTER SNAPSHOT LOG, 7-23
DROP SNAPSHOT LOG, 7-28
TRUNCATE, 7-25
TRUNCATE TABLE, 7-26
comments
on Oracle documentation, xxii
updating, 7-38
comments field
in views
updating, 7-38
complete refreshes, 3-22
complex snapshots, 3-5
value for PCTFREE, 3-22
value for PCTUSED, 3-22
Configuration folder, 2-38
conflicts
additive resolution method, 6-18
avoidance
dynamic ownership, 8-30
avoiding, 6-4
delete, 6-3
avoiding, 6-5
detecting, 6-5, 8-8
master sites, avoiding at, 6-5
detection
identifying rows during, 6-6
how Oracle detects, 6-6
maximum value conflict resolution method, 6-19
minimum value conflict resolution method, 6-19
notification
package, sample, 6-54
notification log
creating, 6-53
notification log table
sample, 6-53
notification methods
user-defined, 6-52
notification package
creating, 6-54
procedural replication, 1-15
resolution
auditing, 7-18
automatic versus manual, 6-7
configuration
overview, 6-12
declarative methods, update conflicts, 6-18
delete, 6-8
strategy, 8-28
delete, configuring, 6-37
design and preparation guidelines, 6-12
detecting conflicts, 6-5
gathering statistics, 7-18
highest priority, 6-31
in synchronous propagation, 8-8
information
viewing, 6-56
procedural replication and, 8-3
RepResolution_Statistics table, deleting, 7-19
statistics
canceling, 7-18
uniqueness, 6-8
configuring, 6-34
update
and column groups, 6-7
user-defined routines
parameters, 6-48
user-defined routines, example, 6-51
user-defined routines, restrictions, 6-51
viewing information, 6-56
resolution and notification methods
custom, 6-10
resolution methods, 6-8
average prebuilt, 6-18
delete, assigning, 6-37
delete, removing, 6-37
discard, 6-21
managing, 6-16
multiple
using, 6-10
overwrite, 6-21
prebuilt, restrictions for, 6-9
uniqueness, assigning, 6-34
uniqueness, removing, 6-35
update
prebuilt, 6-8
user-defined, 6-48
using, for notification, 6-11
resolution methods for
removing, 6-17
resolution methods for column groups
ordering, 6-17
uniqueness, 6-3
avoiding, 6-5
update, 6-3
avoiding, 6-5
update resolution
using site priority for, 6-29
constraint violations, 7-31
continuous pushes
scheduling, 2-14, 2-17
Create, 2-8
Create Master Sites dialog
setup wizard, 2-32
Create New Master Group property sheet
Destinations page, 2-19
General page, 2-19
Objects page, 2-19
Replication Manager, 2-19
Create New Scheduled Link property sheet, 2-12
General page, 2-12
Options page, 2-12
Create Refresh Group property sheet
General page, 5-29
Scheduling page, 5-29
Snapshots page, 5-29
Create Scheduled Link property sheet
setup wizard, 2-14, 2-17
Create Schema dialog
setup wizard, 2-9
CREATE_MASTER_REPGROUP procedure
DBMS_REPCAT package, 2-20
creating
deferred transactions, 9-2
master sites, 2-8
priority groups, 6-25
site priority groups, 6-30
snapshots, 5-24
Customize Master Site property sheet
setup wizard, 2-10

D

data
convergence, 6-7
guaranteeing, 6-38
inconsistencies
removing after deleting master sites, 2-34
integrity
ensuring with multiple column groups, 6-7
parallel propagation, 2-43
serial propagation, 2-43
data dictionary
DBA_REGISTERED_SNAPSHOTS view, 7-37
data manipulation language (DML)
minimizing propagation, 6-42
data propagation
and dependency maintenance, 2-43
minimizing, 2-37
minimizing for update conflict resolution, 6-42
mode of
altering in a master site, 8-10
reduced, A-2
synchronous, 8-6
data replication
real-time, 8-6
data requirements
evaluating and understanding, 6-2
data subsetting, A-3
data warehouse
basic replication for, 1-11
database
links
using different paths, 2-20
preparing for multimaster replication, 2-7
Database Information property sheet
Replication Manager, 2-18
Database Link setting
Create Scheduled Link property sheet, 2-12
database link specifications
incomplete, 7-33
database links, 7-29
snapshot sites, for, 3-26
datatypes
allowed in replicated tables, 2-26
allowed in snapshots, 3-17, 5-26
support for, A-3
DBA_REGISTERED_SNAPSHOTS view, 7-37
DBA_SNAPSHOT_LOGS view, 7-37
DBMS_DEFER package
ADD_DEFAULT_DEST procedure, 9-6
CHAR_ARG procedure, 9-5
DATE_ARG procedure, 9-5
NUMBER_ARG procedure, 9-5
RAW_ARG procedure, 9-5
ROWID_ARG procedure, 9-5
TRANSACTION procedure, 9-4
VARCHAR2_ARG procedure, 9-5
DBMS_DEFER_SYS package
DELETE_DEFAULT_DEST procedure, 9-6
DISABLED procedure, 2-15
SCHEDULE_EXECUTION procedure, 2-13, 2-15, 2-17, 2-18
SCHEDULE_PUSH procedure, 2-13, 2-15, 2-17, 2-18
SET_DISABLED procedure, 2-15, 2-17, 2-18
UNSCHEDULE_PUSH procedure, 2-16
DBMS_OFFLINE_OG package
BEGIN_INSTANTIATION procedure, 8-16
BEGIN_LOAD procedure, 8-17
END_INSTANTIATION procedure, 8-17
END_LOAD procedure, 8-17
RESUME_SUBSET_OF_MASTERS procedure, 8-16
DBMS_RECTIFIER_DIFF package, 2-34, 7-19
DBMS_REPCAT package, 7-6
ADD_MASTER_DATABASE procedure, 2-33
ADD_PRIORITY_CHAR procedure, 6-25
ADD_PRIORITY_DATE procedure, 6-25
ADD_PRIORITY_NUMBER procedure, 6-25
ADD_PRIORITY_RAW procedure, 6-25
ADD_PRIORITY_VARCHAR2 procedure, 6-25
ADD_SITE_PRIORITY_SITE procedure, 6-30
ALTER_MASTER_REPOBJECT procedure, 2-29
ALTER_PRIORITY procedure, 6-27
ALTER_PRIORITY_CHAR procedure, 6-26
ALTER_PRIORITY_DATE procedure, 6-26
ALTER_PRIORITY_NUMBER procedure, 6-26
ALTER_PRIORITY_RAW procedure, 6-26
ALTER_PRIORITY_VARCHAR2 procedure, 6-26
ALTER_SITE_PRIORITY procedure, 6-30
ALTER_SITE_PRIORITY_SITE procedure, 6-31
CANCEL_STATISTICS procedure, 7-18
COMMENT_ON_COLUMN_GROUP procedure, 7-38
COMMENT_ON_DELETE resolution package, 7-38
COMMENT_ON_PRIORITY_GROUP procedure, 7-38
COMMENT_ON_REPCAT procedure, 7-38
COMMENT_ON_REPOBJECT procedure, 7-38
COMMENT_ON_REPSCHEMA procedure, 7-38
COMMENT_ON_UNIQUE resolution package, 7-38
COMMENT_ON_UPDATE resolution package, 7-38
CREATE_MASTER_REPGROUP procedure, 2-20
DEFINE_PRIORITY_GROUP procedure, 6-25
DEFINE_SITE_PRIORITY procedure, 6-30
DO_DEFERRED_REPCAT_ADMIN procedure, 7-6, 7-6 to 7-7
DROP_MASTER_REPGROUP procedure, 2-21
DROP_MASTER_REPOBJECT procedure, 2-31
DROP_PRIORITY procedure, 6-28
DROP_PRIORITY_CHAR procedure, 6-27
DROP_PRIORITY_DATE procedure, 6-27
DROP_PRIORITY_GROUP procedure, 6-28
DROP_PRIORITY_NUMBER procedure, 6-27
DROP_PRIORITY_RAW procedure, 6-27
DROP_PRIORITY_VARCHAR2 procedure, 6-27
DROP_SITE_PRIORITY procedure, 6-32
DROP_SITE_PRIORITY_SITE procedure, 6-31
EXECUTE_DDL procedure, 7-2
GENERATE_REPLICATION_SUPPORT procedure, 2-37
PURGE_STATISTICS procedure, 7-19
REGISTER_STATISTICS procedure, 7-18
RELOCATE_MASTERDEF procedure, 7-3
REMOVE_MASTER_DATABASES procedure, 2-34
REPCAT_IMPORT_CHECK procedure, 7-17
RESUME_MASTER_ACTIVITY procedure, 2-24
SET_COLUMNS procedure, 2-25
SUSPEND_MASTER_ACTIVITY procedure, 2-23
SWITCH_SNAPSHOT_MASTER procedure, 7-3
DBMS_REPUTIL package
REPLICATION_OFF procedure, 8-35
REPLICATION_ON procedure, 8-36
DBMS_SNAPSHOT package
BEGIN_TABLE_REORGANIZATION procedure, 7-25
END_TABLE_REORGANIZATION procedure, 7-25
PURGE_LOG procedure, 7-24
REGISTER_SNAPSHOT procedure, 7-37
UNREGISTER_SNAPSHOT procedure, 7-37
DDL
changes not propagated to master site, 7-30
executing within a master group, 7-2
propagating statements to master sites, 7-2
deadlocks
resolving
in synchronous propagation, 8-8
decision support application
basic replication for, 1-10
DefDefaultDest table
adding destinations to, 9-6
removing destinations from, 9-6
deferred constraints and updatable snapshots, A-4
deferred RPCs, 9-2
deferred transactions, 2-4
creating, 9-2
DefCall table, 9-5
DefCallDest table, 9-5
DefDefaultDest table
adding destination to, 9-6
removing destinations from, 9-6
deferred remote procedure calls (RPCs)
arguments to, 9-5
building, 9-5
DefTran table, 9-4
deleting, 7-11
diagnosing problems with, 7-33
displaying, 7-9
executing, 7-10
managing, 7-9
purging, 2-16
queue
clearing after deleting master sites, 2-34
purging, 2-5, 2-18
push, 2-4
starting, 9-4
Deferred Transactions by Dest folder, 7-9, 7-11
definition sites
relocating for a master group, 7-3
delay seconds
setup wizard, 2-17
Delay Seconds setting
Create New Scheduled Link property sheet, 2-13
delete conflicts, 6-3
avoiding, 6-5, 8-28
resolution, 6-8
configuring, 6-37
methods, assigning, 6-37
resolution methods
removing, 6-37
resolving, 6-50
deleting
master groups, 2-21
scheduled links, 2-16
snapshots, 5-28
dependency
ordering
replicated transactions, 2-43
tracking
parallel propagation, 2-43
deployment templates, 4-1
add existing object, 4-26
add new object, 4-30
architecture, 4-10
concepts, 4-3
creating, 4-24
data sets, 4-21
deployment sites, 4-8
design, 4-17
elements, 4-3
general template information, 4-4
horizontal partitioning, 4-17
instantiation, 4-9, 4-13, 4-50
modify, 4-34
object definitions, 4-5
offline instantiation, 4-10, 4-12, 4-15, 4-45
online instantiation, 4-9, 4-12, 4-14, 4-45
package, 4-45
package template, 4-8, 4-12
refresh groups, 4-16
snapshot groups, 4-16
template parameters, 4-6
user authorization, 4-7
vertical partitioning, 4-20
destination maps
displaying for master groups, 2-39
destination master sites
adding to master groups, 2-19, 2-32
Destinations page
Create New Master Group property sheet, 2-19
detecting conflicts, 6-5, 6-6
diagnosing problems with, 7-29
DIFFERENCES
procedure, 7-19
DISABLED procedure
DBMS_DEFER_SYS package, 2-15
disabling replication, 8-34
discard
conflict resolution method, 6-21
use of, 6-39
discard uniqueness
conflict resolution method, 6-37
disconnected environments
as in advanced replication, 1-11
distributed transactions
problems with, 7-33
distributing application loads
as in advanced replication, 1-6
DML
changes not propagated to other sites, 7-31
DO_DEFERRED_REPCAT_ADMIN package, 7-6
DO_DEFERRED_REPCAT_ADMIN procedure
DBMS_REPCAT package, 7-6, 7-6 to 7-7
DROP SNAPSHOT LOG command, 7-28
DROP_MASTER_REPGROUP procedure
DBMS_REPCAT package, 2-21
DROP_MASTER_REPOBJECT procedure
DBMS_REPCAT package, 2-31
dropping
column groups, 6-15
priority group members
by priority, 6-28
by value, 6-27
priority groups, 6-28
site priority groups, 6-32
members of, 6-31
sites
by priority level, 6-32
snapshot logs, 7-28
dynamic ownership
conflict avoidance and, 8-30
workflow partitioning, 8-30
dynamic sites
ownership, 6-4

E

earliest and latest timestamp
conflict resolution methods, 6-20
Edit Database Destination property sheet
Replication Manager, 2-39
Edit DB Connection property sheet
setup wizard, 2-17
Edit Replication Object property sheet
Min(imize) Communications setting, 2-37
Edit Scheduled Link property sheet
Replication Manager, 2-15
setup wizard, 2-14
Edit Snapshot property sheet
Tablespace and Extents page, 5-27
Enabled setting
Create New Scheduled Link property sheet, 2-13
enabling replication, 8-34
END_INSTANTIATION procedure
DBMS_OFFLINE_OG package, 8-17
END_LOAD procedure
DBMS_OFFLINE_OG package, 8-17
END_TABLE_REORGANIZATION procedure
DBMS_SNAPSHOT package, 7-25
enhancements
new features, A-2
error
transactions
managing, 7-12
errors
transactions
displaying, 7-12
resolving, 7-13
examples
minimizing
communication, 6-43
EXECUTE_DDL procedure
DBMS_REPCAT package, 7-2
EXIST clause
for simple subquery snapshots, 3-13
Export utility
offline instantiation of master site, 8-16

F

fail-over sites
implementing, 8-14
failover sites
as in advanced replication, 1-5
fast refreshes, 3-22
and table reorg, A-4
features requiring migration, B-12
Feedback
on ORACLE documentation, xxii
filter columns
for simple subquery snapshots, 3-13
fine grained quiesce, A-3
Finish page
Replication Manager, 2-10
setup wizard, 2-10
force refreshes, 3-23

G

gen_rep_pack, 6-23
General page
Create New Master Group property sheet, 2-19
Snapshot Log property sheet, 7-37
GENERATE_REPLICATION_SUPPORT procedure
DBMS_REPCAT package, 2-37
generated objects
displaying for master groups, 2-39
generated replication objects
wrapper package, 2-2
generating
replication support
procedural replication, 8-3
replication support and migration, B-3
generating replication support
migration and, B-8
group owner, 3-19

H

hybrid configurations
advanced replication, 1-12

I

Import utility
offline instantiation of master site, 8-17
import_check, 7-17
in basic replication, 1-11
incremental migration, B-4
indexes
partitioned tables and, A-4
information
distribution
in basic replication, 1-10
off-loading
in basic replication, 1-10
transport, 1-11
information distribution
basic replication for, 1-10
initialization parameters
JOB_QUEUE_INTERVAL, 7-7
JOB_QUEUE_PROCESSES, 7-7
PARALLEL_MAX_SERVERS, 2-42
PARALLEL_MIN_SERVERS, 2-42
PARALLEL_SERVER_IDLE_TIME, 2-42
INIT.ORA, 2-21
instantiation
offline, 8-14
in advanced replication, 8-17
of an advanced replication master site, 8-16
instantiation offline, A-4
internal triggers, A-2
intersection tables, ?? to 3-13
Interval Expression setting
Setup wizard, 2-16
Interval setting
Create Scheduled Link property sheet, 2-13

J

job queue process, 2-11
job queues, 2-4
JOB_QUEUE_INTERVAL initialization parameters, 7-7
JOB_QUEUE_PROCESSES initialization parameters, 7-7
jobs
breaking, 7-16
checking for scheduled links, 7-33
diagnosing problems with, 7-16
enabling, 7-16
local
displaying, 7-14
editing properties of, 7-15
manually executing, 7-15
joins
for simple subquery snapshots, 3-13

L

large object types
allowed in replicated tables, 2-26
latest timestamp
conflict resolution method, 6-20
link qualifiers
master groups, 2-20
link specifications
incomplete, 7-33
LOBs
omitting old values for, 6-42
support for, 2-26, 3-17, A-3
local jobs
displaying, 7-14
editing properties of, 7-15

M

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

N

NCLOB support, A-3
new features
data subsetting and subqueries, A-3
enhanced security, A-4
for management and use, A-3
LOB support, A-3
performance, A-2
subqueries for snapshots, A-3
subquery snapshots, A-3
New Master Site dialog
setup wizard, 2-8
Next Date setting
Create New Scheduled Link property sheet, 2-12
Setup wizard, 2-16
notification
methods
custom, for conflict resolution, 6-10
using multiple conflict resolution methods for, 6-11
notification log
conflict
creating, 6-53
notification log table
conflict
sample, 6-53
notification methods
user-defined, 6-52
notification package
conflict
creating, 6-54

O

objects
altering in a master group, 2-28
definitions
replication to master sites, 2-26
master groups
generating support for, 2-36
removing from master groups, 2-30
replicated
re-creating, 7-32
Objects page
Create New Master Group property sheet, 2-19
obsolete procedures, B-13
offline instantiation, 2-28
master sites, 8-16 to 8-17
support for, A-4
OPEN_LINKS initialization parameters
initialization parameters
OPEN_LINK, 2-21
Options page, 7-23
Oracle Replication Manager, 1-13
Oracle7
and min_communication, 5-11
Oracle8
features and migration, B-12
ordering
conflict resolution methods for column groups, 6-17
ordering conflicts
avoiding, 6-40
overwrite
conflict resolution method
use of, 6-39
conflict resolution methods, 6-21

P

parallel propagation, 2-4, A-2
advanced replication environment, 2-40 to 2-42
dependency
tracking, 2-43
planning for, 2-40
Parallel Propagation setting
Create New Scheduled Link property sheet, 2-13
parallel server processes
configuring for advanced replication environments, 2-41
PARALLEL_MAX_SERVERS initialization parameters, 2-42
PARALLEL_MIN_SERVERS initialization parameters, 2-42
PARALLEL_SERVER_IDLE_TIME initialization parameters, 2-42
partitioned tables
indexes and, A-4
partitions
replication and, 2-26
PCTFREE
value for complex snapshots, 3-22
PCTUSED
value for complex snapshots, 3-22
performance enhancements, A-2
periodic purges
scheduling, 2-18
periodic pushes
scheduling, 2-14
pgroup, 6-23
PL/SQL triggers
using with snapshot base tables, 5-27
prebuilt conflicts
resolution methods
restrictions for, 6-9
prebuilt uniqueness conflicts
resolution methods, 6-9
prebuilt update conflict resolution methods, 6-18
prebuilt update conflicts
resolution methods, 6-8
PRESERVE SNAPSHOT LOG option
TRUNCATE TABLE command, 7-26
PRIMARY KEY constraint
simple subquery snapshots and, 3-13
primary key snapshots, A-3
primary keys
missing from replicated tables, 2-20
upgrading snapshots, B-10
primary sites
ownership, 6-4
priority group members
dropping, 6-28
dropping by value, 6-27
priority groups, 6-23
adding members to, 6-25
altering members
priorities, 6-27
values, 6-26
and site priority, 6-22
creating, 6-25
dropping, 6-28
dropping members
by priority, 6-28
by value, 6-27
using for conflict resolution, 6-23
priority level of sites
altering, 6-30
priority_groups, 6-22
privileges
deleting rows from snapshot logs, 7-25
procedural replication, 1-14
conflicts and, 8-3
deleting and, 8-28
detecting conflicts, 1-15
generating support for, 8-3
restrictions, 8-2
using, 8-2
wrapper, 1-15
Processes setting
Create New Scheduled Link property sheet, 2-13
propagation
minimizing data, 6-42
mode of, 8-9
altering in a master site, 8-10
parallel, 2-4, A-2
security context of propagator, 8-7
serial, 2-4
setting default characteristics, 2-9
propagation reduction, A-2
propagator, 2-5
propagator accounts
master sites, 2-8
PURGE SNAPSHOT LOG option
TRUNCATE TABLE command, 7-26
PURGE_LOG procedure
DBMS_SNAPSHOT package, 7-24
purges
manual, 2-18
periodic
scheduling, 2-18
purging
deferred transaction queue, 2-16
snapshot logs, 7-24
pushes
continuous
scheduling, 2-14, 2-17
periodic
scheduling, 2-14

Q

queue
deferred transactions, 2-4
quiescing
and fine grained quiesce, A-3
master groups, 2-22

R

read-only replication
uses of, 1-10
read-only snapshot, 1-7
read-only snapshots, 3-7
registration, 7-37
manual, 7-37
unregistering, 7-37
real-time
data replication, 1-15
replication, 1-15, 8-6
receiver, 2-5
accounts
master sites, 2-8
recovery, 7-17
for replication, 7-17
RECTIFY
procedure, 7-19
rectifying
tables, 7-19
re-enabling
advanced replication, 8-36
refresh
failures, 7-34
fast and table reorg, A-4
retries, 7-34
refresh groups
creating
for snapshot sites, 5-29
managing, ?? to 7-35
manual refresh, 3-24
snapshots, 5-28
troubleshooting refresh, 7-34
refresh intervals
parameter constraints, 3-24
snapshot refresh groups, 3-24
refresh types
manual, 3-24
REGISTER_SNAPSHOT procedure
DBMS_SNAPSHOT package, 7-37
registering
snapshots, A-4
RELOCATE_MASTERDEF procedure
DBMS_REPCAT package, 7-3
remote procedure calls, 2-4
deferring, 9-5
REMOVE_MASTER_DATABASES procedure
DBMS_REPCAT package, 2-34
removing
columns in column groups, 6-14
conflict resolution methods, 6-17
RepCat table
updating, 7-38
REPCATLOG view, 2-40, 7-6 to 7-8
RepColumn_Group table
updating, 7-38
REPGROUP view, 2-40
replicated environment
determining differences in tables, 7-19
replicated objects
at snapshot sites
problems creating, 7-34
re-creating, 7-32
replicated procedures
generating support for, 8-3
replicated tables
alternate keys for, 2-25
and DML incompatibility, 7-31
datatypes allowed, 2-26
differences between, 7-19
populating manually, 2-27
replicated transactions
dependency ordering, 2-43
replication
administrator, 2-5
advanced
introduction to conflicts, 6-2
re-enabling, 8-36
advanced techniques, 8-1 to 8-37
advanced, uses for, 1-5
backup and recovery for, 7-17
basic, 3-1 to ??
catalog, 1-13
conflicts
procedural replication, 1-15
definition, 1-2
disabling, 8-34, 8-35
enabling, 8-34
environment
advanced
adding new sites to, 8-8
group, 1-2
multimaster, 2-1 to 2-44
advanced options, 2-40 to 2-44
building environment
example, 2-6
monitoring, 2-38 to 2-40, 7-4 to 7-16
objects
generated, 2-2
of object definitions to master sites, 2-26
manual, 2-27
off/on affects current session, 8-35
procedural, 1-14
propagator, 2-5
real-time, 1-15, 8-6
receiver, 2-5
resuming for master groups, 2-23
sites, 1-4
suspending for master groups, 2-22
triggers, 8-36
uses of read-only, 1-10
replication catalog view
incorrect, 7-33
replication groups
master sites
managing, 2-19 to ??
replication management API, 1-13
Replication Manager, 1-13
administration requests, 7-4 to 7-8
Create New Master Group property sheet, 2-19
Create New Scheduled Link property sheet, 2-12
Edit Database Destination property sheet, 2-39
Finish page, 2-10
Scheduled Links folder, 2-15
Scheduling folder, 2-15
Set Alternate Key Columns dialog, 2-20, 2-25
Set Date dialog, 2-12, 2-16
Set Interval dialog, 2-13, 2-16
Set Scheduled Link dialog, 2-12
setup wizard, 2-7
replication objects, 1-2
adding to master groups, 2-19, 2-24
altering definition, 2-28
deleting from master groups, 2-30
replication support
for tables
unable to generate, 7-32
generating for all master group tables, 2-37
generating for master groups, 2-35
generation for objects, 2-36
replication tables
updating Comments, 7-38
replication triggers, A-2
RepObject table
updating, 7-38
REPOBJECT view, 2-40
RepPriority_Group table
updating, 7-38
RepResolution table
updating, 7-38
RepResolution_Statistics table
purging, 7-19
RepResolution_Statistics view
gathering statistics, 7-18
RepSchema table
updating, 7-38
REPSITES view, 2-40
resolution methods
additive prebuilt, 6-18
average prebuilt, 6-18
discard, 6-21
earliest timestamp, 6-20
for column groups
ordering, 6-17
for conflicts
removing, 6-17
latest timestamp, 6-20
managing, 6-16
maximum value method, 6-19
minimum value method, 6-19
overwrite, 6-21
resolution statistics
gathering, 7-18
viewing, 7-18
restrictions
procedural replication, 8-2
RESUME_MASTER_ACTIVITY procedure
DBMS_REPCAT package, 2-24
RESUME_SUBSET_OF_MASTERS procedure
DBMS_OFFLINE_OG package, 8-16
rollback segments
setup wizard, 2-16
ROWID snapshots, 3-5
row-level replication, 2-2
detecting conflicts, 6-5
rows
identifying during conflict detection, 6-6
RPC, 2-4

S

SCHEDULE_EXECUTION procedure
DBMS_DEFER_SYS package, 2-13, 2-15, 2-17, 2-18
SCHEDULE_PUSH procedure
DBMS_DEFER_SYS package, 2-13, 2-15, 2-17, 2-18
scheduled links
continuous pushes, 2-14, 2-17
creating, 2-12
database link to use, 2-12
deleting, 2-16
editing, 2-15
guidelines, 2-14
managing, 2-12
number of background processes used, 2-13
parallel propagation, 2-13, 2-40 to 2-42
periodic pushes, 2-14
serial propagation, 2-13, 2-40
viewing status, 2-15
Scheduled Links folder
Replication Manager, 2-15
scheduled purges
editing, 2-18
guidelines, 2-17
periodic purges, 2-18
Scheduling folder
Replication Manager, 2-15
Scheduling page
Create Refresh Group property sheet, 5-29
schema
creating for snapshots, 3-25
Schema Manager
Snapshot Log property sheet, 7-37
schemas
creating for multimaster replication, 2-9
security, A-4
for multimaster replication, 8-18
for snapshot replication, 8-24
self-referential constraints in tables
adding sites with to master groups, 2-33
serial propagation, 2-4
scheduled links, 2-13
serialization
of transactions, 8-3
Set Alternate Key Columns dialog
Replication Manager, 2-20, 2-25
Set Date dialog
Replication Manager, 2-12, 2-16
Set Interval dialog
Replication Manager, 2-13, 2-16
Set Scheduled Link dialog
Replication Manager, 2-12
SET_COLUMNS procedure
DBMS_REPCAT package, 2-25
SET_DISABLED procedure
DBMS_DEFER_SYS package, 2-15, 2-17, 2-18
setup wizard
Create Master Sites page, 2-32
Create Scheduled Link property sheet, 2-14, 2-17
Create Schema dialog, 2-9
creating
administrator accounts, 2-8
propagator accounts, 2-8
receiver accounts, 2-8
Customize Master Site property sheet, 2-10
Edit DB Connection property sheet, 2-17, 2-18
Edit Scheduled Link property sheet, 2-14
Finish page, 2-10
New Master Site dialog, 2-8
Replication Manager, 2-7
shadow column groups, 6-8
simple subquery snapshots
many-to-many references, 3-13
many-to-one references, 3-13
site ownership
dynamic, 6-4
primary, 6-4
site priority
as a backup method during timestamp conflict resolution, 6-20
managing, 6-29
site priority groups, 6-29
adding members to, 6-30
altering members
priorities, 6-30
values, 6-31
creating, 6-30
dropping, 6-32
dropping members, 6-31
using, 6-29
sites
dropping by priority level, 6-32
snapshot
read-only, 1-7, 3-7
updateable, 1-8
snapshot group
group owner, 3-19
snapshot groups
managing, 5-6 to 5-23
Snapshot Log property sheet, 7-23
General page, 7-37
Options page, 7-23
Storage page, 7-23
snapshot logs
altering, 7-23
privileges required, 7-23
deleting rows
privileges required, 7-25
dropping, 7-28
privileges required, 7-28
filter columns
adding, 7-23
managing space, 7-23
master table
dropping, 7-28
purging, 7-24
purging, 7-24
manual, 7-24
privileges required, 7-24
reducing space allocated to, 7-24
reorganizing master tables with, 7-25
truncating, 7-24
privileges required, 7-25
truncating master table with, 7-26
underlying table for, 3-15
snapshot refresh groups
managing, ?? to 7-35
snapshot refreshes
complete, 3-22
fast, 3-22
force, 3-23
group
refresh interval, 3-24
snapshot registration at master sites, A-4
snapshot site replication, 5-1 to 5-32
snapshot sites
creating refresh groups for, 5-29
database links for, 3-26
offline instantiation
advanced replication, 8-17
scheduled links for, 2-12
guidelines, 2-14
scheduled purge for
guidelines, 2-17
snapshot sites and migration, B-6
snapshots
altering definition, 5-27
cloning
offline instantiation, 8-14
cloning for basic replication, 8-15
complex, 3-5
value for PCTFREE, 3-22
value for PCTUSED, 3-22
creating, 5-24
creating schema for, 3-25
datatypes supported, 3-17, 5-26
deleting from snapshot groups, 5-28
editing, 5-27
editing storage settings, 5-27
enabling/disabling replication for, 8-37
group, 1-4
groups
advanced management of, 7-2
managing, 5-23 to ??
managing base table, 5-27
primary key, A-3
read-only
registration, 7-37
simple with subqueries, A-3
unregistering, 7-37
refresh, 3-22, 3-24
failures, 7-34
querying for last refresh time, 7-37
retries, 7-34
troubleshooting, 7-34, 7-35
refresh groups, 5-28
replication
security for, 8-24
ROWID, 3-5
simple subquery
AND expression and, 3-13
EXISTS clause and, 3-13
filter columns requirement, 3-13
joins and, 3-13
number of columns in master tables, 3-13
site, 1-4
sites
changing masters, 7-3
trace file, 7-35
troubleshooting, 7-34
updatable
deferred constraints, A-4
updating, 3-22
upgrading to primary key, B-10
using PL/SQL triggers with base tables, 5-27
viewing information about, 7-37
Snapshots page
Create Refresh Group property sheet, 5-29
SNP background processes, 2-11
space
reducing snapshot log, 7-24
statistics
auditing conflict resolution, 7-18
deleting, 7-19
for conflict resolution, 7-18
Stop on Error setting
Create New Scheduled Link property sheet, 2-13
Storage page
Snapshot Log property sheet, 7-23
storage parameters
snapshot log
altering, 7-23
storage settings
editing for snapshots, 5-27
store-and-forward replication, 2-3
subqueries for snapshots, A-3
subquery snapshots
AND expression and, 3-13
EXIST clause and, 3-13
filter columns requirement, 3-13
joins for, 3-13
many-to-many references, 3-13
many-to-one references, 3-13
number of columns in master tables, 3-13
survivability, 8-11
design considerations, 8-13
Parallel Server and, 8-12
SUSPEND_MASTER_ACTIVITY procedure
DBMS_REPCAT package, 2-23
synchronous data propagation, 1-15, 8-6
synchronously replicated transactions
destination of, 8-8
system-based security, A-4

T

table data
replicating to master sites, 2-27
tables
intersection, ?? to 3-13
master groups
generating replication support for, 2-37
modifying
without replicating changes, 8-34
partitioned
replicating, 2-26
partitioned and indexes, A-4
problems generating replication support for, 7-32
rectifying, 7-19
reorg, A-4
Tablespace and Extents page
Edit Snapshot property sheet, 5-27
timestamp conflict resolution methods
sample trigger, 6-32
token passing, 8-31
sample implementation, 8-30
trace file
snapshots, 7-35
transactions
deferred
deleting, 7-11
executing, 7-10
error
displaying, 7-12
propagation
protection mechanisms, 2-42 to 2-44
queue for
deferred, diagnosing problems with, 7-33
serialization of, 8-3
triggers
internal, A-2
replicating, 8-36
troubleshooting, 7-29
TRUNCATE command, 7-25
TRUNCATE TABLE command
PRESERVE SNAPSHOT LOG option, 7-26
PURGE SNAPSHOT LOG option, 7-26

U

UNIQUE constraint
simple subquery snapshots and, 3-13
uniqueness conflicts, 6-3
avoiding, 6-5
resolution, 6-8
configuring, 6-34
resolution methods, 6-9
assigning, 6-34
removing, 6-35
resolving, 6-50
UNREGISTER_SNAPSHOT procedure
DBMS_SNAPSHOT package, 7-37
UNSCHEDULE_PUSH procedure
DBMS_DEFER_SYS package, 2-16
update conflicts, 6-3
avoiding, 6-5
resolution
and column groups, 6-7
using site priority for, 6-29
resolution methods
assigning, 6-17
prebuilt, 6-8
resolution of
minimizing data propagation for, 6-42
resolving, 6-49
updateable snapshot, 1-8
updates
and min_communication, 6-43
minimizing communication, 6-43
updating
Comments, 7-38
replication tables, 7-38
USER_REFRESH view, 7-35
USER_REFRESH_CHILDREN view, 7-35
user-defined
notification methods, 6-52
user-defined conflict resolution method, 6-48

V

views
DBA_REGISTERED_SNAPSHOTS, 7-37
DBA_SNAPSHOT_LOGS, 7-37
REPCATLOG, 2-40, 7-6 to 7-8
REPGROUP, 2-40
REPOBJECT, 2-40
REPSITES, 2-40
USER_REFRESH, 7-35
USER_REFRESH_CHILDREN, 7-35

W

workflow, 8-30
wrapper
procedural replication, 1-15


Prev
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents