Oracle9i Advanced Replication -- Index

accounts

creating for materialized views, 6-11

additive conflict resolution method, 5-28

administrative request queue, 2-35

administrative requests, 2-33

states, 2-36

AWAIT_CALLBACK, 2-36

DO_CALLBACK, 2-36

ERROR, 2-36

READY, 2-36

aliases

for columns

updatable materialized views, 3-6

AND operator

for simple subquery materialized views, 3-27

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

availability

extended, 5-41

average conflict resolution method, 5-29

backups

for replication, 6-36

bulk updates, A-4

BYTE character semantics, B-2

CHAR character semantics, B-2

character sets

replication, B-1

collections

materialized views, 3-42

restrictions, 3-44

replication, 2-16, 3-42

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

column subsetting, 3-40

replication, 2-12, 3-36

column subsetting, 1-11

deployment templates, 4-20

materialized views

column objects, 3-40

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

COMPATIBLE initialization parameter, 6-6

complete refresh, 1-12, 3-64

complex materialized views, 3-10, 3-12

value for PCTFREE, 3-65

value for PCTUSED, 3-65

conflict resolution, 2-58

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

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

configuring without quiesce, 5-41

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

methods for uniqueness conflicts, 5-37

methods for update conflicts, 5-24

minimum method, 5-33

multitier materialized views, 5-7

nested tables, 5-12

overwrite method, 5-26

performance, 5-40

compare old values, 5-41

minimum communication, 5-40

send old values, 5-41

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

conflicts

avoiding, 5-17

delete, 5-4

avoiding, 5-19

detecting, 2-44, 2-57, 5-5

identifying rows, 2-58, 5-6

error queue, 5-23

ordering

avoiding, 5-20

procedural replication, 1-20

uniqueness, 5-4

avoiding, 5-19

update, 5-3

avoiding, 5-20

connection qualifiers, 2-22

diagnosing problems with, A-2

constraint violations, A-4

constraints

referential

self-referencing, 2-25

continuous purges

scheduling, 6-27

continuous pushes

scheduling, 6-24

Copy Template Wizard, 7-23

CREATE TYPE statement

OID clause, 2-14, 3-39

data dictionary

replication, 1-17

data integrity

parallel propagation, 2-55

serial propagation, 2-55

data propagation

and dependency maintenance, 2-54

asynchronous, 2-40

synchronous, 2-42

database links

connection qualifiers, 2-22

diagnosing problems with, A-2

incomplete specifications, A-7

materialized view sites, 6-12, 6-31

replication, 2-19

Replication Management tool, 2-21

scheduled links, 1-15

datatypes

allowed in replicated tables, 6-2

date expressions, 3-68, 4-19

DBA_MVIEW_REFRESH_TIMES view, 3-47

DBA_REGISTERED_MVIEWS view, 3-47

DBA_REPCATLOG view, 2-33

DBA_TYPE_VERSIONS

replication, 2-13, 3-38

DBMS_DEFER_SYS package

SCHEDULE_PUSH procedure, 6-23, 6-25

DBMS_MVIEW package

EXPLAIN_MVIEW procedure, 3-29

REGISTER_MVIEW procedure, 3-49

UNREGISTER_MVIEW procedure, 3-49

DBMS_REFRESH package

CHANGE procedure, 4-19

DBMS_REPCAT package, 2-33, 2-35

COMPARE_OLD_VALUES procedure

conflict resolution, 5-41

CREATE_MVIEW_REPGROUP procedure, 3-5

CREATE_MVIEW_REPOBJECT procedure, 3-6

DO_DEFERRED_REPCAT_ADMIN procedure, 2-33, 2-34, 2-36

REPCAT_IMPORT_CHECK procedure, 6-37

SEND_OLD_VALUES procedure

conflict resolution, 5-41

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

purging propagated transactions, 6-25

pushing, 2-31

scheduled purge, 6-14

scheduled push, 6-14

DELAY_SECONDS parameter, 2-51

dependencies

minimizing, 2-56

dependency

ordering

replicated transactions, 2-54

tracking

parallel propagation, 2-55

dependency tracking

row level, 2-55, 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-9

offline, 4-10, 4-17

online, 4-9, 4-16

options, 4-17

process, 4-15

scenarios, 4-12

troubleshooting, A-9

local control, 4-28

materialized view groups, 4-19

materialized view logs, 4-13

materialized view sites, 4-9

objects

definitions, 4-6, 4-14

packaging, 4-9

for offline instantiation, 4-15

for online instantiation, 4-15

options, 4-17

procedures, 4-13

process, 4-15

parameters, 4-7

security, 4-8

preparing materialized view sites for, 6-29

refresh groups, 4-19

row subsetting, 4-22

user authorization, 4-9

user-defined types, 4-7

WHERE clause, 4-8

direct path load

fast refresh, 3-65

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

distributed schema management, 1-17

distributed transactions

problems with, A-7

DML statements

replication

troubleshooting problems, A-4

domain indexes

replication, 2-25

dynamic sites

ownership, 5-18

earliest timestamp conflict resolution method, 5-31

errors

error queues, 2-31

conflicts, 5-23

EXISTS operator

materialized views with subqueries, 3-27

EXPLAIN_MVIEW procedure, 3-29

extended availability, 5-41

failover sites

implementing using FAILOVER option, 6-36

fast refresh, 1-12, 3-65

avoiding problems, 6-21

determining possibility of, 3-29

direct path load, 3-65

multitier materialized views, 3-66

features, new, xix

filter columns, 6-17

force refresh, 1-12, 3-67

foreign keys

replicated tables, 6-2

functions

replicating, 2-27

GLOBAL_NAMES initialization parameter, 6-6

group owner

materialized view groups, 3-60

horizontal partitioning. See row subsetting

Import

materialized view logs, 3-55

materialized views, 3-55

replication check, 6-37

indexes

materialized view sites, 3-57

on foreign keys, 6-2

replication, 2-25

indextypes

replication, 2-28

initialization parameters

COMPATIBLE, 6-6

editing, 6-14

GLOBAL_NAMES, 6-6

JOB_QUEUE_PROCESSES, 2-34, 6-6

NLS_LENGTH_SEMANTICS, B-2

OPEN_LINKS, 2-23, 6-7

PARALLEL_AUTOMATIC_TUNING, 2-48, 6-7

PARALLEL_MAX_SERVERS, 2-48, 6-7

PARALLEL_MIN_SERVERS, 2-48

PROCESSES, 6-7

replication, 6-4

REPLICATION_DEPENDENCY_TRACKING, 6-8

SHARED_POOL_SIZE, 6-8

UTL_FILE_DIR, 6-8

INIT.ORA parameters. See initialization parameters

instantiation

deployment templates, 1-13, 4-9

job queue processes

replication, 6-14

job queues, 2-31

JOB_QUEUE_PROCESSES initialization parameter, 2-34, 6-6, 6-14

jobs

checking for scheduled links, A-7

replication, 2-33

latest timestamp

conflict resolution method, 5-24

length semantics

replication, B-2

levels

multitier materialized views, 3-30

LOBs

allowed in replicated tables, 6-2

replication support for, 6-3

many to many subqueries

materialized views, 3-21

many to one subqueries

materialized views, 3-18

mass deployment, 3-4, 4-2

master definition site, 1-5, 2-4

master groups, 1-5, 2-37

master materialized view sites, 3-51

master materialized views, 1-8, 3-31, 3-51

materialized view logs, 3-52

master sites, 1-5

adding

circular dependencies, 2-25

self-referential constraints, 2-25

advantages of, 6-10

bulk updates, A-4

compared with materialized view sites, 6-9

constraints

violations, A-4

DDL changes not propagated, A-3

diagnosing problems with, A-2

DML changes not propagated, A-4

internal triggers, 3-52

length semantics, B-3

precreated tables, B-4

materialized view registration, 3-47

materialized views, 3-51

replicated objects not created at new, A-3

replication, 2-18

roles, 2-18

scheduled links for

guidelines, 6-22

scheduled purges for, 6-14

guidelines, 6-25

users, 2-18

master tables

materialized view logs, 3-52

materialized views, 3-51

redefining online, 3-54

reorganizing, 3-53

Materialized View Group Wizard, 7-19

materialized view groups, 1-5, 3-36, 3-59

deployment templates, 4-19

group owner, 3-60

ownership, 3-36

updatable materialized views, 3-60

materialized view logs, 1-13, 3-52

adding columns to, 6-18

column logging, 3-26

many to many subqueries, 3-27

many to one subqueries, 3-27

ON PREBUILT TABLE clause, 3-27

one to many subqueries, 3-27

combination, 3-53

creating, 6-17

deployment templates, 4-13

filter columns, 6-17

Import, 3-55

join columns, 6-17

logging columns, 6-17

object ID, 3-53

object tables, 3-54

primary key, 3-53

privileges required to create, 6-17

REFs, 3-46

ROWID, 3-53

trigger, 3-52

troubleshooting, A-11

underlying table for, 3-52

materialized view sites, 1-5

adding

avoiding problems, 6-21

advantages of, 6-10

compared with master sites, 6-9

database links, 6-12, 6-31

database version, 6-30

deferred transaction queues

scheduled push, 6-14

deployment templates, 4-9

length semantics, B-5

prebuilt container tables, B-5

local creation, 4-28

network connectivity, 6-30

preparing for deployment templates, 6-29

rollback segments, 6-32

schedule purge

guidelines, 6-25

scheduled links for

guidelines, 6-22

schemas, 6-31

setup, 6-30

materialized views, 1-2, 1-8, 3-1

architecture, 3-49

base table, 3-56

BUILD DEFERRED

troubleshooting, A-12

capabilities, 3-29

collection columns, 3-42

restrictions, 3-44

column objects

column subsetting, 3-40

column subsetting, 1-11

column objects, 3-40

complex, 3-10, 3-12

value for PCTFREE, 3-65

value for PCTUSED, 3-65

concepts, 3-2

creating, 6-19

creating schemas for, 6-11

creator, 3-14

data subsetting, 3-4, 3-17

deployment templates, 1-13, 4-1

user-defined types, 4-7

disconnected computing, 3-4

Import, 3-55

index, 3-57

length semantics, B-5

prebuilt container tables, B-5

LOBs, 6-3

local control, 4-28

mass deployment, 3-4

master materialized view sites, 3-51

master materialized views, 3-51

master sites, 3-51

master tables, 3-51

materialized view groups, 3-59

materialized view logs, 1-13, 3-52

multitier, 1-8, 3-30, 3-36

conflict resolution, 5-7

fast refresh, 3-66

levels, 3-30

master materialized views, 3-31

restrictions, 3-35

nested tables, 3-42

restrictions, 3-44

network loads, 3-3

object materialized views, 3-41

OID preservation, 3-42

object tables, 3-40

owner, 3-14

preparing for, 6-11

primary key, 3-7, 3-26

privileges, 3-14, 6-13

read-only, 1-8, 3-5

registration, 3-49

unregistering, 3-49

refresh groups, 1-12, 3-61

size, 3-62

refresher, 3-14

refreshing, 1-12, 3-64

complete, 3-64

failures, A-9

fast, 3-29, 3-65

force, 3-67

initiating, 3-68

interval, 3-68

on-demand, 3-68

querying for last refresh time, 3-47

retries, A-9

troubleshooting, A-9, A-10

REFs, 3-44

logging, 3-46

scoped, 3-45

unscoped, 3-46

WITH ROWID clause, 3-47

registration, 3-47

reorganizing, 3-53

row subsetting, 1-11, 3-17

rowid, 3-9

simple, 3-12

simple subquery

AND operator, 3-27

subqueries, 3-18

column logging, 3-26

EXISTS operator, 3-27

joins, 3-27

many to many, 3-21

many to one, 3-18

one to many, 3-20

OR operators, 3-27

primary key materialized views, 3-26

restrictions, 3-26

trace file, A-10

troubleshooting, A-8

types of, 3-7

unions with subqueries, 3-23

restrictions, 3-27

updatable, 1-9, 3-5

column aliases, 3-6

length semantics, B-6

materialized view groups, 3-60

updatable materialized view logs, 3-57

trigger for, 3-58

user-defined datatypes, 3-36

ON COMMIT REFRESH clause, 3-37

uses for, 3-3

varrays, 3-42

restrictions, 3-44

views, 3-57

writeable, 3-6

maximum conflict resolution method, 5-32

minimum communication, 2-50

conflict resolution, 5-40

quiesce, 5-41

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

uses for, 2-4

multitier materialized views, 1-8, 3-30

conflict resolution, 5-7

fast refresh, 3-66

levels, 3-30

master materialized views, 3-31

restrictions, 3-35

materialized view groups

ownership, 3-36

restrictions, 3-35

NCHAR datatype

Unicode, B-8

NCLOB datatype

length semantics, B-9

nested tables

column groups, 5-23

conflict resolution, 5-12

materialized views, 3-42

restrictions, 3-44

replication, 2-16, 3-42

network

FAILOVER option, 6-36

new features, xix

NLS_LENGTH_SEMANTICS initialization parameter, B-2

NOROWDEPENDENCIES clause, 2-55

NVARCHAR datatype

Unicode, B-8

n-way replication. See multimaster replication

object identifiers

agreement for replication, 2-12, 3-37

object materialized views, 3-41

OID preservation, 3-42

object tables

column groups, 5-23

materialized view logs, 3-54

materialized views, 3-40

replication, 2-15

object-relational model

materialized views, 3-36

replication, 2-12, 3-36

objects

replicated

recreating, A-5

OF object_type clause

object materialized views, 3-41

OID clause

CREATE TYPE statement, 2-14, 3-39

ON COMMIT REFRESH clause

of CREATE MATERIALIZED VIEW, 3-37

ON DELETE CASCADE clause

troubleshooting replication problems, A-6

ON PREBUILT TABLE clause, 3-27

length semantics, B-5

one to many subqueries

materialized views, 3-20

online redefinition of tables, 3-54

OPEN_LINKS initialization parameter, 2-23, 6-7

OPS. See Oracle Real Application Clusters

OR operators

materialized views with subqueries, 3-27

Oracle Parallel Server. See Oracle Real Application Clusters

Oracle Real Application Clusters

compared to replication, 2-6, 6-34

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

first login, 7-3

interface, 7-4

Navigator pane, 7-5

right pane, 7-9

Topology tab, 7-11

usage scenarios, 7-2

wizards, 7-15

Copy Template, 7-23

Deployment Template, 7-20

Materialized View Group, 7-19

Setup, 7-16

Template Script Generation Wizard, 7-22

overwrite conflict resolution method, 5-26

packages

replication, 2-26

packaging deployment templates, 4-9

parallel propagation, 2-47

configuring for replication environments, 2-47

dependency

tracking, 2-55

implementing, 2-48

planning for, 6-28

replication environment, 6-28

row level SCN, 2-55

tuning, 2-50

Parallel Server. See Oracle Real Application Clusters

PARALLEL_AUTOMATIC_TUNING initialization parameter, 2-48, 6-7

PARALLEL_MAX_SERVERS initialization parameter, 2-48, 6-7

PARALLEL_MIN_SERVERS, 6-7

PARALLEL_MIN_SERVERS initialization parameter, 2-48, 6-7

parameters

deployment templates, 4-7

PCTFREE parameter

value for complex materialized views, 3-65

PCTUSED parameter

value for complex materialized views, 3-65

peer-to-peer replication. See multimaster replication

performance

replication, 2-47

periodic purges

scheduling, 6-26

periodic pushes

scheduling, 6-23

planning

for replication, 6-1

PRIMARY KEY constraints

materialized views, 3-7, 3-26

replicated tables, 6-2

primary sites

ownership, 5-18

priority groups conflict resolution method, 5-34

privileges

materialized views, 3-14, 6-13

procedural replication, 1-19

detecting conflicts, 1-20

restrictions, 2-26

wrapper, 1-20

procedures

replicating, 2-27

PROCESSES initialization parameter, 6-7

propagation, 2-40

initiating, 2-46

modes, 2-45

parallel, 2-47

implementing, 2-48

tuning, 2-50

security context of propagator, 2-43

propagator

replication, 2-19

purges

deferred transaction queue

scheduling continuous, 6-27

scheduling periodic, 6-26

pushes

deferred transaction queue

scheduling continuous, 6-24

scheduling periodic, 6-23

quiescing, 1-7, 2-31

configuring conflict resolution methods without, 5-41

minimum communication, 5-41

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

registration

manual, 3-49

unregistering, 3-49

receiver

replication, 2-19

recovery

for replication, 6-36

redefining tables

online

replication, 3-54

referential integrity

self-referential constraints, 2-25

refresh

automatic, 3-68

complete, 3-64

DBMS_REFRESH package

CHANGE procedure, 4-19

failures, A-9

fast, 3-65

determining possibility of, 3-29

force, 3-67

group, 3-68

initiating, 3-68

interval, 3-68

manual, 3-68

materialized views, 1-12, 3-64

on-demand, 3-68

retries, A-9

rollback segments

troubleshooting, A-12

scheduling, 3-68

troubleshooting, A-11

troubleshooting

ORA-12004 error, A-12

ORA-942 error, A-12

truncating materialized views

troubleshooting, A-12

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

deployment templates, 4-19

size considerations, 3-62

troubleshooting, A-9

REFs

materialized views, 3-44

replication, 2-17, 3-44

replication

administration, 1-15, 2-31

administrative request queue, 2-35

administrative requests, 2-33

states, 2-36

applications that use, 1-3

assignment tables, 4-22

asynchronous propagation, 1-6, 2-40

availability, 6-33

backup and recovery for, 6-36

character sets, B-1

checking imported data, 6-37

column groups, 2-39

column subsetting, 1-11

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

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

conflicts

detecting, 2-57

procedural replication, 1-20

connection qualifiers, 2-22

constraints

troubleshooting, A-6

creating an environment, 7-25

data requirements, 5-2

database links, 2-19

CONNECT TO clause, 2-20

Replication Management tool, 2-21

USING clause, 2-20

DDL statements, 1-17

deferred transaction queues, 2-30

diagnosing problems with, A-7

deferred transactions, 1-6, 2-30

defined, 1-2

DELAY_SECONDS parameter, 2-51

dependencies

minimizing, 2-56

dependency tracking, 2-55

deployment templates, 1-13, 4-1

user-defined types, 4-7

distributed schema management, 1-17

error queues, 2-31

failover, 6-36

filter columns, 6-17

flowchart for creating environment, 7-25

groups, 1-5, 2-37

hybrid configurations, 1-14

Import check, 6-37

indextypes, 2-28

initialization parameters, 6-4

internal procedures, 2-30

internal triggers, 2-30

introduction, 1-2

job queue processes, 6-14

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

materialized view groups, 1-5

materialized view logs, 1-13

materialized view sites

advantages, 6-10

materialized views, 1-8, 3-1

minimum communication, 2-50

modes, 2-31

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

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

row subsetting, 1-11

scheduled links, 1-15

See Also materialized views

single master, 2-3

sites, 1-5

choosing, 6-9

survivability, 6-33

suspending, 2-32

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

transactions

dependency ordering, 2-54

triggers

troubleshooting, A-5

troubleshooting, A-1

Unicode, B-8

unsupported datatypes

BFILE, 6-2

LONG, 6-2

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

uses of, 1-2

replication catalog, 1-17

DBA_MVIEW_REFRESH_TIMES, 3-47

DBA_REGISTERED_MVIEWS, 3-47

DBA_REPCATLOG, 2-33

incorrect views, A-7

USER_REFRESH, A-10

USER_REFRESH_CHILDREN, A-10

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

functions, 2-27

indexes, 2-25

on foreign keys, 6-2

packages, 2-26

procedures, 2-27

recreating, 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-8

restrictions

procedural replication, 2-26

rollback segments

materialized view sites, 6-32

row subsetting, 1-11

deployment templates, 4-22

materialized views, 3-17

ROWDEPENDENCIES clause, 2-55

creating tables, 6-4

rowids

rowid materialized views, 3-9

rows

identifying during conflict detection, 2-58

scheduled links, 1-15, 6-14

continuous pushes, 6-24

guidelines, 6-22

parallel propagation, 6-28

periodic pushes, 6-23

serial propagation, 6-28

scheduled purges

guidelines, 6-25

periodic purges, 6-26

schemas

creating for materialized views, 6-11

security

deployment templates, 4-8

sequences

replication, 2-29

Setup Wizard, 7-16

shadow column groups, 5-23

SHARED_POOL_SIZE initialization parameter, 6-8

simple materialized views, 3-12

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

materialized views, 3-18

AND operator, 3-27

column logging, 3-26

EXISTS operator, 3-27

joins, 3-27

many to many, 3-21

many to one, 3-18

one to many, 3-20

OR operators, 3-27

primary key, 3-26

restrictions, 3-26

subsetting

materialized views, 3-17

column objects, 3-40

survivability, 6-33

design considerations, 6-35

implementing, 6-36

Oracle Real Application Clusters and, 6-34

synchronous replication, 1-19, 2-42

of destination of transactions, 2-44

synonyms, 2-28

replication, 2-28

system change numbers

row level, 2-55, 6-4

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

transactions

propagation

protection mechanisms, 2-53

triggers

for materialized view log, 3-52

for updatable materialized view logs, 3-58

replicating, 2-27

troubleshooting

replication problems, A-1

Unicode

NCHAR datatype, B-8

NVARCHAR datatype, B-8

replication, B-8

unions

with subqueries

materialized views, 3-23

restrictions for materialized views, 3-27

updatable materialized view logs, 3-57

trigger for, 3-58

updatable materialized views, 1-9, 3-5

column subsetting, 5-11

conflict resolution, 5-11

length semantics, B-6

materialized view groups, 3-60

USER_REFRESH view, A-10

USER_REFRESH_CHILDREN view, A-10

user-defined datatypes

materialized views, 3-36

collections, 3-42

column objects, 3-36, 3-40

object tables, 3-40

ON COMMIT REFRESH clause, 3-37

REFs, 3-44

type agreement, 3-37

replication, 2-12, 3-36

collections, 2-16, 3-42

column objects, 2-12, 3-36

object tables, 2-15

REFs, 2-17, 3-44

type agreement, 2-12, 3-37

USLOG$_, 3-57

UTL_FILE_DIR initialization parameter, 6-8

varrays

materialized views, 3-42

restrictions, 3-44

replication, 2-16, 3-42

vertical partitioning. See column subsetting

views, 2-28

materialized view sites, 3-57

replication, 2-28

WHERE clause

deployment templates, 4-8

WITH ROWID clause

REFs, 3-47

wrapper

procedural replication, 1-20

writeable materialized views, 3-6