Online Documentation for SQL Manager for Oracle

Using Navigation bar and Toolbar

The Navigation bar and Toolbar provide quick access to tools implemented in Materialized View Editor.

The Navigation bar of Materialized View Editor allows you to:

Object

select a database

select a materialized view for editing

General

compile the materialized view (if it is being created/modified)

set printing options to print metadata of the materialized view

edit the materialized view query using Design Query

refresh the content of the active tab

restore the default size and position of the editor window

View

view the dependency tree for the materialized view

Depending on the current tab selection, the Navigation bar expands to one or more additional panes with tab-specific actions that can be useful for working with the materialized view:

Data Management

commit transaction

rollback transaction

export data from the materialized view using Export Data Wizard

export data from the materialized view as Execute Script using Export as SQL Script Wizard

import data

Description

save object description to file

copy description to clipboard

DDL

save DDL to file

open DDL in Query Data

NB: You can enable\disable Toolbars and Navigation bars at Environment Options.