Packaging for and Performing for Offline Instantiation

After you have built your deployment templates, you may want to perform an offline instantiation of a template at each target materialized view site. Offline instantiation allows users to instantiate a template without being connected to the master site through a network. Using offline instantiation, you write all of the necessary DDL and data to a script that you then transfer to the each materialized view site. Then, users run the script at the materialized view site using SQL*Plus. This solution is perfect for laptop users who do not have high-speed network connections, which could make online instantiation difficult.

The following scripts are generated:

• One setup script. The setup script prepares the materialized view site for replication.

• One or more template scripts. Each template script creates and populates the objects at the materialized view site. One script is generated for each user in the template.

• One refresh script. All of the materialized views created by the template scripts are in the same refresh group. Therefore, all users can share the same refresh script. Also, because all of the materialized views are in the same refresh group, refreshing the refresh group refreshes all of the materialized views created by the deployment template.

Complete the following steps to start the instantiation process:

1. In Enterprise Manager, connect to the Database Instance Home page as the replication administrator.

2. Click Data Movement.

3. Under the Advanced Replication section, click Manage.

   The Administration Overview page appears.

4. Under the Materialized View Replication, Master Site section, click the number link next to Templates.

   The Deployment Templates page appears.

5. From the Name list, select the template that you want to instantiate.

6. Select Generate Script from the Actions list.

7. Click Go.

   The Generate Template Script page appears.

Now, complete the following steps to create offline instantiation scripts:

1. Specify Instantiation Users: Step 1

2. Set Refresh Schedule and Select Schemas: Step 2

3. Distribute Instantiation Scripts: Step 3

4. Instantiate at Remote Materialized View Site: Step 4