Home > Managing Database Objects w... > Managing Materialized Views > Browsing a Materialized View

Previous

Next

Browsing a Materialized View

To view a materialized view:

On the Workspace home page, click SQL Workshop and then Object Browser.

Object Browser appears.
From the Object list, select Materialized Views.
From the Object Selection pane, select a view.

The Materialized View appears.

Summary of Available Views

Click the tabs at the top of the page to view different reports about the materialized view. Table: Available Views for Materialized View describes all available views.

Available Views for Materialized View

View	Description
Materialized View	(Default) Displays details about the columns in the materialized view, including: Column Name Data type Nullable flag Default value Primary key Click Drop to delete the current materialized view.
Data	Displays a report of the data in the columns. Actions you can perform include: Query - Enables you to sort by column. To restrict specific rows, enter a condition in the Column Condition field. Use the percent sign (%) for wildcards. From Order by, select the columns you want to review and click Query. Count Rows - Displays a report of the data in the current table. Download - Click this link to export the data as a comma-delimited file (.csv) file.
Details	Displays object details stored in `DBA_SNAPSHOTS` such as updatable and status.
Grants	Displays a list of grants on the current view, including grantee, privilege, and grant options. Actions you can perform in this view include Grant and Revoke.
Dependencies	Displays a list of objects that use (or depend) upon this materialized view.
SQL	Displays the SQL necessary to re-create this materialized view.