Complete the following steps:
Create materialized view logs at master site (Creating Materialized View Logs).
Create a deployment template (Creating a Deployment Template).
Package template (Overview of Packaging and Instantiation).
Distribute files (Distribute Instantiation Scripts: Step 3).
Use SQL*Plus to set up materialized view site (Step 3 of Instantiate at a Remote Materialized View Site).
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.
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).