This illustration shows a flowchart for creating materialized views.

  1. Start.
  2. Set up the materialized view site.
  3. Create materialized view logs at the master site.
  4. For individually created materialized views:

  5. Connect to a remote materialized view site.
  6. Create materialized views.
  7. End.
  8. For Deployment Template materialized view creation:

  9. Create a deployment template.
  10. Package the template and distribute.
  11. Instantiate the template at the materialized view site.
  12. End.