Skip Headers
Oracle® Database Advanced Replication
10g Release 2 (10.2)

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

Go to previous page
Previous
View PDF

Index

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

A

accounts
creating for materialized views, 6.3.3.3
additive conflict resolution method, 5.2.3.1
administrative request queue, 2.2.2.4
administrative requests, 2.2.2.3
states, 2.2.2.4
AWAIT_CALLBACK, 2.2.2.4
DO_CALLBACK, 2.2.2.4
ERROR, 2.2.2.4
READY, 2.2.2.4
aliases
for columns
updatable materialized views, 3.1.3.2
AND condition
for simple subquery materialized views, 3.1.6.2
append sequence conflict resolution method, 5.2.4.2
append site name conflict resolution method, 5.2.4.1
assignment tables, 4.4.2.1
asynchronous replication, 1.4.1, 2.2.4.1.1
average conflict resolution method, 5.2.3.2

B

bulk updates, A.2.5
BYTE character semantics, B.1

C

CHAR character semantics, B.1
character sets
replication, B
collections
materialized views, 3.1.9.4
restrictions, 3.1.9.4.1
replication, 2.1.5.3, 3.1.9.4
column groups, 5.2.1.1
column objects, 5.2.1.1.3
nested tables, 5.2.1.1.5
object tables, 5.2.1.1.4
shadow, 5.2.1.1.2
column objects
column groups, 5.2.1.1.3
conflict resolution
compare old values, 5.2.6.2
send old values, 5.2.6.2
materialized views
column subsetting, 3.1.9.2
replication, 2.1.5, 3.1.9
column subsetting, 1.4.2.4
deployment templates, 4.4.1
materialized views
column objects, 3.1.9.2
updatable materialized views
conflict resolution, 5.1.5.2
columns
character semantics, B.1
column groups, 2.2.3.2, 5.2.1.1
column objects, 5.2.1.1.3
ensuring data integrity with multiple, 5.2.1.1.1
nested tables, 5.2.1.1.5
object tables, 5.2.1.1.4
shadow, 5.2.1.1.2
complete refresh, 1.4.2.5, 3.2.4.1.1
complex materialized views, 3.1.4.4, 3.1.4.4.1
value for PCTFREE, 3.2.4.1.1
value for PCTUSED, 3.2.4.1.1
conflict resolution, 2.2.7.2
additive method, 5.2.3.1
append sequence method, 5.2.4.2
append site name method, 5.2.4.1
architecture, 5.2
average method, 5.2.3.2
avoiding conflicts, 5.1.6
column groups, 5.2.1.1
column objects, 5.2.1.1.3
data integrity, 5.2.1.1.1
nested tables, 5.2.1.1.5
object tables, 5.2.1.1.4
shadow, 5.2.1.1.2
column subsetting
updatable materialized views, 5.1.5.2
concepts, 5.1
convergence properties of methods, 5.2.3
data requirements, 5.1.1
delete conflicts, 5.1.2.3
detecting conflicts, 5.1.4
discard method, 5.2.3.3, 5.2.4.3
dynamic site ownership, 5.1.6.2
earliest timestamp method, 5.2.3.4
error queue, 5.2.1.2
in synchronous propagation, 2.2.4.2.1
latest timestamp method, 5.2.2.1
maximum method, 5.2.3.5
methods for delete conflicts, 5.2.5
methods for uniqueness conflicts, 5.2.4
methods for update conflicts, 5.2.2
minimum method, 5.2.3.6
multitier materialized views, 5.1.5.1
nested tables, 5.1.5.3
overwrite method, 5.2.2.2
performance
compare old values, 5.2.6
send old values, 5.2.6
prebuilt methods, 5.1.5
primary site ownership, 5.1.6.2
priority groups method, 5.2.3.7
replication, 1.6, 2.1.4
site priority method, 5.2.3.8
as backup, 5.2.2.1, 5.2.3.4
transaction ordering, 5.1.3
types of conflicts, 5.1.2
uniqueness conflicts, 5.1.2.2
updatable materialized views
column subsetting, 5.1.5.2
update conflicts, 5.1.2.1
conflicts
avoiding, 5.1.6
delete, 5.1.2.3
avoiding, 5.1.6.3.2
detecting, 2.2.4.2.3, 2.2.7, 5.1.4
identifying rows, 2.2.7.1, 5.1.4.2
error queue, 5.2.1.2
ordering
avoiding, 5.1.6.3.4
procedural replication, 1.7.2.1
uniqueness, 5.1.2.2
avoiding, 5.1.6.3.1
update, 5.1.2.1
avoiding, 5.1.6.3.3
connection qualifiers, 2.2.1.2.2
diagnosing problems with, A.1
constraint violations, A.2.5
constraints
deferrable, 3.2.4.3
referential
self-referencing, 2.2.1.3.1
continuous purges
scheduling, 6.6.2
continuous pushes
scheduling, 6.5.2
Copy Template Wizard, 7.4.5
CREATE TYPE statement
OID clause, 2.1.5.1.2, 3.1.9.1.2
CREATE_MVIEW_REPGROUP procedure, 3.1.3.2
CREATE_MVIEW_REPOBJECT procedure, 3.1.3.2

D

data dictionary
replication, 1.5.3
data integrity
parallel propagation, 2.2.6.1.1
serial propagation, 2.2.6.1.1
data propagation
and dependency maintenance, 2.2.6.1
asynchronous, 2.2.4.1.1
synchronous, 2.2.4.1.2
database links
connection qualifiers, 2.2.1.2.2
diagnosing problems with, A.1
incomplete specifications, A.3.3
materialized view sites, 6.3.3.4, 6.8.1.5
replication, 2.2.1.2
Replication Management tool, 2.2.1.2.1
scheduled links, 1.4.3.1
date expressions, 3.2.4.2.1, 4.3.3.2
DBA_MVIEW_REFRESH_TIMES view, 3.1.10.1
DBA_REGISTERED_MVIEWS view, 3.1.10.1
DBA_REPCATLOG view, 2.2.2.3.1
DBA_TYPE_VERSIONS
replication, 2.1.5.1, 3.1.9.1
DBMS_DEFER_SYS package
SCHEDULE_PUSH procedure, 6.5.1, 6.5.2
DBMS_MVIEW package, 3.1.10.3
EXPLAIN_MVIEW procedure, 3.1.7
REGISTER_MVIEW procedure, 3.1.10.3
DBMS_REPCAT package, 2.2.2.3.1, 2.2.2.3.1, 2.2.2.4, 3.1.3.2, 6.11.3.1.1
COMPARE_OLD_VALUES procedure
conflict resolution, 5.2.6
CREATE_MVIEW_REPGROUP procedure, 3.1.3.2
DO_DEFERRED_REPCAT_ADMIN procedure, 2.2.2.3.1, 2.2.2.4
SEND_OLD_VALUES procedure
conflict resolution, 5.2.6
DDL statements
replication, 1.5.4
troubleshooting problems, A.2.2
deadlocks
resolving
in synchronous propagation, 2.2.4.2.1
deferred transaction queues, 1.4.1, 2.2.1.6
diagnosing problems with, A.3
purging propagated transactions, 6.6
pushing, 2.2.1.8.3
scheduled purge, 6.3.3.6
scheduled push, 6.3.3.7
DELAY_SECONDS parameter, 2.2.5.3
dependencies
minimizing, 2.2.6.1.3
dependency
ordering
replicated transactions, 2.2.6.1
tracking
parallel propagation, 2.2.6.1.1
row level, 2.2.6.1.2, 6.1.4
Deployment Template Wizard, 7.4.3
deployment templates, 1.4.2.8, 4
adding materialized views to, 4.3.1.1
after instantiation, 4.3.3
architecture, 4.3
column subsetting, 4.4.1
concepts, 4.2
data sets, 4.4.3
DDL statements, 4.3.1.1
definition storage, 4.3.1
design, 4.4
elements, 4.2.1
general template information, 4.2.1.1
instantiation, 1.4.2.8.1, 4.2.2
offline, 4.2.2.2, 4.3.2.4
online, 4.2.2.1, 4.3.2.3
options, 4.3.2.5
process, 4.3.2
scenarios, 4.2.2.3
troubleshooting, A.4.2
local control, 4.5.1
materialized view groups, 4.3.3.1
materialized view logs, 4.2.2.3
materialized view sites, 4.2.1.6
objects
definitions, 4.2.1.2, 4.3.1.1
packaging, 4.2.2
for offline instantiation, 4.3.2.2
for online instantiation, 4.3.2.1
options, 4.3.2.5
procedures, 4.2.2.3
process, 4.3.2
parameters, 4.2.1.3
security, 4.2.1.4
preparing materialized view sites for, 6.8
refresh groups, 4.3.3.2
row subsetting, 4.4.2
user authorization, 4.2.1.5
user-defined types, 4.2.1.2
WHERE clause, 4.2.1.4
direct path load
fast refresh, 3.2.4.1.2
discard conflict resolution method, 5.2.3.3, 5.2.4.3
distributed schema management, 1.5.4
distributed transactions
problems with, A.3.2
DML statements
replication
troubleshooting problems, A.2.3
DO_DEFERRED_REPCAT_ADMIN procedure, 2.2.2.3.1, 2.2.2.3.1, 2.2.2.4
domain indexes
replication, 2.2.1.3.2
dynamic sites
ownership, 5.1.6.2

E

earliest timestamp conflict resolution method, 5.2.3.4
errors
error queues, 2.2.1.8.2
conflicts, 5.2.1.2
EXISTS condition
materialized views with subqueries, 3.1.6.2
EXPLAIN_MVIEW procedure, 3.1.7

F

failover sites
implementing using FAILOVER option, 6.11.3
fast refresh, 1.4.2.5, 3.2.4.1.2
avoiding problems, 6.3.6
determining possibility of, 3.1.7
direct path load, 3.2.4.1.2
multitier materialized views, 3.2.4.1.2
filter columns, 6.3.4.1
force refresh, 1.4.2.5, 3.2.4.1.3
foreign keys
replicated tables, 6.1.2
function-based indexes
replication, 2.2.1.3.1
functions
replicating, 2.2.1.3.4

G

GLOBAL_NAMES initialization parameter, 6.2
group owner
materialized view groups, 3.2.3.1.1

H

horizontal partitioning. See row subsetting

I

Import
materialized view logs, 3.2.1.3.2
replication check, 6.11.3.1.1
indexes
materialized view sites, 3.2.2.1
on foreign keys, 6.1.2
replication, 2.2.1.3.2
indextypes
replication, 2.2.1.3.8
initialization parameters
editing, 6.3.3.8
GLOBAL_NAMES, 6.2
JOB_QUEUE_PROCESSES, 2.2.2.3.1, 6.2
NLS_LENGTH_SEMANTICS, B.1
OPEN_LINKS, 2.2.1.2.2, 6.2
PARALLEL_MAX_SERVERS, 2.2.5.1, 6.2
PARALLEL_MIN_SERVERS, 2.2.5.1, 6.2
PROCESSES, 6.2
replication, 6.2
REPLICATION_DEPENDENCY_TRACKING, 6.2
SGA_TARGET, 6.2
SHARED_POOL_SIZE, 6.2
INIT.ORA parameters. See initialization parameters
instantiation
deployment templates, 1.4.2.8.1, 4.2.2
interoperability
replication, 6.4

J

job queue processes
replication, 6.3.3.8
job queues, 2.2.1.8.3
JOB_QUEUE_PROCESSES initialization parameter, 2.2.2.3.1, 6.2, 6.3.3.8
jobs
checking for scheduled links, A.3.1
replication, 2.2.2.3.1

L

latest timestamp
conflict resolution method, 5.2.2.1
length semantics
replication, B.1
levels
multitier materialized views, 3.1.8

M

many to many subqueries
materialized views, 3.1.6.1.3
many to one subqueries
materialized views, 3.1.6.1.1
mass deployment, 3.1.2.2, 4.1
master definition site, 1.3.3, 2.1.1.3.1
master groups, 1.3.3, 2.2.3.1
master materialized view sites, 3.2.1
master materialized views, 1.4.2, 3.1.8, 3.2.1.1
materialized view logs, 3.2.1.3
master sites, 1.3.3
adding
circular dependencies, 2.2.1.3.1
self-referential constraints, 2.2.1.3.1
advantages of, 6.3.1
bulk updates, A.2.5
compared with materialized view sites, 6.3
constraints
violations, A.2.5
DDL changes not propagated, A.2.2
diagnosing problems with, A.2
DML changes not propagated, A.2.3
internal triggers, 3.2.1.2
length semantics, B.2
precreated tables, B.2.2
materialized view registration, 3.1.10
materialized views, 3.2.1
replicated objects not created at new, A.2.1
replication, 2.2.1
roles, 2.2.1.1
scheduled links for
guidelines, 6.5
scheduled purges for, 6.3.3.6
guidelines, 6.6
users, 2.2.1.1
master tables
materialized view logs, 3.2.1.3
materialized views, 3.2.1.1
redefining online, 3.2.1.3
reorganizing, 3.2.1.3
Materialized View Group Wizard, 7.4.2
materialized view groups, 1.3.3, 3.1.8.2.2, 3.2.3.1
deployment templates, 4.3.3.1
group owner, 3.2.3.1.1
ownership, 3.1.8.2.2
updatable materialized views, 3.2.3.1
materialized view logs, 1.4.2.7, 3.2.1.3
adding columns to, 6.3.4.1
column logging, 3.1.6.2
many to many subqueries, 3.1.6.2
many to one subqueries, 3.1.6.2
ON PREBUILT TABLE clause, 3.1.6.2
one to many subqueries, 3.1.6.2
combination, 3.2.1.3
creating, 6.3.4
deployment templates, 4.2.2.3
filter columns, 6.3.4.1
Import, 3.2.1.3.2
join columns, 6.3.4.1
logging columns, 6.3.4.1
object ID, 3.2.1.3
object tables, 3.2.1.3.1
primary key, 3.2.1.3
privileges required to create, 6.3.4
REFs, 3.1.9.5.3
ROWID, 3.2.1.3
trigger, 3.2.1.2
troubleshooting, A.4.3.5
underlying table for, 3.2.1.3
materialized view sites, 1.3.3
adding
avoiding problems, 6.3.6
advantages of, 6.3.2
compared with master sites, 6.3
database links, 6.3.3.4, 6.8.1.5
database version, 6.8.1.2
deferred transaction queues
scheduled push, 6.3.3.7
deployment templates, 4.2.1.6
length semantics, B.3
prebuilt container tables, B.3.1
local creation, 4.5
network connectivity, 6.8.1.1
preparing for deployment templates, 6.8
rollback segments, 6.8.1.7
schedule purge
guidelines, 6.6
scheduled links for
guidelines, 6.5
schemas, 6.8.1.4
setup, 6.8.1.3
materialized views, 1.4.2, 3
architecture, 3.2
BUILD DEFERRED
troubleshooting, A.4.4
capabilities, 3.1.7
collection columns
restrictions, 3.1.9.4.1
column objects
column subsetting, 3.1.9.2
column subsetting, 1.4.2.4
column objects, 3.1.9.2
complex, 3.1.4.4, 3.1.4.4.1
value for PCTFREE, 3.2.4.1.1
value for PCTUSED, 3.2.4.1.1
concepts, 3.1
constraints
deferrable, 3.2.4.3
creating, 6.3.5
creating schemas for, 6.3.3.3
creator, 3.1.5
data subsetting, 3.1.2.3, 3.1.6
deployment templates, 1.4.2.8, 4
user-defined types, 4.2.1.2
disconnected computing, 3.1.2.4
index, 3.2.2.1
length semantics, B.3
prebuilt container tables, B.3.1
local control, 4.5.1
mass deployment, 3.1.2.2
master materialized view sites, 3.2.1
master materialized views, 3.2.1.1
master sites, 3.2.1
master tables, 3.2.1.1
materialized view groups, 3.2.3.1
materialized view logs, 1.4.2.7, 3.2.1.3
multitier, 1.4.2, 3.1.8, 3.1.8.2.2
conflict resolution, 5.1.5.1
fast refresh, 3.2.4.1.2
levels, 3.1.8
master materialized views, 3.1.8
restrictions, 3.1.8.2
nested tables
restrictions, 3.1.9.4.1
network loads, 3.1.2.1
object materialized views, 3.1.9.3.1
OID preservation, 3.1.9.3.3
object tables, 3.1.9.3
owner, 3.1.5
Partition Change Tracking (PCT), 3.2.4.1.2
preparing for, 6.3.3
primary key, 3.1.4.1, 3.1.6.2
privileges, 3.1.5, 6.3.3.5
read-only, 1.4.2.1, 3.1.3.1
registration, 3.1.10.3
unregistering, 3.1.10.3
refresh groups, 1.4.2.6, 3.2.3.2
size, 3.2.3.3
refresher, 3.1.5
refreshing, 1.4.2.5, 3.2.4
complete, 3.2.4.1.1
failures, A.4.3.2
fast, 3.1.7, 3.2.4.1.2
force, 3.2.4.1.3
initiating, 3.2.4.2
interval, 3.2.4.2.1
on-demand, 3.2.4.2.2
querying for last refresh time, 3.1.10.1
retries, A.4.3.2
troubleshooting, A.4.3, A.4.3.4
REFs, 3.1.9.5
logging, 3.1.9.5.3
scoped, 3.1.9.5.1
unscoped, 3.1.9.5.2
WITH ROWID clause, 3.1.9.5.4
registration, 3.1.10
reorganizing, 3.2.1.3
row subsetting, 1.4.2.4, 3.1.6
rowid, 3.1.4.3
simple, 3.1.4.4.1
simple subquery
AND condition, 3.1.6.2
subqueries, 3.1.6.1
column logging, 3.1.6.2
EXISTS condition, 3.1.6.2
joins, 3.1.6.2
many to many, 3.1.6.1.3
many to one, 3.1.6.1.1
one to many, 3.1.6.1.2
OR condition, 3.1.6.2
primary key materialized views, 3.1.6.2
restrictions, 3.1.6.2, 3.1.6.2
trace file, A.4.3.2
troubleshooting, A.4
types of, 3.1.4
unions with subqueries, 3.1.6.1.4
restrictions, 3.1.6.3
updatable, 1.4.2.2, 3.1.3.2
column aliases, 3.1.3.2
DELETE CASCADE constraint, 3.1.3.2, 3.2.4.3
length semantics, B.3.2
materialized view groups, 3.2.3.1
updatable materialized view logs, 3.2.2.2
trigger for, 3.2.2.3
user-define, 3.1.9
user-defined datatypes
ON COMMIT REFRESH clause, 3.1.9
uses for, 3.1.2
varrays
r, 3.1.9.4.1
writeable, 3.1.3.3
maximum conflict resolution method, 5.2.3.5
minimum communication, 2.2.5.2
minimum conflict resolution method, 5.2.3.6
multimaster replication, 1.4.1, 2
architecture, 2.2
asynchronous, 2.1.3, 2.1.3.1
concepts, 2.1
disconnected materialized views, 2.1.2.3
failover, 2.1.2.1
load balancing, 2.1.2.2
synchronous, 2.1.3, 2.1.3.2
transaction propagation protection, 2.2.6
uses for, 2.1.2
multitier materialized views, 1.4.2, 3.1.8
conflict resolution, 5.1.5.1
fast refresh, 3.2.4.1.2
levels, 3.1.8
master materialized views, 3.1.8
restrictions, 3.1.8.2.1
materialized view groups
ownership, 3.1.8.2.2
restrictions, 3.1.8.2

N

NCHAR datatype
Unicode, B.5
interoperability, B.5
NCLOB datatype
length semantics, B.5.1
nested tables
column groups, 5.2.1.1.5
conflict resolution, 5.1.5.3
materialized views, 3.1.9.4
restrictions, 3.1.9.4.1
replication, 2.1.5.3, 3.1.9.4
network
FAILOVER option, 6.11.3
NLS_LENGTH_SEMANTICS initialization parameter, B.1
NOROWDEPENDENCIES clause, 2.2.6.1.2
NVARCHAR datatype
Unicode, B.5
interoperability, B.5
n-way replication. See multimaster replication

O

object identifiers
agreement for replication, 2.1.5.1, 3.1.9.1
object materialized views, 3.1.9.3.1
OID preservation, 3.1.9.3.3
object tables
column groups, 5.2.1.1.4
materialized view logs, 3.2.1.3.1
materialized views, 3.1.9.3
replication, 2.1.5.2
object-relational model
replication, 2.1.5, 3.1.9
objects
replicated
re-creating, A.2.6
OF object_type clause
object materialized views, 3.1.9.3.1
OID clause
CREATE TYPE statement, 2.1.5.1.2, 3.1.9.1.2
ON COMMIT REFRESH clause
of CREATE MATERIALIZED VIEW, 3.1.9
ON PREBUILT TABLE clause, 3.1.6.2
length semantics, B.3.1
one to many subqueries
materialized views, 3.1.6.1.2
online redefinition of tables, 3.2.1.3
OPEN_LINKS initialization parameter, 2.2.1.2.2, 6.2
OR condition
materialized views with subqueries, 3.1.6.2
Oracle Data Pump
Advanced Replication, 1.5.4
Oracle Enterprise Manager Console
Oracle Replication Management tool, 7
Oracle Real Application Clusters
compared to replication, 2.1.2.4, 6.11.1
Oracle Replication Management tool, 1.5.1, 7
first login, 7.2
interface, 7.3
Navigator pane, 7.3.1
right pane, 7.3.2
Topology tab, 7.3.2.1
usage scenarios, 7.1
wizards, 7.4
Copy Template, 7.4.5
Deployment Template, 7.4.3
Materialized View Group, 7.4.2
Setup, 7.4.1
Template Script Generation Wizard, 7.4.4
overwrite conflict resolution method, 5.2.2.2

P

packages
replication, 2.2.1.3.3
packaging deployment templates, 4.2.2
parallel propagation, 2.2.5.1
configuring for replication environments, 2.2.5.1
dependency
tracking, 2.2.6.1.1
implementing, 2.2.5.1.1
planning for, 6.7
replication environment, 6.7
row level SCN, 2.2.6.1.2
tuning, 2.2.5.1.2
PARALLEL_MAX_SERVERS initialization parameter, 2.2.5.1, 6.2
PARALLEL_MIN_SERVERS initialization parameter, 2.2.5.1, 6.2
parameters
deployment templates, 4.2.1.3
PCTFREE parameter
value for complex materialized views, 3.2.4.1.1
PCTUSED parameter
value for complex materialized views, 3.2.4.1.1
peer-to-peer replication. See multimaster replication
performance
replication, 2.2.5
periodic purges
scheduling, 6.6.1
periodic pushes
scheduling, 6.5.1
planning
for replication, 6
PRIMARY KEY constraints
materialized views, 3.1.4.1, 3.1.6.2
replicated tables, 6.1.1
primary sites
ownership, 5.1.6.2
priority groups conflict resolution method, 5.2.3.7
privileges
materialized views, 3.1.5, 6.3.3.5
procedural replication, 1.7.2
detecting conflicts, 1.7.2.1
restrictions, 2.2.1.3.3
wrapper, 1.7.2
procedures
replicating, 2.2.1.3.4
PROCESSES initialization parameter, 6.2
propagation, 2.2.4
initiating, 2.2.4.4
modes, 2.2.4.3
parallel, 2.2.5.1
implementing, 2.2.5.1.1
tuning, 2.2.5.1.2
security context of propagator, 2.2.4.2
propagator
replication, 2.2.1.1.2
purges
deferred transaction queue
scheduling continuous, 6.6.2
scheduling periodic, 6.6.1
pushes
deferred transaction queue
scheduling continuous, 6.5.2
scheduling periodic, 6.5.1

Q

quiescing, 1.4.1.1, 2.2.2.1
single master
reduced, 3.1.3.2

R

read-o, 3.1.10.3
read-only materialized views, 1.4.2.1, 3.1.3.1
registration
manual, 3.1.10.3
receiver
replication, 2.2.1.1.3
recovery
replication environments, 6.11.3.1
redefining tables
online
replication, 3.2.1.3
referential integrity
self-referential constraints, 2.2.1.3.1
refresh
automatic, 3.2.4.2.1
complete, 3.2.4.1.1
failures, A.4.3.2
fast, 3.2.4.1.2
determining possibility of, 3.1.7
force, 3.2.4.1.3
group, 3.2.4.2.1
initiating, 3.2.4.2
interval, 3.2.4.2.1
manual, 3.2.4.2.2
materialized views, 1.4.2.5, 3.2.4
on-demand, 3.2.4.2.2
retries, A.4.3.2
rollback segments
troubleshooting, A.4.4
scheduling, 3.2.4.2.1
troubleshooting, A.4.4
troubleshooting
ORA-12004 error, A.4.4
ORA-942 error, A.4.4
truncating materialized views
troubleshooting, A.4.4
refresh groups, 1.3.3, 1.4.2.6, 3.2.3.2
deployment templates, 4.3.3.2
size considerations, 3.2.3.3
troubleshooting, A.4.3
REFRESH procedure, 3.2.4.2.2
REFRESH_ALL_MVIEWS procedure, 3.2.4.2.2
REFRESH_DEPENDENT procedure, 3.2.4.2.2
REFs
materialized views, 3.1.9.5
replication, 2.1.5.4, 3.1.9.5
REGISTER_MVIEW procedure, 3.1.10.3
REPCAT_IMPORT_CHECK procedure, 6.11.3.1.1
replication
administration, 1.5, 2.2.2
administrative request queue, 2.2.2.4
administrative requests, 2.2.2.3
states, 2.2.2.4
applications that use, 1.2
assignment tables, 4.4.2.1
asynchronous propagation, 1.4.1, 2.2.4.1.1
availability, 6.11
character sets, B
checking imported data, 6.11.3.1.1
column groups, 2.2.3.2
column subsetting, 1.4.2.4
compared to Oracle Real Application Clusters, 2.1.2.4, 6.11.1
conflict resolution, 1.6, 2.1.4, 2.2.7.2
conflicts
detecting, 2.2.7
procedural replication, 1.7.2.1
connection qualifiers, 2.2.1.2.2
creating an environment, 7.5
data requirements, 5.1.1
database links, 2.2.1.2
CONNECT TO clause, 2.2.1.2
Replication Management tool, 2.2.1.2.1
USING clause, 2.2.1.2
DDL statements, 1.5.4
deferred transaction queues, 2.2.1.8.1
diagnosing problems with, A.3
deferred transactions, 1.4.1, 2.2.1.6
defined, 1.1
DELAY_SECONDS parameter, 2.2.5.3
dependencies
minimizing, 2.2.6.1.3
dependency tracking, 2.2.6.1.2
deployment templates, 1.4.2.8, 4
user-defined types, 4.2.1.2
distributed schema management, 1.5.4
error queues, 2.2.1.8.2
failover, 6.11.3
filter columns, 6.3.4.1
flowchart for creating environment, 7.5
groups, 1.3.2, 2.2.3.1
hybrid configurations, 1.4.3
Import check, 6.11.3.1.1
indextypes, 2.2.1.3.8
initialization parameters, 6.2
internal procedures, 2.2.1.7
internal triggers, 2.2.1.5
interoperability, 6.4
NCHAR datatype, B.5
NVARCHAR datatype, B.5
introduction, 1.1
job queue processes, 6.3.3.8
job queues, 2.2.1.8.3
jobs, 2.2.2.3.1
mass deployment, 4.1
master, 1.4.2
master definition site, 1.3.3
master groups, 1.3.3, 2.2.3.1
master materialized views, 1.4.2
master sites, 1.3.3, 2.2.1
advantages, 6.3.1
materialized view groups, 1.3.3
materialized view logs, 1.4.2.7
materialized view sites
advantages, 6.3.2
materialized views, 1.4.2, 3
minimum communication, 2.2.5.2
modes, 2.2.2.1
multimaster, 1.4.1, 2
multitier materialized views, 1.4.2
objects, 2.2.1.3
performance, 2.2.5
planning for, 6
problems
troubleshooting, A
procedural replication, 1.7.2
procedures
troubleshooting, A.2.8
propagation, 2.2.4
propagator, 2.2.1.1.2
quiesce, 1.4.1.1, 2.2.2.1
real-time replication. See synchronous replication
receiver, 2.2.1.1.3
refresh, 1.4.2.5
refresh groups, 1.3.3, 1.4.2.6
replication administrator, 2.2.1.1.1
replication management API, 1.5.2
resuming, 2.2.2.2.2
row subsetting, 1.4.2.4
scheduled links, 1.4.3.1
See Also materialized views
single master, 2.1.1.2
sites, 1.3.3
choosing, 6.3
survivability, 6.11
suspending, 2.2.2.2.1
synchronous, 1.7.1, 2.2.4.1.2
tables, 6.1
and DML incompatibility, A.2.4
dependency tracking, 6.1.4
DML incompatibility, A.2.4
transaction propagation protection, 2.2.6
transactions
dependency ordering, 2.2.6.1
triggers
troubleshooting, A.2.8
troubleshooting, A
Unicode, B.5
unsupported datatypes
BFILE, 6.1.3
LONG, 6.1.3
user-defined datatypes, 2.1.5, 3.1.9
uses of, 1.1
virtual private database (VPD), 6.3.3.4
replication catalog, 1.5.3
DBA_MVIEW_REFRESH_TIMES, 3.1.10.1
DBA_REGISTERED_MVIEWS, 3.1.10.1
DBA_REPCATLOG, 2.2.2.3.1
incorrect views, A.3.4
USER_REFRESH, A.4.3.2
USER_REFRESH_CHILDREN, A.4.3.2
replication management API, 1.5.2, 2.2.2.3
Replication Management tool. See Oracle Replication Management tool
replication objects, 1.3.1, 2.2.1.3.7, 2.2.1.3.7
at materialized view sites
problems creating, A.4.1
functions, 2.2.1.3.4
indexes, 2.2.1.3.2
function-based, 2.2.1.3.1
on foreign keys, 6.1.2
packages, 2.2.1.3.3
procedures, 2.2.1.3.4
re-creating, A.2.6
sequences, 2.2.1.4
tables, 2.2.1.3.1, 6.1
dependency tracking, 6.1.4
DML incompatibility, A.2.4
foreign keys, 6.1.2
primary keys, 6.1.1
unable to generate support for, A.2.7
triggers, 2.2.1.3.6
REPLICATION_DEPENDENCY_TRACKING initialization parameter, 6.2
restrictions
procedural replication, 2.2.1.3.3
rollback segments
materialized view sites, 6.8.1.7
row subsetting, 1.4.2.4
deployment templates, 4.4.2
materialized views, 3.1.6
ROWDEPENDENCIES clause, 2.2.6.1.2
creating tables, 6.1.4
rowids
rowid materialized views, 3.1.4.3
rows
identifying during conflict detection, 2.2.7.1

S

SCHEDULE_PUSH procedure, 6.5.1, 6.5.2
scheduled links, 1.4.3.1, 6.3.3.7
continuous pushes, 6.5.2
guidelines, 6.5
parallel propagation, 6.7
periodic pushes, 6.5.1
serial propagation, 6.7
scheduled purges
guidelines, 6.6
periodic purges, 6.6.1
schemas
creating for materialized views, 6.3.3.3
security
deployment templates, 4.2.1.4
SEND_OLD_VALUES procedure, 5.2.6
sequences
replication, 2.2.1.4
Setup Wizard, 7.4.1
SGA_TARGET initialization parameter, 6.2
shadow column groups, 5.2.1.1.2
SHARED_POOL_SIZE initialization parameter, 6.2
simple materialized views, 3.1.4.4.1
site priority conflict resolution method, 5.2.3.8
as a backup method, 5.2.2.1, 5.2.3.4
snapshots. See materialized views
store-and-forward replication. See asynchronous replication
subqueries
in unions
materialized views, 3.1.6.1.4
materialized views, 3.1.6.1, 3.1.6.2
AND condition, 3.1.6.2
column logging, 3.1.6.2
EXISTS condition, 3.1.6.2
joins, 3.1.6.2
many to many, 3.1.6.1.3
many to one, 3.1.6.1.1
one to many, 3.1.6.1.2
primary key, 3.1.6.2
restrictions, 3.1.6.2
subsetting
materialized views, 3.1.6
column objects, 3.1.9.2
survivability, 6.11
design considerations, 6.11.2
implementing, 6.11.3
Oracle Real Application Clusters and, 6.11.1
synchronous replication, 1.7.1, 2.2.4.1.2, 2.2.4.1.2
of destination of transactions, 2.2.4.2.2
synonyms, 2.2.1.3.7
replication, 2.2.1.3.7
system change numbers
row level, 2.2.6.1.2, 6.1.4

T

tables
length semantics, B.2
precreated
length semantics, B.2.2
problems generating replication support for, A.2.7
redefining online
replication, 3.2.1.3
replicating, 2.2.1.3.1, 6.1
dependency tracking, 6.1.4
DML incompatibility, A.2.4
Template Script Generation Wizard, 7.4.4
trace files
materialized views, A.4.3.2
transactions
propagation
protection mechanisms, 2.2.6
triggers
for materialized view log, 3.2.1.2
for updatable materialized view logs, 3.2.2.3
replicating, 2.2.1.3.6
troubleshooting
replication problems, A

U

Unicode
NCHAR datatype, B.5
NVARCHAR datatype, B.5
replication, B.5
unions
with subqueries
materialized views, 3.1.6.1.4
restrictions for materialized views, 3.1.6.3
UNREGISTER_MVIEW procedure, 3.1.10.3
updatable, 5.1.5.2
updatable materialized view logs, 3.2.2.2
trigger for, 3.2.2.3
updatable materialized views, 1.4.2.2, 3.1.3.2
column subsetting, 5.1.5.2
DELETE CASCADE constraint, 3.1.3.2, 3.2.4.3
length semantics, B.3.2
materialized view groups, 3.2.3.1
us, 3.1.9.2
USER_REFRESH view, A.4.3.2
USER_REFRESH_CHILDREN view, A.4.3.2
user-defined datatypes
materialized views, 3.1.9
collections, 3.1.9.4
object tables, 3.1.9.3
ON COMMIT REFRESH clause, 3.1.9
REFs, 3.1.9.5
type agreement, 3.1.9.1
replication, 2.1.5, 3.1.9
collections, 2.1.5.3, 3.1.9.4
column objects, 2.1.5, 3.1.9
object tables, 2.1.5.2
REFs, 2.1.5.4, 3.1.9.5
type agreement, 2.1.5.1, 3.1.9.1
USLOG$_, 3.2.2.2

V

varrays
materialized, 3.1.9.4
materialized views
restrictions, 3.1.9.4.1
replication, 2.1.5.3, 3.1.9.4
vertical partitioning. See column subsetting
views, 2.2.1.3.7
replication, 2.2.1.3.7
virtual private database (VPD)
Advanced Replication requirements, 6.3.3.4

W

WHERE clause
deployment templates, 4.2.1.4
WITH ROWID clause
REFs, 3.1.9.5.4
wrapper
procedural replication, 1.7.2
writeable materialized views, 3.1.3.3