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

asynchronous replication, 1-6, 2-40

availability

extended, 5-41

average conflict resolution method, 5-29

backups

for replication, 6-35

bulk updates, A-4

BYTE character semantics, B-2

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

send old values, 5-45

materialized views, 3-37

column subsetting, 3-41

replication, 2-12, 3-37

column subsetting, 1-11

deployment templates, 4-21

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

COMPATIBLE initialization parameter, 6-5

complete refresh, 1-12, 3-66

complex materialized views, 3-10, 3-13

value for PCTFREE, 3-67

value for PCTUSED, 3-67

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

configuring without quiesce, 5-41

convergence properties of methods, 5-28

data requirements, 5-3

delete conflicts, 5-4

detecting conflicts, 5-6

discard method, 5-30, 5-40

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

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

minimum communication, 5-40

send old values, 5-42

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

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-57, 5-6

identifying rows, 2-58, 5-7

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

referential

self-referencing, 2-25

continuous purges

scheduling, 6-26

continuous pushes

scheduling, 6-23

Copy Template Wizard, 7-23

CREATE TYPE statement

OID clause, 2-14, 3-40

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-11, 6-30

replication, 2-19

Replication Management tool, 2-21

scheduled links, 1-15

datatypes

allowed in replicated tables, 6-2

date expressions, 3-70, 4-20

DBA_MVIEW_REFRESH_TIMES view, 3-49

DBA_REGISTERED_MVIEWS view, 3-49

DBA_REPCATLOG view, 2-33

DBA_TYPE_VERSIONS

replication, 2-13, 3-39

DBMS_DEFER_SYS package

SCHEDULE_PUSH procedure, 6-22, 6-24

DBMS_MVIEW package

EXPLAIN_MVIEW procedure, 3-30

REGISTER_MVIEW procedure, 3-51

UNREGISTER_MVIEW procedure, 3-51

DBMS_REFRESH package

CHANGE procedure, 4-20

DBMS_REPCAT package, 2-33, 2-35

COMPARE_OLD_VALUES procedure

conflict resolution, 5-42

CREATE_MVIEW_REPGROUP procedure, 3-6

CREATE_MVIEW_REPOBJECT procedure, 3-6

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

REPCAT_IMPORT_CHECK procedure, 6-36

SEND_OLD_VALUES procedure

conflict resolution, 5-42

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

pushing, 2-31

scheduled purge, 6-13

scheduled push, 6-13

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

architecture, 4-14

column subsetting, 4-21

concepts, 4-3

data sets, 4-27

DDL statements, 4-14

definition storage, 4-14

design, 4-21

elements, 4-4

general template information, 4-4

instantiation, 1-13, 4-9

offline, 4-10, 4-18

online, 4-9, 4-17

options, 4-18

process, 4-16

scenarios, 4-12

troubleshooting, A-9

local control, 4-30

materialized view groups, 4-20

materialized view logs, 4-13

materialized view sites, 4-9

objects

definitions, 4-6, 4-14

packaging, 4-9

for offline instantiation, 4-16

for online instantiation, 4-16

options, 4-18

procedures, 4-13

process, 4-16

parameters, 4-7

security, 4-8

preparing materialized view sites for, 6-28

refresh groups, 4-20

row subsetting, 4-23

user authorization, 4-9

user-defined types, 4-7

WHERE clause, 4-8

direct path load

fast refresh, 3-67

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

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

extended availability, 5-41

failover sites

implementing using FAILOVER option, 6-35

fast refresh, 1-12, 3-67

avoiding problems, 6-20

determining possibility of, 3-30

direct path load, 3-67

multitier materialized views, 3-68

features, new, xix

filter columns, 6-16

force refresh, 1-12, 3-69

foreign keys

replicated tables, 6-2

functions

replicating, 2-27

GLOBAL_NAMES initialization parameter, 6-5

group owner

materialized view groups, 3-62

horizontal partitioning. See row subsetting

Import

materialized view logs, 3-57

materialized views, 3-57

replication check, 6-36

indexes

materialized view sites, 3-59

on foreign keys, 6-2

replication, 2-25

indextypes

replication, 2-28

initialization parameters

COMPATIBLE, 6-5

editing, 6-13

GLOBAL_NAMES, 6-5

JOB_QUEUE_PROCESSES, 2-34, 6-5

NLS_LENGTH_SEMANTICS, B-2

OPEN_LINKS, 2-23, 6-6

PARALLEL_AUTOMATIC_TUNING, 2-48, 6-6

PARALLEL_MAX_SERVERS, 2-48, 6-6

PARALLEL_MIN_SERVERS, 2-48

PROCESSES, 6-6

replication, 6-4

REPLICATION_DEPENDENCY_TRACKING, 6-7

SHARED_POOL_SIZE, 6-7

UTL_FILE_DIR, 6-7

INIT.ORA parameters. See initialization parameters

instantiation

deployment templates, 1-13, 4-9

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

replication, 2-33

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

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

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

materialized view logs, 3-54

master sites, 1-5

adding

circular dependencies, 2-25

self-referential constraints, 2-25

advantages of, 6-9

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

length semantics, B-3

precreated tables, B-4

materialized view registration, 3-49

materialized views, 3-53

replicated objects not created at new, A-3

replication, 2-18

roles, 2-18

scheduled links for

guidelines, 6-21

scheduled purges for, 6-13

guidelines, 6-24

users, 2-18

master tables

materialized view logs, 3-54

materialized views, 3-53

redefining online, 3-56

reorganizing, 3-55

Materialized View Group Wizard, 7-19

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

deployment templates, 4-20

group owner, 3-62

ownership, 3-37

updatable materialized views, 3-62

materialized view logs, 1-13, 3-54

adding columns to, 6-17

column logging, 3-27

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

creating, 6-16

deployment templates, 4-13

filter columns, 6-16

Import, 3-57

join columns, 6-16

logging columns, 6-16

object ID, 3-55

object tables, 3-56

primary key, 3-55

privileges required to create, 6-16

REFs, 3-48

ROWID, 3-55

trigger, 3-54

troubleshooting, A-11

underlying table for, 3-54

materialized view sites, 1-5

adding

avoiding problems, 6-20

advantages of, 6-9

compared with master sites, 6-8

database links, 6-11, 6-30

database version, 6-29

deferred transaction queues

scheduled push, 6-13

deployment templates, 4-9

length semantics, B-5

prebuilt container tables, B-5

local creation, 4-29

network connectivity, 6-29

preparing for deployment templates, 6-28

rollback segments, 6-31

schedule purge

guidelines, 6-24

scheduled links for

guidelines, 6-21

schemas, 6-30

setup, 6-29

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

architecture, 3-51

base table, 3-58

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

value for PCTUSED, 3-67

concepts, 3-2

creating, 6-18

creating schemas for, 6-11

creator, 3-14

data subsetting, 3-4, 3-18

deployment templates, 1-13, 4-1

user-defined types, 4-7

disconnected computing, 3-4

Import, 3-57

index, 3-59

length semantics, B-5

prebuilt container tables, B-5

LOBs, 6-3

local control, 4-30

mass deployment, 3-4

master materialized view sites, 3-53

master materialized views, 3-53

master sites, 3-53

master tables, 3-53

materialized view groups, 3-61

materialized view logs, 1-13, 3-54

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

conflict resolution, 5-8

fast refresh, 3-68

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

object tables, 3-42

owner, 3-14

preparing for, 6-10

primary key, 3-8, 3-27

privileges, 3-14, 6-12

read-only, 1-8, 3-5

registration, 3-51

unregistering, 3-51

refresh groups, 1-12, 3-63

size, 3-65

refresher, 3-14

refreshing, 1-12, 3-66

complete, 3-66

failures, A-9

fast, 3-30, 3-67

force, 3-69

initiating, 3-70

interval, 3-70

on-demand, 3-71

querying for last refresh time, 3-49

retries, A-9

troubleshooting, A-9, A-10

REFs, 3-46

logging, 3-48

scoped, 3-47

unscoped, 3-48

WITH ROWID clause, 3-48

registration, 3-49

reorganizing, 3-55

row subsetting, 1-11, 3-18

rowid, 3-9

simple, 3-13

simple subquery

AND operator, 3-27

subqueries, 3-19

column logging, 3-27

EXISTS operator, 3-27

joins, 3-27

many to many, 3-22

many to one, 3-19

one to many, 3-20

OR operators, 3-27

primary key materialized views, 3-27

restrictions, 3-27

trace file, A-10

troubleshooting, A-8

types of, 3-7

unions with subqueries, 3-23

restrictions, 3-28

updatable, 1-9, 3-5

column aliases, 3-6

length semantics, B-6

materialized view groups, 3-62

updatable materialized view logs, 3-60

trigger for, 3-60

user-defined datatypes, 3-37

ON COMMIT REFRESH clause, 3-38

uses for, 3-3

varrays, 3-44

restrictions, 3-46

views, 3-59

writeable, 3-7

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

conflict resolution, 5-8

fast refresh, 3-68

levels, 3-31

master materialized views, 3-32

restrictions, 3-37

materialized view groups

ownership, 3-37

restrictions, 3-36

NCHAR datatype

Unicode, 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-35

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

object materialized views, 3-42

OID preservation, 3-44

object tables

column groups, 5-23

materialized view logs, 3-56

materialized views, 3-42

replication, 2-15

object-relational model

materialized views, 3-37

replication, 2-12, 3-37

objects

replicated

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

OPEN_LINKS initialization parameter, 2-23, 6-6

OR operators

materialized views with subqueries, 3-27

Oracle Real Application Clusters

compared to replication, 2-6, 6-33

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

replication environment, 6-27

row level SCN, 2-55

tuning, 2-50

PARALLEL_AUTOMATIC_TUNING initialization parameter, 2-48, 6-6

PARALLEL_MAX_SERVERS initialization parameter, 2-48, 6-6

PARALLEL_MIN_SERVERS, 6-6

PARALLEL_MIN_SERVERS initialization parameter, 2-48, 6-6

parameters

deployment templates, 4-7

PCTFREE parameter

value for complex materialized views, 3-67

PCTUSED parameter

value for complex materialized views, 3-67

peer-to-peer replication. See multimaster replication

performance

replication, 2-47

periodic purges

scheduling, 6-25

periodic pushes

scheduling, 6-22

planning

for replication, 6-1

PRIMARY KEY constraints

materialized views, 3-8, 3-27

replicated tables, 6-2

primary sites

ownership, 5-18

priority groups conflict resolution method, 5-34

privileges

materialized views, 3-14, 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-50

security context of propagator, 2-43

propagator

replication, 2-19

purges

deferred transaction queue

scheduling continuous, 6-26

scheduling periodic, 6-25

pushes

deferred transaction queue

scheduling continuous, 6-23

scheduling periodic, 6-22

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

unregistering, 3-51

receiver

replication, 2-19

recovery

for replication, 6-35

redefining tables

online

replication, 3-56

referential integrity

self-referential constraints, 2-25

refresh

automatic, 3-70

complete, 3-66

DBMS_REFRESH package

CHANGE procedure, 4-20

failures, A-9

fast, 3-67

determining possibility of, 3-30

force, 3-69

group, 3-70

initiating, 3-70

interval, 3-70

manual, 3-71

materialized views, 1-12, 3-66

on-demand, 3-71

retries, A-9

rollback segments

troubleshooting, A-12

scheduling, 3-70

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

deployment templates, 4-20

size considerations, 3-65

troubleshooting, A-9

REFs

materialized views, 3-46

replication, 2-17, 3-46

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

asynchronous propagation, 1-6, 2-40

availability, 6-32

backup and recovery for, 6-35

character sets, B-1

checking imported data, 6-36

column groups, 2-39

column subsetting, 1-11

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

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

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

filter columns, 6-16

flowchart for creating environment, 7-25

groups, 1-5, 2-37

hybrid configurations, 1-14

Import check, 6-36

indextypes, 2-28

initialization parameters, 6-4

internal procedures, 2-30

internal triggers, 2-30

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

materialized view groups, 1-5

materialized view logs, 1-13

materialized view sites

advantages, 6-9

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

survivability, 6-32

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

uses of, 1-2

replication catalog, 1-17

DBA_MVIEW_REFRESH_TIMES, 3-49

DBA_REGISTERED_MVIEWS, 3-49

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

restrictions

procedural replication, 2-26

rollback segments

materialized view sites, 6-31

row subsetting, 1-11

deployment templates, 4-23

materialized views, 3-18

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

continuous pushes, 6-23

guidelines, 6-21

parallel propagation, 6-27

periodic pushes, 6-22

serial propagation, 6-27

scheduled purges

guidelines, 6-24

periodic purges, 6-25

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

materialized views, 3-19

AND operator, 3-27

column logging, 3-27

EXISTS operator, 3-27

joins, 3-27

many to many, 3-22

many to one, 3-19

one to many, 3-20

OR operators, 3-27

primary key, 3-27

restrictions, 3-27

subsetting

materialized views, 3-18

column objects, 3-41

survivability, 6-32

design considerations, 6-34

implementing, 6-35

Oracle Real Application Clusters and, 6-33

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

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

for updatable materialized view logs, 3-60

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

updatable materialized view logs, 3-60

trigger for, 3-60

updatable materialized views, 1-9, 3-5

column subsetting, 5-11

conflict resolution, 5-11

length semantics, B-6

materialized view groups, 3-62

USER_REFRESH view, A-10

USER_REFRESH_CHILDREN view, A-10

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-12, 3-38

USLOG$_, 3-60

UTL_FILE_DIR initialization parameter, 6-7

varrays

materialized views, 3-44

restrictions, 3-46

replication, 2-16, 3-44

vertical partitioning. See column subsetting

views, 2-28

materialized view sites, 3-59

replication, 2-28

WHERE clause

deployment templates, 4-8

WITH ROWID clause

REFs, 3-48

wrapper

procedural replication, 1-20

writeable materialized views, 3-7