<< Click to Display Table of Contents >>

Overview Materialized Views/Snapshots

Top Previous Next

Overview Materialized views is the default sheet. It presents a list of all materialized views (snapshots) owned by the current schema. Major columns are:

Name

Status

Last Refresh

Next Refresh

Refresh Group

The following operations are available from the context menu.

 

Create ...

Shows a modal dialog for creating a new snapshot or materialized view..

MatViewCompile

Compile

Opens an SQL window with a compile statement.

07_Drop

Drop ...

Drops the snapshot or materialized view.

 

Refresh

Refreshes the selected materialized view.

 

Refresh all

Refrehes all materialized views.

 

Show DDL

Generates DDL for the selected object to a file

 

Grid View

For more information, see object window

Below the grid, the privileges that were in effect at the time that the materialized view was created are shown.

Below that are the initialization parameters that concern materialized views.