My Oracle Support Banner

Overview of the Types of Materialized Views Available (Doc ID 258227.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 7.0.16.0 to 12.2 BETA1 [Release 7.0 to 12.2]
Information in this document applies to any platform.

Purpose

This article gives a short description of materialized views (MVIEW) including readonly and updatable MVIEWs. The information supplied applies to Oracle releases from 7.x to 11.x.

Scope

The terms Materialized View (MVIEW) are synonymous and they will be used interchangeably.

The following terms are used in this article:

Examples are provided with the following assumptions:

  1. Master_db is the master site.
  2. Snap_db is the materialized view site
  3. There is a database link called master_db from SCOTT user of snap_db to the SCOTT schema of master_db

Note that the examples provided below do not supply all the details of the setup.
For a complete discussion of the MVIEW environment and configuration refer to Note:256241.1

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.