Before Creating Deployment Templates

Deployment templates simplify the task of deploying and maintaining many remote materialized view sites. Using deployment templates, you can define a collection of materialized view definitions at a master site and use parameters in the definitions so that the materialized views can be customized for individual users or types of users.

For example, you might create one template for the sales force and another template for field service representatives. In this case, a parameter value might be the sales territory or the customer support level. When a user instantiates a template, the appropriate materialized views are created and populated at the remote site.

Before you create a deployment template, complete the following tasks:

• Read Chapter 3, "Materialized View Concepts and Architecture" and Chapter 4, "Deployment Templates Concepts and Architecture" in Oracle Database Advanced Replication for more information.

  Understanding how materialized views are created and how they work will better prepare you to build deployment templates.

• Connect to the master site where you want to create the deployment template.

• Create a materialized view log for each master table that will support materialized views. 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, then configure conflict resolution for the master tables of the materialized views before you instantiate the deployment template.

  See About Conflict Resolution Methods for more information about configuring conflict resolution.