Index
A B C D E F G H I J L M N O P Q R S T U V W
A
- accounts
-
- creating for materialized views, 6.3.3.3
- additive conflict resolution method, 5.2.3.1
- administrative request queue, 2.2.2.4
- administrative requests, 2.2.2.3
-
- states, 2.2.2.4
-
- AWAIT_CALLBACK, 2.2.2.4
- DO_CALLBACK, 2.2.2.4
- ERROR, 2.2.2.4
- READY, 2.2.2.4
- aliases
-
- for columns
-
- updatable materialized views, 3.1.3.2
- AND condition
-
- for simple subquery materialized views, 3.1.6.2
- append sequence conflict resolution method, 5.2.4.2
- append site name conflict resolution method, 5.2.4.1
- assignment tables, 4.4.2.1
- asynchronous replication, 1.4.1, 2.2.4.1.1
- average conflict resolution method, 5.2.3.2
B
- bulk updates, A.2.5
- BYTE character semantics, B.1
C
- CHAR character semantics, B.1
- character sets
-
- replication, B
- collections
-
- materialized views, 3.1.9.4
-
- restrictions, 3.1.9.4.1
- replication, 2.1.5.3, 3.1.9.4
- column groups, 5.2.1.1
-
- column objects, 5.2.1.1.3
- nested tables, 5.2.1.1.5
- object tables, 5.2.1.1.4
- shadow, 5.2.1.1.2
- column objects
-
- column groups, 5.2.1.1.3
- conflict resolution
-
- compare old values, 5.2.6.2
- send old values, 5.2.6.2
- materialized views
-
- column subsetting, 3.1.9.2
- replication, 2.1.5, 3.1.9
- column subsetting, 1.4.2.4
-
- deployment templates, 4.4.1
- materialized views
-
- column objects, 3.1.9.2
- updatable materialized views
-
- conflict resolution, 5.1.5.2
- columns
-
- character semantics, B.1
- column groups, 2.2.3.2, 5.2.1.1
-
- column objects, 5.2.1.1.3
- ensuring data integrity with multiple, 5.2.1.1.1
- nested tables, 5.2.1.1.5
- object tables, 5.2.1.1.4
- shadow, 5.2.1.1.2
- complete refresh, 1.4.2.5, 3.2.4.1.1
- complex materialized views, 3.1.4.4, 3.1.4.4.1
-
- value for PCTFREE, 3.2.4.1.1
- value for PCTUSED, 3.2.4.1.1
- conflict resolution, 2.2.7.2
-
- additive method, 5.2.3.1
- append sequence method, 5.2.4.2
- append site name method, 5.2.4.1
- architecture, 5.2
- average method, 5.2.3.2
- avoiding conflicts, 5.1.6
- column groups, 5.2.1.1
-
- column objects, 5.2.1.1.3
- data integrity, 5.2.1.1.1
- nested tables, 5.2.1.1.5
- object tables, 5.2.1.1.4
- shadow, 5.2.1.1.2
- column subsetting
-
- updatable materialized views, 5.1.5.2
- concepts, 5.1
- convergence properties of methods, 5.2.3
- data requirements, 5.1.1
- delete conflicts, 5.1.2.3
- detecting conflicts, 5.1.4
- discard method, 5.2.3.3, 5.2.4.3
- dynamic site ownership, 5.1.6.2
- earliest timestamp method, 5.2.3.4
- error queue, 5.2.1.2
- in synchronous propagation, 2.2.4.2.1
- latest timestamp method, 5.2.2.1
- maximum method, 5.2.3.5
- methods for delete conflicts, 5.2.5
- methods for uniqueness conflicts, 5.2.4
- methods for update conflicts, 5.2.2
- minimum method, 5.2.3.6
- multitier materialized views, 5.1.5.1
- nested tables, 5.1.5.3
- overwrite method, 5.2.2.2
- performance
-
- compare old values, 5.2.6
- send old values, 5.2.6
- prebuilt methods, 5.1.5
- primary site ownership, 5.1.6.2
- priority groups method, 5.2.3.7
- replication, 1.6, 2.1.4
- site priority method, 5.2.3.8
-
- as backup, 5.2.2.1, 5.2.3.4
- transaction ordering, 5.1.3
- types of conflicts, 5.1.2
- uniqueness conflicts, 5.1.2.2
- updatable materialized views
-
- column subsetting, 5.1.5.2
- update conflicts, 5.1.2.1
- conflicts
-
- avoiding, 5.1.6
- delete, 5.1.2.3
-
- avoiding, 5.1.6.3.2
- detecting, 2.2.4.2.3, 2.2.7, 5.1.4
-
- identifying rows, 2.2.7.1, 5.1.4.2
- error queue, 5.2.1.2
- ordering
-
- avoiding, 5.1.6.3.4
- procedural replication, 1.7.2.1
- uniqueness, 5.1.2.2
-
- avoiding, 5.1.6.3.1
- update, 5.1.2.1
-
- avoiding, 5.1.6.3.3
- connection qualifiers, 2.2.1.2.2
-
- diagnosing problems with, A.1
- constraint violations, A.2.5
- constraints
-
- deferrable, 3.2.4.3
- referential
-
- self-referencing, 2.2.1.3.1
- continuous purges
-
- scheduling, 6.6.2
- continuous pushes
-
- scheduling, 6.5.2
- Copy Template Wizard, 7.4.5
- CREATE TYPE statement
-
- OID clause, 2.1.5.1.2, 3.1.9.1.2
- CREATE_MVIEW_REPGROUP procedure, 3.1.3.2
- CREATE_MVIEW_REPOBJECT procedure, 3.1.3.2
D
- data dictionary
-
- replication, 1.5.3
- data integrity
-
- parallel propagation, 2.2.6.1.1
- serial propagation, 2.2.6.1.1
- data propagation
-
- and dependency maintenance, 2.2.6.1
- asynchronous, 2.2.4.1.1
- synchronous, 2.2.4.1.2
- database links
-
- connection qualifiers, 2.2.1.2.2
- diagnosing problems with, A.1
- incomplete specifications, A.3.3
- materialized view sites, 6.3.3.4, 6.8.1.5
- replication, 2.2.1.2
- Replication Management tool, 2.2.1.2.1
- scheduled links, 1.4.3.1
- date expressions, 3.2.4.2.1, 4.3.3.2
- DBA_MVIEW_REFRESH_TIMES view, 3.1.10.1
- DBA_REGISTERED_MVIEWS view, 3.1.10.1
- DBA_REPCATLOG view, 2.2.2.3.1
- DBA_TYPE_VERSIONS
-
- replication, 2.1.5.1, 3.1.9.1
- DBMS_DEFER_SYS package
-
- SCHEDULE_PUSH procedure, 6.5.1, 6.5.2
- DBMS_MVIEW package, 3.1.10.3
-
- EXPLAIN_MVIEW procedure, 3.1.7
- REGISTER_MVIEW procedure, 3.1.10.3
- DBMS_REPCAT package, 2.2.2.3.1, 2.2.2.3.1, 2.2.2.4, 3.1.3.2, 6.11.3.1.1
-
- COMPARE_OLD_VALUES procedure
-
- conflict resolution, 5.2.6
- CREATE_MVIEW_REPGROUP procedure, 3.1.3.2
- DO_DEFERRED_REPCAT_ADMIN procedure, 2.2.2.3.1, 2.2.2.4
- SEND_OLD_VALUES procedure
-
- conflict resolution, 5.2.6
- DDL statements
-
- replication, 1.5.4
-
- troubleshooting problems, A.2.2
- deadlocks
-
- resolving
-
- in synchronous propagation, 2.2.4.2.1
- deferred transaction queues, 1.4.1, 2.2.1.6
-
- diagnosing problems with, A.3
- purging propagated transactions, 6.6
- pushing, 2.2.1.8.3
- scheduled purge, 6.3.3.6
- scheduled push, 6.3.3.7
- DELAY_SECONDS parameter, 2.2.5.3
- dependencies
-
- minimizing, 2.2.6.1.3
- dependency
-
- ordering
-
- replicated transactions, 2.2.6.1
- tracking
-
- parallel propagation, 2.2.6.1.1
- row level, 2.2.6.1.2, 6.1.4
- Deployment Template Wizard, 7.4.3
- deployment templates, 1.4.2.8, 4
-
- adding materialized views to, 4.3.1.1
- after instantiation, 4.3.3
- architecture, 4.3
- column subsetting, 4.4.1
- concepts, 4.2
- data sets, 4.4.3
- DDL statements, 4.3.1.1
- definition storage, 4.3.1
- design, 4.4
- elements, 4.2.1
- general template information, 4.2.1.1
- instantiation, 1.4.2.8.1, 4.2.2
-
- offline, 4.2.2.2, 4.3.2.4
- online, 4.2.2.1, 4.3.2.3
- options, 4.3.2.5
- process, 4.3.2
- scenarios, 4.2.2.3
- troubleshooting, A.4.2
- local control, 4.5.1
- materialized view groups, 4.3.3.1
- materialized view logs, 4.2.2.3
- materialized view sites, 4.2.1.6
- objects
-
- definitions, 4.2.1.2, 4.3.1.1
- packaging, 4.2.2
-
- for offline instantiation, 4.3.2.2
- for online instantiation, 4.3.2.1
- options, 4.3.2.5
- procedures, 4.2.2.3
- process, 4.3.2
- parameters, 4.2.1.3
-
- security, 4.2.1.4
- preparing materialized view sites for, 6.8
- refresh groups, 4.3.3.2
- row subsetting, 4.4.2
- user authorization, 4.2.1.5
- user-defined types, 4.2.1.2
- WHERE clause, 4.2.1.4
- direct path load
-
- fast refresh, 3.2.4.1.2
- discard conflict resolution method, 5.2.3.3, 5.2.4.3
- distributed schema management, 1.5.4
- distributed transactions
-
- problems with, A.3.2
- DML statements
-
- replication
-
- troubleshooting problems, A.2.3
- DO_DEFERRED_REPCAT_ADMIN procedure, 2.2.2.3.1, 2.2.2.3.1, 2.2.2.4
- domain indexes
-
- replication, 2.2.1.3.2
- dynamic sites
-
- ownership, 5.1.6.2
E
- earliest timestamp conflict resolution method, 5.2.3.4
- errors
-
- error queues, 2.2.1.8.2
-
- conflicts, 5.2.1.2
- EXISTS condition
-
- materialized views with subqueries, 3.1.6.2
- EXPLAIN_MVIEW procedure, 3.1.7
F
- failover sites
-
- implementing using FAILOVER option, 6.11.3
- fast refresh, 1.4.2.5, 3.2.4.1.2
-
- avoiding problems, 6.3.6
- determining possibility of, 3.1.7
- direct path load, 3.2.4.1.2
- multitier materialized views, 3.2.4.1.2
- filter columns, 6.3.4.1
- force refresh, 1.4.2.5, 3.2.4.1.3
- foreign keys
-
- replicated tables, 6.1.2
- function-based indexes
-
- replication, 2.2.1.3.1
- functions
-
- replicating, 2.2.1.3.4
G
- GLOBAL_NAMES initialization parameter, 6.2
- group owner
-
- materialized view groups, 3.2.3.1.1
H
- horizontal partitioning. See row subsetting
I
- Import
-
- materialized view logs, 3.2.1.3.2
- replication check, 6.11.3.1.1
- indexes
-
- materialized view sites, 3.2.2.1
- on foreign keys, 6.1.2
- replication, 2.2.1.3.2
- indextypes
-
- replication, 2.2.1.3.8
- initialization parameters
-
- editing, 6.3.3.8
- GLOBAL_NAMES, 6.2
- JOB_QUEUE_PROCESSES, 2.2.2.3.1, 6.2
- NLS_LENGTH_SEMANTICS, B.1
- OPEN_LINKS, 2.2.1.2.2, 6.2
- PARALLEL_MAX_SERVERS, 2.2.5.1, 6.2
- PARALLEL_MIN_SERVERS, 2.2.5.1, 6.2
- PROCESSES, 6.2
- replication, 6.2
- REPLICATION_DEPENDENCY_TRACKING, 6.2
- SGA_TARGET, 6.2
- SHARED_POOL_SIZE, 6.2
- INIT.ORA parameters. See initialization parameters
- instantiation
-
- deployment templates, 1.4.2.8.1, 4.2.2
- interoperability
-
- replication, 6.4
J
- job queue processes
-
- replication, 6.3.3.8
- job queues, 2.2.1.8.3
- JOB_QUEUE_PROCESSES initialization parameter, 2.2.2.3.1, 6.2, 6.3.3.8
- jobs
-
- checking for scheduled links, A.3.1
- replication, 2.2.2.3.1
L
- latest timestamp
-
- conflict resolution method, 5.2.2.1
- length semantics
-
- replication, B.1
- levels
-
- multitier materialized views, 3.1.8
M
- many to many subqueries
-
- materialized views, 3.1.6.1.3
- many to one subqueries
-
- materialized views, 3.1.6.1.1
- mass deployment, 3.1.2.2, 4.1
- master definition site, 1.3.3, 2.1.1.3.1
- master groups, 1.3.3, 2.2.3.1
- master materialized view sites, 3.2.1
- master materialized views, 1.4.2, 3.1.8, 3.2.1.1
-
- materialized view logs, 3.2.1.3
- master sites, 1.3.3
-
- adding
-
- circular dependencies, 2.2.1.3.1
- self-referential constraints, 2.2.1.3.1
- advantages of, 6.3.1
- bulk updates, A.2.5
- compared with materialized view sites, 6.3
- constraints
-
- violations, A.2.5
- DDL changes not propagated, A.2.2
- diagnosing problems with, A.2
- DML changes not propagated, A.2.3
- internal triggers, 3.2.1.2
- length semantics, B.2
-
- precreated tables, B.2.2
- materialized view registration, 3.1.10
- materialized views, 3.2.1
- replicated objects not created at new, A.2.1
- replication, 2.2.1
- roles, 2.2.1.1
- scheduled links for
-
- guidelines, 6.5
- scheduled purges for, 6.3.3.6
-
- guidelines, 6.6
- users, 2.2.1.1
- master tables
-
- materialized view logs, 3.2.1.3
- materialized views, 3.2.1.1
- redefining online, 3.2.1.3
- reorganizing, 3.2.1.3
- Materialized View Group Wizard, 7.4.2
- materialized view groups, 1.3.3, 3.1.8.2.2, 3.2.3.1
-
- deployment templates, 4.3.3.1
- group owner, 3.2.3.1.1
- ownership, 3.1.8.2.2
- updatable materialized views, 3.2.3.1
- materialized view logs, 1.4.2.7, 3.2.1.3
-
- adding columns to, 6.3.4.1
- column logging, 3.1.6.2
-
- many to many subqueries, 3.1.6.2
- many to one subqueries, 3.1.6.2
- ON PREBUILT TABLE clause, 3.1.6.2
- one to many subqueries, 3.1.6.2
- combination, 3.2.1.3
- creating, 6.3.4
- deployment templates, 4.2.2.3
- filter columns, 6.3.4.1
- Import, 3.2.1.3.2
- join columns, 6.3.4.1
- logging columns, 6.3.4.1
- object ID, 3.2.1.3
- object tables, 3.2.1.3.1
- primary key, 3.2.1.3
- privileges required to create, 6.3.4
- REFs, 3.1.9.5.3
- ROWID, 3.2.1.3
- trigger, 3.2.1.2
- troubleshooting, A.4.3.5
- underlying table for, 3.2.1.3
- materialized view sites, 1.3.3
-
- adding
-
- avoiding problems, 6.3.6
- advantages of, 6.3.2
- compared with master sites, 6.3
- database links, 6.3.3.4, 6.8.1.5
- database version, 6.8.1.2
- deferred transaction queues
-
- scheduled push, 6.3.3.7
- deployment templates, 4.2.1.6
- length semantics, B.3
-
- prebuilt container tables, B.3.1
- local creation, 4.5
- network connectivity, 6.8.1.1
- preparing for deployment templates, 6.8
- rollback segments, 6.8.1.7
- schedule purge
-
- guidelines, 6.6
- scheduled links for
-
- guidelines, 6.5
- schemas, 6.8.1.4
- setup, 6.8.1.3
- materialized views, 1.4.2, 3
-
- architecture, 3.2
- BUILD DEFERRED
-
- troubleshooting, A.4.4
- capabilities, 3.1.7
- collection columns
-
- restrictions, 3.1.9.4.1
- column objects
-
- column subsetting, 3.1.9.2
- column subsetting, 1.4.2.4
-
- column objects, 3.1.9.2
- complex, 3.1.4.4, 3.1.4.4.1
-
- value for PCTFREE, 3.2.4.1.1
- value for PCTUSED, 3.2.4.1.1
- concepts, 3.1
- constraints
-
- deferrable, 3.2.4.3
- creating, 6.3.5
- creating schemas for, 6.3.3.3
- creator, 3.1.5
- data subsetting, 3.1.2.3, 3.1.6
- deployment templates, 1.4.2.8, 4
-
- user-defined types, 4.2.1.2
- disconnected computing, 3.1.2.4
- index, 3.2.2.1
- length semantics, B.3
-
- prebuilt container tables, B.3.1
- local control, 4.5.1
- mass deployment, 3.1.2.2
- master materialized view sites, 3.2.1
- master materialized views, 3.2.1.1
- master sites, 3.2.1
- master tables, 3.2.1.1
- materialized view groups, 3.2.3.1
- materialized view logs, 1.4.2.7, 3.2.1.3
- multitier, 1.4.2, 3.1.8, 3.1.8.2.2
-
- conflict resolution, 5.1.5.1
- fast refresh, 3.2.4.1.2
- levels, 3.1.8
- master materialized views, 3.1.8
- restrictions, 3.1.8.2
- nested tables
-
- restrictions, 3.1.9.4.1
- network loads, 3.1.2.1
- object materialized views, 3.1.9.3.1
-
- OID preservation, 3.1.9.3.3
- object tables, 3.1.9.3
- owner, 3.1.5
- Partition Change Tracking (PCT), 3.2.4.1.2
- preparing for, 6.3.3
- primary key, 3.1.4.1, 3.1.6.2
- privileges, 3.1.5, 6.3.3.5
- read-only, 1.4.2.1, 3.1.3.1
-
- registration, 3.1.10.3
- unregistering, 3.1.10.3
- refresh groups, 1.4.2.6, 3.2.3.2
-
- size, 3.2.3.3
- refresher, 3.1.5
- refreshing, 1.4.2.5, 3.2.4
-
- complete, 3.2.4.1.1
- failures, A.4.3.2
- fast, 3.1.7, 3.2.4.1.2
- force, 3.2.4.1.3
- initiating, 3.2.4.2
- interval, 3.2.4.2.1
- on-demand, 3.2.4.2.2
- querying for last refresh time, 3.1.10.1
- retries, A.4.3.2
- troubleshooting, A.4.3, A.4.3.4
- REFs, 3.1.9.5
-
- logging, 3.1.9.5.3
- scoped, 3.1.9.5.1
- unscoped, 3.1.9.5.2
- WITH ROWID clause, 3.1.9.5.4
- registration, 3.1.10
- reorganizing, 3.2.1.3
- row subsetting, 1.4.2.4, 3.1.6
- rowid, 3.1.4.3
- simple, 3.1.4.4.1
- simple subquery
-
- AND condition, 3.1.6.2
- subqueries, 3.1.6.1
-
- column logging, 3.1.6.2
- EXISTS condition, 3.1.6.2
- joins, 3.1.6.2
- many to many, 3.1.6.1.3
- many to one, 3.1.6.1.1
- one to many, 3.1.6.1.2
- OR condition, 3.1.6.2
- primary key materialized views, 3.1.6.2
- restrictions, 3.1.6.2, 3.1.6.2
- trace file, A.4.3.2
- troubleshooting, A.4
- types of, 3.1.4
- unions with subqueries, 3.1.6.1.4
-
- restrictions, 3.1.6.3
- updatable, 1.4.2.2, 3.1.3.2
-
- column aliases, 3.1.3.2
- DELETE CASCADE constraint, 3.1.3.2, 3.2.4.3
- length semantics, B.3.2
- materialized view groups, 3.2.3.1
- updatable materialized view logs, 3.2.2.2
-
- trigger for, 3.2.2.3
- user-define, 3.1.9
- user-defined datatypes
-
- ON COMMIT REFRESH clause, 3.1.9
- uses for, 3.1.2
- varrays
-
- r, 3.1.9.4.1
- writeable, 3.1.3.3
- maximum conflict resolution method, 5.2.3.5
- minimum communication, 2.2.5.2
- minimum conflict resolution method, 5.2.3.6
- multimaster replication, 1.4.1, 2
-
- architecture, 2.2
- asynchronous, 2.1.3, 2.1.3.1
- concepts, 2.1
- disconnected materialized views, 2.1.2.3
- failover, 2.1.2.1
- load balancing, 2.1.2.2
- synchronous, 2.1.3, 2.1.3.2
- transaction propagation protection, 2.2.6
- uses for, 2.1.2
- multitier materialized views, 1.4.2, 3.1.8
-
- conflict resolution, 5.1.5.1
- fast refresh, 3.2.4.1.2
- levels, 3.1.8
- master materialized views, 3.1.8
-
- restrictions, 3.1.8.2.1
- materialized view groups
-
- ownership, 3.1.8.2.2
- restrictions, 3.1.8.2
N
- NCHAR datatype
-
- Unicode, B.5
-
- interoperability, B.5
- NCLOB datatype
-
- length semantics, B.5.1
- nested tables
-
- column groups, 5.2.1.1.5
- conflict resolution, 5.1.5.3
- materialized views, 3.1.9.4
-
- restrictions, 3.1.9.4.1
- replication, 2.1.5.3, 3.1.9.4
- network
-
- FAILOVER option, 6.11.3
- NLS_LENGTH_SEMANTICS initialization parameter, B.1
- NOROWDEPENDENCIES clause, 2.2.6.1.2
- NVARCHAR datatype
-
- Unicode, B.5
-
- interoperability, B.5
- n-way replication. See multimaster replication
O
- object identifiers
-
- agreement for replication, 2.1.5.1, 3.1.9.1
- object materialized views, 3.1.9.3.1
-
- OID preservation, 3.1.9.3.3
- object tables
-
- column groups, 5.2.1.1.4
- materialized view logs, 3.2.1.3.1
- materialized views, 3.1.9.3
- replication, 2.1.5.2
- object-relational model
-
- replication, 2.1.5, 3.1.9
- objects
-
- replicated
-
- re-creating, A.2.6
- OF object_type clause
-
- object materialized views, 3.1.9.3.1
- OID clause
-
- CREATE TYPE statement, 2.1.5.1.2, 3.1.9.1.2
- ON COMMIT REFRESH clause
-
- of CREATE MATERIALIZED VIEW, 3.1.9
- ON PREBUILT TABLE clause, 3.1.6.2
-
- length semantics, B.3.1
- one to many subqueries
-
- materialized views, 3.1.6.1.2
- online redefinition of tables, 3.2.1.3
- OPEN_LINKS initialization parameter, 2.2.1.2.2, 6.2
- OR condition
-
- materialized views with subqueries, 3.1.6.2
- Oracle Data Pump
-
- Advanced Replication, 1.5.4
- Oracle Enterprise Manager Console
-
- Oracle Replication Management tool, 7
- Oracle Real Application Clusters
-
- compared to replication, 2.1.2.4, 6.11.1
- Oracle Replication Management tool, 1.5.1, 7
-
- first login, 7.2
- interface, 7.3
- Navigator pane, 7.3.1
- right pane, 7.3.2
- Topology tab, 7.3.2.1
- usage scenarios, 7.1
- wizards, 7.4
-
- Copy Template, 7.4.5
- Deployment Template, 7.4.3
- Materialized View Group, 7.4.2
- Setup, 7.4.1
- Template Script Generation Wizard, 7.4.4
- overwrite conflict resolution method, 5.2.2.2
P
- packages
-
- replication, 2.2.1.3.3
- packaging deployment templates, 4.2.2
- parallel propagation, 2.2.5.1
-
- configuring for replication environments, 2.2.5.1
- dependency
-
- tracking, 2.2.6.1.1
- implementing, 2.2.5.1.1
- planning for, 6.7
- replication environment, 6.7
- row level SCN, 2.2.6.1.2
- tuning, 2.2.5.1.2
- PARALLEL_MAX_SERVERS initialization parameter, 2.2.5.1, 6.2
- PARALLEL_MIN_SERVERS initialization parameter, 2.2.5.1, 6.2
- parameters
-
- deployment templates, 4.2.1.3
- PCTFREE parameter
-
- value for complex materialized views, 3.2.4.1.1
- PCTUSED parameter
-
- value for complex materialized views, 3.2.4.1.1
- peer-to-peer replication. See multimaster replication
- performance
-
- replication, 2.2.5
- periodic purges
-
- scheduling, 6.6.1
- periodic pushes
-
- scheduling, 6.5.1
- planning
-
- for replication, 6
- PRIMARY KEY constraints
-
- materialized views, 3.1.4.1, 3.1.6.2
- replicated tables, 6.1.1
- primary sites
-
- ownership, 5.1.6.2
- priority groups conflict resolution method, 5.2.3.7
- privileges
-
- materialized views, 3.1.5, 6.3.3.5
- procedural replication, 1.7.2
-
- detecting conflicts, 1.7.2.1
- restrictions, 2.2.1.3.3
- wrapper, 1.7.2
- procedures
-
- replicating, 2.2.1.3.4
- PROCESSES initialization parameter, 6.2
- propagation, 2.2.4
-
- initiating, 2.2.4.4
- modes, 2.2.4.3
- parallel, 2.2.5.1
-
- implementing, 2.2.5.1.1
- tuning, 2.2.5.1.2
- security context of propagator, 2.2.4.2
- propagator
-
- replication, 2.2.1.1.2
- purges
-
- deferred transaction queue
-
- scheduling continuous, 6.6.2
- scheduling periodic, 6.6.1
- pushes
-
- deferred transaction queue
-
- scheduling continuous, 6.5.2
- scheduling periodic, 6.5.1
Q
- quiescing, 1.4.1.1, 2.2.2.1
-
- single master
-
- reduced, 3.1.3.2
R
- read-o, 3.1.10.3
- read-only materialized views, 1.4.2.1, 3.1.3.1
-
- registration
-
- manual, 3.1.10.3
- receiver
-
- replication, 2.2.1.1.3
- recovery
-
- replication environments, 6.11.3.1
- redefining tables
-
- online
-
- replication, 3.2.1.3
- referential integrity
-
- self-referential constraints, 2.2.1.3.1
- refresh
-
- automatic, 3.2.4.2.1
- complete, 3.2.4.1.1
- failures, A.4.3.2
- fast, 3.2.4.1.2
-
- determining possibility of, 3.1.7
- force, 3.2.4.1.3
- group, 3.2.4.2.1
- initiating, 3.2.4.2
- interval, 3.2.4.2.1
- manual, 3.2.4.2.2
- materialized views, 1.4.2.5, 3.2.4
- on-demand, 3.2.4.2.2
- retries, A.4.3.2
- rollback segments
-
- troubleshooting, A.4.4
- scheduling, 3.2.4.2.1
-
- troubleshooting, A.4.4
- troubleshooting
-
- ORA-12004 error, A.4.4
- ORA-942 error, A.4.4
- truncating materialized views
-
- troubleshooting, A.4.4
- refresh groups, 1.3.3, 1.4.2.6, 3.2.3.2
-
- deployment templates, 4.3.3.2
- size considerations, 3.2.3.3
- troubleshooting, A.4.3
- REFRESH procedure, 3.2.4.2.2
- REFRESH_ALL_MVIEWS procedure, 3.2.4.2.2
- REFRESH_DEPENDENT procedure, 3.2.4.2.2
- REFs
-
- materialized views, 3.1.9.5
- replication, 2.1.5.4, 3.1.9.5
- REGISTER_MVIEW procedure, 3.1.10.3
- REPCAT_IMPORT_CHECK procedure, 6.11.3.1.1
- replication
-
- administration, 1.5, 2.2.2
- administrative request queue, 2.2.2.4
- administrative requests, 2.2.2.3
-
- states, 2.2.2.4
- applications that use, 1.2
- assignment tables, 4.4.2.1
- asynchronous propagation, 1.4.1, 2.2.4.1.1
- availability, 6.11
- character sets, B
- checking imported data, 6.11.3.1.1
- column groups, 2.2.3.2
- column subsetting, 1.4.2.4
- compared to Oracle Real Application Clusters, 2.1.2.4, 6.11.1
- conflict resolution, 1.6, 2.1.4, 2.2.7.2
- conflicts
-
- detecting, 2.2.7
- procedural replication, 1.7.2.1
- connection qualifiers, 2.2.1.2.2
- creating an environment, 7.5
- data requirements, 5.1.1
- database links, 2.2.1.2
-
- CONNECT TO clause, 2.2.1.2
- Replication Management tool, 2.2.1.2.1
- USING clause, 2.2.1.2
- DDL statements, 1.5.4
- deferred transaction queues, 2.2.1.8.1
-
- diagnosing problems with, A.3
- deferred transactions, 1.4.1, 2.2.1.6
- defined, 1.1
- DELAY_SECONDS parameter, 2.2.5.3
- dependencies
-
- minimizing, 2.2.6.1.3
- dependency tracking, 2.2.6.1.2
- deployment templates, 1.4.2.8, 4
-
- user-defined types, 4.2.1.2
- distributed schema management, 1.5.4
- error queues, 2.2.1.8.2
- failover, 6.11.3
- filter columns, 6.3.4.1
- flowchart for creating environment, 7.5
- groups, 1.3.2, 2.2.3.1
- hybrid configurations, 1.4.3
- Import check, 6.11.3.1.1
- indextypes, 2.2.1.3.8
- initialization parameters, 6.2
- internal procedures, 2.2.1.7
- internal triggers, 2.2.1.5
- interoperability, 6.4
-
- NCHAR datatype, B.5
- NVARCHAR datatype, B.5
- introduction, 1.1
- job queue processes, 6.3.3.8
- job queues, 2.2.1.8.3
- jobs, 2.2.2.3.1
- mass deployment, 4.1
- master, 1.4.2
- master definition site, 1.3.3
- master groups, 1.3.3, 2.2.3.1
- master materialized views, 1.4.2
- master sites, 1.3.3, 2.2.1
-
- advantages, 6.3.1
- materialized view groups, 1.3.3
- materialized view logs, 1.4.2.7
- materialized view sites
-
- advantages, 6.3.2
- materialized views, 1.4.2, 3
- minimum communication, 2.2.5.2
- modes, 2.2.2.1
- multimaster, 1.4.1, 2
- multitier materialized views, 1.4.2
- objects, 2.2.1.3
- performance, 2.2.5
- planning for, 6
- problems
-
- troubleshooting, A
- procedural replication, 1.7.2
- procedures
-
- troubleshooting, A.2.8
- propagation, 2.2.4
- propagator, 2.2.1.1.2
- quiesce, 1.4.1.1, 2.2.2.1
- real-time replication. See synchronous replication
- receiver, 2.2.1.1.3
- refresh, 1.4.2.5
- refresh groups, 1.3.3, 1.4.2.6
- replication administrator, 2.2.1.1.1
- replication management API, 1.5.2
- resuming, 2.2.2.2.2
- row subsetting, 1.4.2.4
- scheduled links, 1.4.3.1
- See Also materialized views
- single master, 2.1.1.2
- sites, 1.3.3
-
- choosing, 6.3
- survivability, 6.11
- suspending, 2.2.2.2.1
- synchronous, 1.7.1, 2.2.4.1.2
- tables, 6.1
-
- and DML incompatibility, A.2.4
- dependency tracking, 6.1.4
- DML incompatibility, A.2.4
- transaction propagation protection, 2.2.6
- transactions
-
- dependency ordering, 2.2.6.1
- triggers
-
- troubleshooting, A.2.8
- troubleshooting, A
- Unicode, B.5
- unsupported datatypes
-
- BFILE, 6.1.3
- LONG, 6.1.3
- user-defined datatypes, 2.1.5, 3.1.9
- uses of, 1.1
- virtual private database (VPD), 6.3.3.4
- replication catalog, 1.5.3
-
- DBA_MVIEW_REFRESH_TIMES, 3.1.10.1
- DBA_REGISTERED_MVIEWS, 3.1.10.1
- DBA_REPCATLOG, 2.2.2.3.1
- incorrect views, A.3.4
- USER_REFRESH, A.4.3.2
- USER_REFRESH_CHILDREN, A.4.3.2
- replication management API, 1.5.2, 2.2.2.3
- Replication Management tool. See Oracle Replication Management tool
- replication objects, 1.3.1, 2.2.1.3.7, 2.2.1.3.7
-
- at materialized view sites
-
- problems creating, A.4.1
- functions, 2.2.1.3.4
- indexes, 2.2.1.3.2
-
- function-based, 2.2.1.3.1
- on foreign keys, 6.1.2
- packages, 2.2.1.3.3
- procedures, 2.2.1.3.4
- re-creating, A.2.6
- sequences, 2.2.1.4
- tables, 2.2.1.3.1, 6.1
-
- dependency tracking, 6.1.4
- DML incompatibility, A.2.4
- foreign keys, 6.1.2
- primary keys, 6.1.1
- unable to generate support for, A.2.7
- triggers, 2.2.1.3.6
- REPLICATION_DEPENDENCY_TRACKING initialization parameter, 6.2
- restrictions
-
- procedural replication, 2.2.1.3.3
- rollback segments
-
- materialized view sites, 6.8.1.7
- row subsetting, 1.4.2.4
-
- deployment templates, 4.4.2
- materialized views, 3.1.6
- ROWDEPENDENCIES clause, 2.2.6.1.2
-
- creating tables, 6.1.4
- rowids
-
- rowid materialized views, 3.1.4.3
- rows
-
- identifying during conflict detection, 2.2.7.1
S
- SCHEDULE_PUSH procedure, 6.5.1, 6.5.2
- scheduled links, 1.4.3.1, 6.3.3.7
-
- continuous pushes, 6.5.2
- guidelines, 6.5
- parallel propagation, 6.7
- periodic pushes, 6.5.1
- serial propagation, 6.7
- scheduled purges
-
- guidelines, 6.6
- periodic purges, 6.6.1
- schemas
-
- creating for materialized views, 6.3.3.3
- security
-
- deployment templates, 4.2.1.4
- SEND_OLD_VALUES procedure, 5.2.6
- sequences
-
- replication, 2.2.1.4
- Setup Wizard, 7.4.1
- SGA_TARGET initialization parameter, 6.2
- shadow column groups, 5.2.1.1.2
- SHARED_POOL_SIZE initialization parameter, 6.2
- simple materialized views, 3.1.4.4.1
- site priority conflict resolution method, 5.2.3.8
-
- as a backup method, 5.2.2.1, 5.2.3.4
- snapshots. See materialized views
- store-and-forward replication. See asynchronous replication
- subqueries
-
- in unions
-
- materialized views, 3.1.6.1.4
- materialized views, 3.1.6.1, 3.1.6.2
-
- AND condition, 3.1.6.2
- column logging, 3.1.6.2
- EXISTS condition, 3.1.6.2
- joins, 3.1.6.2
- many to many, 3.1.6.1.3
- many to one, 3.1.6.1.1
- one to many, 3.1.6.1.2
- primary key, 3.1.6.2
- restrictions, 3.1.6.2
- subsetting
-
- materialized views, 3.1.6
-
- column objects, 3.1.9.2
- survivability, 6.11
-
- design considerations, 6.11.2
- implementing, 6.11.3
- Oracle Real Application Clusters and, 6.11.1
- synchronous replication, 1.7.1, 2.2.4.1.2, 2.2.4.1.2
-
- of destination of transactions, 2.2.4.2.2
- synonyms, 2.2.1.3.7
-
- replication, 2.2.1.3.7
- system change numbers
-
- row level, 2.2.6.1.2, 6.1.4
T
- tables
-
- length semantics, B.2
- precreated
-
- length semantics, B.2.2
- problems generating replication support for, A.2.7
- redefining online
-
- replication, 3.2.1.3
- replicating, 2.2.1.3.1, 6.1
-
- dependency tracking, 6.1.4
- DML incompatibility, A.2.4
- Template Script Generation Wizard, 7.4.4
- trace files
-
- materialized views, A.4.3.2
- transactions
-
- propagation
-
- protection mechanisms, 2.2.6
- triggers
-
- for materialized view log, 3.2.1.2
- for updatable materialized view logs, 3.2.2.3
- replicating, 2.2.1.3.6
- troubleshooting
-
- replication problems, A
U
- Unicode
-
- NCHAR datatype, B.5
- NVARCHAR datatype, B.5
- replication, B.5
- unions
-
- with subqueries
-
- materialized views, 3.1.6.1.4
- restrictions for materialized views, 3.1.6.3
- UNREGISTER_MVIEW procedure, 3.1.10.3
- updatable, 5.1.5.2
- updatable materialized view logs, 3.2.2.2
-
- trigger for, 3.2.2.3
- updatable materialized views, 1.4.2.2, 3.1.3.2
-
- column subsetting, 5.1.5.2
- DELETE CASCADE constraint, 3.1.3.2, 3.2.4.3
- length semantics, B.3.2
- materialized view groups, 3.2.3.1
- us, 3.1.9.2
- USER_REFRESH view, A.4.3.2
- USER_REFRESH_CHILDREN view, A.4.3.2
- user-defined datatypes
-
- materialized views, 3.1.9
-
- collections, 3.1.9.4
- object tables, 3.1.9.3
- ON COMMIT REFRESH clause, 3.1.9
- REFs, 3.1.9.5
- type agreement, 3.1.9.1
- replication, 2.1.5, 3.1.9
-
- collections, 2.1.5.3, 3.1.9.4
- column objects, 2.1.5, 3.1.9
- object tables, 2.1.5.2
- REFs, 2.1.5.4, 3.1.9.5
- type agreement, 2.1.5.1, 3.1.9.1
- USLOG$_, 3.2.2.2
V
- varrays
-
- materialized, 3.1.9.4
- materialized views
-
- restrictions, 3.1.9.4.1
- replication, 2.1.5.3, 3.1.9.4
- vertical partitioning. See column subsetting
- views, 2.2.1.3.7
-
- replication, 2.2.1.3.7
- virtual private database (VPD)
-
- Advanced Replication requirements, 6.3.3.4
W
- WHERE clause
-
- deployment templates, 4.2.1.4
- WITH ROWID clause
-
- REFs, 3.1.9.5.4
- wrapper
-
- procedural replication, 1.7.2
- writeable materialized views, 3.1.3.3