Before Creating Materialized Views

A materialized view is a replica of a target master table from a single point-in-time. Whereas in multi master replication tables are continuously being updated by other master sites, materialized views are updated by one or more master tables through individual batch updates, known as refreshes, from a single master site.

A materialized view group maintains a partial or complete copy of the objects at the target master group. Materialized View groups cannot span across master group boundaries.

Before you create a materialized view group, complete the following tasks:

• See Oracle Database Advanced Replication for more information. Understanding the concepts behind materialized views will better prepare you to create them.

• Create a materialized view log for each master table that will support materialized view sites. A materialized view log is required for materialized views to perform fast refreshes with the master table. See Creating Materialized View Logs for instructions.

• If conflicts are possible at the master site because of activity at the materialized view sites you are creating, configure conflict resolution for the master tables of the materialized views before you create the materialized views. See About Conflict Resolution Methods for more information about configuring conflict resolution.