<< 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:



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..



Opens an SQL window with a compile statement.


Drop ...

Drops the snapshot or materialized view.



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.