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-10

additive conflict resolution method, 5-28

administrative request queue, 2-36

administrative requests, 2-33

states, 2-36

AWAIT_CALLBACK, 2-36

DO_CALLBACK, 2-37

ERROR, 2-36

READY, 2-36

aliases

for columns

updatable materialized views, 3-7

AND condition

for simple subquery materialized views, 3-28

append sequence conflict resolution method, 5-39

append site name conflict resolution method, 5-38

assignment tables, 4-22

asynchronous replication, 1-6, 2-40

average conflict resolution method, 5-29

B

bulk updates, A-4

BYTE character semantics, B-2

C

CHAR character semantics, B-2

character sets

replication, B-1

collections

materialized views, 3-44

restrictions, 3-46

replication, 2-16, 3-44

column groups, 5-22

column objects, 5-23

nested tables, 5-23

object tables, 5-23

shadow, 5-23

column objects

column groups, 5-23

conflict resolution

compare old values, 5-44

send old values, 5-44

materialized views, 3-37

column subsetting, 3-41

replication, 2-12, 3-37

column subsetting, 1-11

deployment templates, 4-20

materialized views

column objects, 3-41

updatable materialized views

conflict resolution, 5-11

columns

character semantics, B-2

column groups, 2-39, 5-22

column objects, 5-23

ensuring data integrity with multiple, 5-22

nested tables, 5-23

object tables, 5-23

shadow, 5-23

COMPARE_OLD_VALUES procedure, 5-40

complete refresh, 1-12, 3-63

complex materialized views, 3-10, 3-13

value for PCTFREE, 3-64

value for PCTUSED, 3-64

conflict resolution, 2-57

additive method, 5-28

append sequence method, 5-39

append site name method, 5-38

architecture, 5-22

average method, 5-29

avoiding conflicts, 5-18

column groups, 5-22

column objects, 5-23

data integrity, 5-22

nested tables, 5-23

object tables, 5-23

shadow, 5-23

column subsetting

updatable materialized views, 5-11

concepts, 5-2

convergence properties of methods, 5-28

data requirements, 5-2

delete conflicts, 5-4

detecting conflicts, 5-5

discard method, 5-30, 5-39

dynamic site ownership, 5-18

earliest timestamp method, 5-31

error queue, 5-23

in synchronous propagation, 2-44

latest timestamp method, 5-24

maximum method, 5-32

methods for delete conflicts, 5-40

methods for uniqueness conflicts, 5-37

methods for update conflicts, 5-24

minimum method, 5-33

multitier materialized views, 5-8

nested tables, 5-12

overwrite method, 5-26

performance, 5-40

compare old values, 5-40

send old values, 5-40

prebuilt methods, 5-7

primary site ownership, 5-18

priority groups method, 5-34

replication, 1-18, 2-10

site priority method, 5-36

as backup, 5-25, 5-31

transaction ordering, 5-5

types of conflicts, 5-3

uniqueness conflicts, 5-4

updatable materialized views

column subsetting, 5-11

update conflicts, 5-4

conflicts

avoiding, 5-18

delete, 5-4

avoiding, 5-20

detecting, 2-44, 2-56, 5-5

identifying rows, 2-57, 5-6

error queue, 5-23

ordering

avoiding, 5-20

procedural replication, 1-20

uniqueness, 5-4

avoiding, 5-19

update, 5-4

avoiding, 5-20

connection qualifiers, 2-22

diagnosing problems with, A-2

constraint violations, A-4

constraints

deferrable, 3-69

referential

self-referencing, 2-25

continuous purges

scheduling, 6-25

continuous pushes

scheduling, 6-22

Copy Template Wizard, 7-24

CREATE TYPE statement

OID clause, 2-14, 3-40

CREATE_MVIEW_REPGROUP procedure, 3-6

CREATE_MVIEW_REPOBJECT procedure, 3-6

D

data dictionary

replication, 1-17

data integrity

parallel propagation, 2-54

serial propagation, 2-54

data propagation

and dependency maintenance, 2-53

asynchronous, 2-40

synchronous, 2-42

database links

connection qualifiers, 2-22

diagnosing problems with, A-2

incomplete specifications, A-6

materialized view sites, 6-11, 6-29

replication, 2-20

Replication Management tool, 2-21

scheduled links, 1-15

datatypes

allowed in replicated tables, 6-2

date expressions, 3-67, 4-19

DBA_MVIEW_REFRESH_TIMES view, 3-49

DBA_REGISTERED_MVIEWS view, 3-49

DBA_REPCATLOG view, 2-34

DBA_TYPE_VERSIONS

replication, 2-13, 3-39

DBMS_DEFER_SYS package

SCHEDULE_PUSH procedure, 6-21, 6-22

DBMS_MVIEW package, 3-50

EXPLAIN_MVIEW procedure, 3-30

REGISTER_MVIEW procedure, 3-50

DBMS_REPCAT package, 2-33, 2-34, 2-36, 3-6, 6-35

COMPARE_OLD_VALUES procedure

conflict resolution, 5-40

CREATE_MVIEW_REPGROUP procedure, 3-6

DO_DEFERRED_REPCAT_ADMIN procedure, 2-34, 2-36

SEND_OLD_VALUES procedure

conflict resolution, 5-40

DDL statements

replication, 1-17

troubleshooting problems, A-3

deadlocks

resolving

in synchronous propagation, 2-44

deferred transaction queues, 1-6, 2-30

diagnosing problems with, A-6

purging propagated transactions, 6-23

pushing, 2-31

scheduled purge, 6-13

scheduled push, 6-13

DELAY_SECONDS parameter, 2-50

dependencies

minimizing, 2-55

dependency

ordering

replicated transactions, 2-53

tracking

parallel propagation, 2-54

row level, 2-54, 6-4

Deployment Template Wizard, 7-20

deployment templates, 1-13, 4-1

adding materialized views to, 4-14

after instantiation, 4-18

architecture, 4-13

column subsetting, 4-20

concepts, 4-3

data sets, 4-26

DDL statements, 4-14

definition storage, 4-14

design, 4-20

elements, 4-4

general template information, 4-4

instantiation, 1-13, 4-10

offline, 4-11, 4-17

online, 4-10, 4-16

options, 4-18

process, 4-15

scenarios, 4-12

troubleshooting, A-8

local control, 4-29

materialized view groups, 4-19

materialized view logs, 4-13

materialized view sites, 4-9

objects

definitions, 4-7, 4-14

packaging, 4-10

for offline instantiation, 4-16

for online instantiation, 4-15

options, 4-18

procedures, 4-13

process, 4-15

parameters, 4-8

security, 4-9

preparing materialized view sites for, 6-27

refresh groups, 4-19

row subsetting, 4-22

user authorization, 4-9

user-defined types, 4-7

WHERE clause, 4-9

direct path load

fast refresh, 3-64

discard conflict resolution method, 5-30, 5-39

distributed schema management, 1-17

distributed transactions

problems with, A-6

DML statements

replication

troubleshooting problems, A-4

DO_DEFERRED_REPCAT_ADMIN procedure, 2-34, 2-36

domain indexes

replication, 2-26

dynamic sites

ownership, 5-18

E

earliest timestamp conflict resolution method, 5-31

errors

error queues, 2-31

conflicts, 5-23

EXISTS condition

materialized views with subqueries, 3-28

EXPLAIN_MVIEW procedure, 3-30

F

failover sites

implementing using FAILOVER option, 6-34

fast refresh, 1-12, 3-64

avoiding problems, 6-18

determining possibility of, 3-30

direct path load, 3-64

multitier materialized views, 3-65

filter columns, 6-15

force refresh, 1-12, 3-67

foreign keys

replicated tables, 6-2

functions

replicating, 2-27

G

GLOBAL_NAMES initialization parameter, 6-5

group owner

materialized view groups, 3-59

H

horizontal partitioning. See row subsetting

I

Import

materialized view logs, 3-55

replication check, 6-35

indexes

materialized view sites, 3-56

on foreign keys, 6-2

replication, 2-26

indextypes

replication, 2-28

initialization parameters

editing, 6-13

GLOBAL_NAMES, 6-5

JOB_QUEUE_PROCESSES, 2-34, 6-5

NLS_LENGTH_SEMANTICS, B-2

OPEN_LINKS, 2-23, 6-5

PARALLEL_MAX_SERVERS, 2-48, 6-6

PARALLEL_MIN_SERVERS, 2-48, 6-6

PROCESSES, 6-6

replication, 6-5

REPLICATION_DEPENDENCY_TRACKING, 6-7

SHARED_POOL_SIZE, 6-7

INIT.ORA parameters. See initialization parameters

instantiation

deployment templates, 1-13, 4-10

interoperability

replication, 6-20

J

job queue processes

replication, 6-13

job queues, 2-31

JOB_QUEUE_PROCESSES initialization parameter, 2-34, 6-5, 6-13

jobs

checking for scheduled links, A-6

replication, 2-33

L

latest timestamp

conflict resolution method, 5-24

length semantics

replication, B-2

levels

multitier materialized views, 3-31

LOBs

allowed in replicated tables, 6-2

replication support for, 6-3

M

many to many subqueries

materialized views, 3-22

many to one subqueries

materialized views, 3-19

mass deployment, 3-4, 4-2

master definition site, 1-5, 2-4

master groups, 1-5, 2-37

master materialized view sites, 3-52

master materialized views, 1-8, 3-32, 3-52

materialized view logs, 3-53

master sites, 1-5

adding

circular dependencies, 2-25

self-referential constraints, 2-25

advantages of, 6-8

bulk updates, A-4

compared with materialized view sites, 6-8

constraints

violations, A-4

DDL changes not propagated, A-3

diagnosing problems with, A-2

DML changes not propagated, A-4

internal triggers, 3-53

length semantics, B-3

precreated tables, B-4

materialized view registration, 3-49

materialized views, 3-52

replicated objects not created at new, A-3

replication, 2-18

roles, 2-19

scheduled links for

guidelines, 6-20

scheduled purges for, 6-13

guidelines, 6-23

users, 2-19

master tables

materialized view logs, 3-53

materialized views, 3-52

redefining online, 3-54

reorganizing, 3-54

Materialized View Group Wizard, 7-18

materialized view groups, 1-5, 3-37, 3-58

deployment templates, 4-19

group owner, 3-59

ownership, 3-37

updatable materialized views, 3-59

materialized view logs, 1-12, 3-53

adding columns to, 6-15

column logging, 3-28

many to many subqueries, 3-28

many to one subqueries, 3-28

ON PREBUILT TABLE clause, 3-28

one to many subqueries, 3-28

combination, 3-54

creating, 6-14

deployment templates, 4-13

filter columns, 6-15

Import, 3-55

join columns, 6-15

logging columns, 6-15

object ID, 3-54

object tables, 3-55

primary key, 3-53

privileges required to create, 6-14

REFs, 3-48

ROWID, 3-53

trigger, 3-53

troubleshooting, A-10

underlying table for, 3-53

materialized view sites, 1-5

adding

avoiding problems, 6-18

advantages of, 6-9

compared with master sites, 6-8

database links, 6-11, 6-29

database version, 6-28

deferred transaction queues

scheduled push, 6-13

deployment templates, 4-9

length semantics, B-5

prebuilt container tables, B-5

local creation, 4-28

network connectivity, 6-28

preparing for deployment templates, 6-27

rollback segments, 6-30

schedule purge

guidelines, 6-23

scheduled links for

guidelines, 6-20

schemas, 6-29

setup, 6-28

materialized views, 1-8, 3-1

architecture, 3-50

BUILD DEFERRED

troubleshooting, A-12

capabilities, 3-30

collection columns, 3-44

restrictions, 3-46

column objects

column subsetting, 3-41

column subsetting, 1-11

column objects, 3-41

complex, 3-10, 3-13

value for PCTFREE, 3-64

value for PCTUSED, 3-64

concepts, 3-2

constraints

deferrable, 3-69

creating, 6-16

creating schemas for, 6-10

creator, 3-15

data subsetting, 3-4, 3-18

deployment templates, 1-13, 4-1

user-defined types, 4-7

disconnected computing, 3-4

index, 3-56

length semantics, B-5

prebuilt container tables, B-5

LOBs, 6-3

local control, 4-29

mass deployment, 3-4

master materialized view sites, 3-52

master materialized views, 3-52

master sites, 3-52

master tables, 3-52

materialized view groups, 3-58

materialized view logs, 1-12, 3-53

multitier, 1-8, 3-31, 3-37

conflict resolution, 5-8

fast refresh, 3-65

levels, 3-31

master materialized views, 3-32

restrictions, 3-36

nested tables, 3-44

restrictions, 3-46

network loads, 3-3

object materialized views, 3-42

OID preservation, 3-43

object tables, 3-42

owner, 3-15

Partition Change Tracking (PCT), 3-65

preparing for, 6-9

primary key, 3-8, 3-28

privileges, 3-15, 6-12

read-only, 1-8, 3-5

registration, 3-50

unregistering, 3-50

refresh groups, 1-12, 3-60

size, 3-62

refresher, 3-15

refreshing, 1-12, 3-63

complete, 3-63

failures, A-9

fast, 3-30, 3-64

force, 3-67

initiating, 3-67

interval, 3-67

on-demand, 3-68

querying for last refresh time, 3-49

retries, A-9

troubleshooting, A-8, A-10

REFs, 3-46

logging, 3-48

scoped, 3-46

unscoped, 3-48

WITH ROWID clause, 3-48

registration, 3-49

reorganizing, 3-54

row subsetting, 1-11, 3-18

rowid, 3-10

simple, 3-13

simple subquery

AND condition, 3-28

subqueries, 3-19

column logging, 3-28

EXISTS condition, 3-28

joins, 3-28

many to many, 3-22

many to one, 3-19

one to many, 3-21

OR condition, 3-28

primary key materialized views, 3-28

restrictions, 3-27

trace file, A-9

troubleshooting, A-7

types of, 3-8

unions with subqueries, 3-24

restrictions, 3-29

updatable, 1-9, 3-5

column aliases, 3-7

DELETE CASCADE constraint, 3-7, 3-69

length semantics, B-6

materialized view groups, 3-59

updatable materialized view logs, 3-57

trigger for, 3-57

user-defined datatypes, 3-37

ON COMMIT REFRESH clause, 3-38

uses for, 3-3

varrays, 3-44

restrictions, 3-46

writeable, 3-7

maximum conflict resolution method, 5-32

minimum communication, 2-50

minimum conflict resolution method, 5-33

multimaster replication, 1-6, 2-1

architecture, 2-18

asynchronous, 2-7

concepts, 2-2

disconnected materialized views, 2-6

failover, 2-4

load balancing, 2-5

synchronous, 2-7, 2-9

transaction propagation protection, 2-52

uses for, 2-4

multitier materialized views, 1-8, 3-31

conflict resolution, 5-8

fast refresh, 3-65

levels, 3-31

master materialized views, 3-32

restrictions, 3-37

materialized view groups

ownership, 3-37

restrictions, 3-36

N

NCHAR datatype

Unicode, B-7

interoperability, B-8

NCLOB datatype

length semantics, B-9

nested tables

column groups, 5-23

conflict resolution, 5-12

materialized views, 3-44

restrictions, 3-46

replication, 2-16, 3-44

network

FAILOVER option, 6-34

NLS_LENGTH_SEMANTICS initialization parameter, B-2

NOROWDEPENDENCIES clause, 2-54

NVARCHAR datatype

Unicode, B-7

interoperability, B-8

n-way replication. See multimaster replication

O

object identifiers

agreement for replication, 2-13, 3-38

object materialized views, 3-42

OID preservation, 3-43

object tables

column groups, 5-23

materialized view logs, 3-55

materialized views, 3-42

replication, 2-15

object-relational model

materialized views, 3-37

replication, 2-12, 3-37

objects

replicated

re-creating, A-5

OF object_type clause

object materialized views, 3-42

OID clause

CREATE TYPE statement, 2-14, 3-40

ON COMMIT REFRESH clause

of CREATE MATERIALIZED VIEW, 3-38

ON PREBUILT TABLE clause, 3-28

length semantics, B-5

one to many subqueries

materialized views, 3-21

online redefinition of tables, 3-54

OPEN_LINKS initialization parameter, 2-23, 6-5

OR condition

materialized views with subqueries, 3-28

Oracle Data Pump

Advanced Replication, 1-18

Oracle Enterprise Manager Console

Oracle Replication Management tool, 7-1

Oracle Real Application Clusters

compared to replication, 2-6, 6-32

Oracle Replication Management tool, 1-15, 7-1

first login, 7-3

interface, 7-4

Navigator pane, 7-5

right pane, 7-9

Topology tab, 7-10

usage scenarios, 7-2

wizards, 7-15

Copy Template, 7-24

Deployment Template, 7-20

Materialized View Group, 7-18

Setup, 7-15

Template Script Generation Wizard, 7-22

overwrite conflict resolution method, 5-26

P

packages

replication, 2-26

packaging deployment templates, 4-10

parallel propagation, 2-47

configuring for replication environments, 2-47

dependency

tracking, 2-54

implementing, 2-48

planning for, 6-26

replication environment, 6-26

row level SCN, 2-54

tuning, 2-49

PARALLEL_MAX_SERVERS initialization parameter, 2-48, 6-6

PARALLEL_MIN_SERVERS initialization parameter, 2-48, 6-6

parameters

deployment templates, 4-8

PCTFREE parameter

value for complex materialized views, 3-64

PCTUSED parameter

value for complex materialized views, 3-64

peer-to-peer replication. See multimaster replication

performance

replication, 2-47

periodic purges

scheduling, 6-24

periodic pushes

scheduling, 6-21

planning

for replication, 6-1

PRIMARY KEY constraints

materialized views, 3-8, 3-28

replicated tables, 6-2

primary sites

ownership, 5-18

priority groups conflict resolution method, 5-34

privileges

materialized views, 3-15, 6-12

procedural replication, 1-19

detecting conflicts, 1-20

restrictions, 2-26

wrapper, 1-20

procedures

replicating, 2-27

PROCESSES initialization parameter, 6-6

propagation, 2-40

initiating, 2-46

modes, 2-45

parallel, 2-47

implementing, 2-48

tuning, 2-49

security context of propagator, 2-43

propagator

replication, 2-19

purges

deferred transaction queue

scheduling continuous, 6-25

scheduling periodic, 6-24

pushes

deferred transaction queue

scheduling continuous, 6-22

scheduling periodic, 6-21

Q

quiescing, 1-7, 2-32

single master

reduced, 3-6

R

read-only materialized views, 1-8, 3-5

registration

manual, 3-50

unregistering, 3-50

receiver

replication, 2-19

recovery

replication environments, 6-34

redefining tables

online

replication, 3-54

referential integrity

self-referential constraints, 2-25

refresh

automatic, 3-67

complete, 3-63

failures, A-9

fast, 3-64

determining possibility of, 3-30

force, 3-67

group, 3-67

initiating, 3-67

interval, 3-67

manual, 3-68

materialized views, 1-12, 3-63

on-demand, 3-68

retries, A-9

rollback segments

troubleshooting, A-11

scheduling, 3-67

troubleshooting, A-10

troubleshooting

ORA-12004 error, A-11

ORA-942 error, A-11

truncating materialized views

troubleshooting, A-11

refresh groups, 1-6, 1-12, 3-60

deployment templates, 4-19

size considerations, 3-62

troubleshooting, A-8

REFRESH procedure, 3-68

REFRESH_ALL_MVIEWS procedure, 3-68

REFRESH_DEPENDENT procedure, 3-68

REFs

materialized views, 3-46

replication, 2-17, 3-46

REGISTER_MVIEW procedure, 3-50

REPCAT_IMPORT_CHECK procedure, 6-35

replication

administration, 1-15, 2-32

administrative request queue, 2-36

administrative requests, 2-33

states, 2-36

applications that use, 1-3

assignment tables, 4-22

asynchronous propagation, 1-6, 2-40

availability, 6-31

character sets, B-1

checking imported data, 6-35

column groups, 2-39

column subsetting, 1-11

compared to Oracle Real Application Clusters, 2-6, 6-32

conflict resolution, 1-18, 2-10, 2-57

conflicts

detecting, 2-56

procedural replication, 1-20

connection qualifiers, 2-22

creating an environment, 7-26

data requirements, 5-2

database links, 2-20

CONNECT TO clause, 2-20

Replication Management tool, 2-21

USING clause, 2-20

DDL statements, 1-17

deferred transaction queues, 2-31

diagnosing problems with, A-6

deferred transactions, 1-6, 2-30

defined, 1-2

DELAY_SECONDS parameter, 2-50

dependencies

minimizing, 2-55

dependency tracking, 2-54

deployment templates, 1-13, 4-1

user-defined types, 4-7

distributed schema management, 1-17

error queues, 2-31

failover, 6-34

filter columns, 6-15

flowchart for creating environment, 7-26

groups, 1-5, 2-37

hybrid configurations, 1-13

Import check, 6-35

indextypes, 2-28

initialization parameters, 6-5

internal procedures, 2-30

internal triggers, 2-30

interoperability, 6-20

NCHAR datatype, B-8

NVARCHAR datatype, B-8

introduction, 1-2

job queue processes, 6-13

job queues, 2-31

jobs, 2-33

LOBs, 6-3

mass deployment, 4-2

master, 1-8

master definition site, 1-5

master groups, 1-5, 2-37

master materialized views, 1-8

master sites, 1-5, 2-18

advantages, 6-8

materialized view groups, 1-5

materialized view logs, 1-12

materialized view sites

advantages, 6-9

materialized views, 1-8, 3-1

minimum communication, 2-50

modes, 2-32

multimaster, 1-6, 2-1

multitier materialized views, 1-8

objects, 2-24

performance, 2-47

planning for, 6-1

problems

troubleshooting, A-1

procedural replication, 1-19

procedures

troubleshooting, A-5

propagation, 2-40

propagator, 2-19

quiesce, 1-7, 2-32

real-time replication. See synchronous replication

receiver, 2-19

refresh, 1-12

refresh groups, 1-6, 1-12

replication administrator (REPADMIN user), 2-19

replication management API, 1-17

resuming, 2-33

row subsetting, 1-11

scheduled links, 1-15

See Also materialized views

single master, 2-3

sites, 1-5

choosing, 6-8

survivability, 6-31

suspending, 2-33

synchronous, 1-19, 2-42

tables, 6-2

and DML incompatibility, A-4

datatypes allowed, 6-2

dependency tracking, 6-4

DML incompatibility, A-4

transaction propagation protection, 2-52

transactions

dependency ordering, 2-53

triggers

troubleshooting, A-5

troubleshooting, A-1

Unicode, B-7

unsupported datatypes

BFILE, 6-2

LONG, 6-2

user-defined datatypes, 2-12, 3-37

uses of, 1-2

replication catalog, 1-17

DBA_MVIEW_REFRESH_TIMES, 3-49

DBA_REGISTERED_MVIEWS, 3-49

DBA_REPCATLOG, 2-34

incorrect views, A-7

USER_REFRESH, A-9

USER_REFRESH_CHILDREN, A-9

replication management API, 1-17, 2-33

Replication Management tool. See Oracle Replication Management tool

replication objects, 1-4, 2-28

at materialized view sites

problems creating, A-7

functions, 2-27

indexes, 2-26

on foreign keys, 6-2

packages, 2-26

procedures, 2-27

re-creating, A-5

sequences, 2-29

tables, 2-24, 6-2

datatypes allowed, 6-2

dependency tracking, 6-4

DML incompatibility, A-4

foreign keys, 6-2

primary keys, 6-2

unable to generate support for, A-5

triggers, 2-27

REPLICATION_DEPENDENCY_TRACKING initialization parameter, 6-7

restrictions

procedural replication, 2-26

rollback segments

materialized view sites, 6-30

row subsetting, 1-11

deployment templates, 4-22

materialized views, 3-18

ROWDEPENDENCIES clause, 2-54

creating tables, 6-4

rowids

rowid materialized views, 3-10

rows

identifying during conflict detection, 2-57

S

SCHEDULE_PUSH procedure, 6-21, 6-22

scheduled links, 1-15, 6-13

continuous pushes, 6-22

guidelines, 6-20

parallel propagation, 6-26

periodic pushes, 6-21

serial propagation, 6-26

scheduled purges

guidelines, 6-23

periodic purges, 6-24

schemas

creating for materialized views, 6-10

security

deployment templates, 4-9

SEND_OLD_VALUES procedure, 5-40

sequences

replication, 2-29

Setup Wizard, 7-15

shadow column groups, 5-23

SHARED_POOL_SIZE initialization parameter, 6-7

simple materialized views, 3-13

site priority conflict resolution method, 5-36

as a backup method, 5-25, 5-31

snapshots. See materialized views

store-and-forward replication. See asynchronous replication

subqueries

in unions

materialized views, 3-24

materialized views, 3-19

AND condition, 3-28

column logging, 3-28

EXISTS condition, 3-28

joins, 3-28

many to many, 3-22

many to one, 3-19

one to many, 3-21

OR condition, 3-28

primary key, 3-28

restrictions, 3-27

subsetting

materialized views, 3-18

column objects, 3-41

survivability, 6-31

design considerations, 6-33

implementing, 6-34

Oracle Real Application Clusters and, 6-32

synchronous replication, 1-19, 2-42

of destination of transactions, 2-44

synonyms, 2-28

replication, 2-28

system change numbers

row level, 2-54, 6-4

T

tables

length semantics, B-3

precreated

length semantics, B-4

problems generating replication support for, A-5

redefining online

replication, 3-54

replicating, 2-24, 6-2

datatypes allowed, 6-2

dependency tracking, 6-4

DML incompatibility, A-4

Template Script Generation Wizard, 7-22

trace files

materialized views, A-9

transactions

propagation

protection mechanisms, 2-52

triggers

for materialized view log, 3-53

for updatable materialized view logs, 3-57

replicating, 2-27

troubleshooting

replication problems, A-1

U

Unicode

NCHAR datatype, B-7

NVARCHAR datatype, B-7

replication, B-7

unions

with subqueries

materialized views, 3-24

restrictions for materialized views, 3-29

UNREGISTER_MVIEW procedure, 3-50

updatable materialized view logs, 3-57

trigger for, 3-57

updatable materialized views, 1-9, 3-5

column subsetting, 5-11

conflict resolution, 5-11

DELETE CASCADE constraint, 3-7, 3-69

length semantics, B-6

materialized view groups, 3-59

USER_REFRESH view, A-9

USER_REFRESH_CHILDREN view, A-9

user-defined datatypes

materialized views, 3-37

collections, 3-44

column objects, 3-37, 3-41

object tables, 3-42

ON COMMIT REFRESH clause, 3-38

REFs, 3-46

type agreement, 3-38

replication, 2-12, 3-37

collections, 2-16, 3-44

column objects, 2-12, 3-37

object tables, 2-15

REFs, 2-17, 3-46

type agreement, 2-13, 3-38

USLOG$_, 3-57

V

varrays

materialized views, 3-44

restrictions, 3-46

replication, 2-16, 3-44

vertical partitioning. See column subsetting

views, 2-28

replication, 2-28

W

WHERE clause

deployment templates, 4-9

WITH ROWID clause

REFs, 3-48

wrapper

procedural replication, 1-20

writeable materialized views, 3-7