Materialized Views

From RapidSQL
Jump to: navigation, search

Go Up to Supported Objects

Note: This object is supported by Oracle only.

Materialized views are used to dynamically copy data between distributed databases. There are two types of materialized views:

  • Complex
  • Simple

Complex materialized views copy part of a master table or data from more than one master table. Simple materialized views directly copy a single table. You cannot directly update the underlying data contained in materialized views.

Creating and editing

DBMS platform availability and object actions/operations supported

The table below lists the platforms on which this object type is available. It also lists the object actions available against objects of this type For an introduction to object actions and details on usage of specific actions, see Object actions.

ORCL

Compile

Create Synonym

Drop

Extract

Rename

Report

Shrink