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

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