Complete the following steps:

  1. Create materialized view logs at master site (Creating Materialized View Logs).

  2. Create a deployment template (Creating a Deployment Template).

  3. Package template (Overview of Packaging and Instantiation).

  4. Distribute files (Distribute Instantiation Scripts: Step 3).

  5. Use SQL*Plus to set up materialized view site (Step 3 of Instantiate at a Remote Materialized View Site).

  6. Use SQL*Plus to instantiate template (Step 4 of Instantiate at a Remote Materialized View Site).

    Question: Was template instantiated online or offline? Choices: Online or Offline

    If online, then end. If offline, then go to Step 7.

  7. Optionally use the Replication Management tool or the management API (PL/SQL) to refresh each site (Step 4 of Instantiate at a Remote Materialized View Site).