Materialized Views

Go Up to Supported Objects

Note: Supported for 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

• Materialized Views Wizard (Oracle) and Materialized Views Editor (Oracle)

DBMS platform availability and object actions/operations supported

The following table 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.

Object Action	ORCL
Compile	✓
Create Synonym	✓
Drop	✓
Extract	✓
Migrate	✓
Rename	✓
Report	✓
Shrink	✓