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

 

Materialized View Log Editor - Using Navigation bar

 

The Navigation bar of Materialized View Log Editor allows you to:

 

Object

iconDB select a database

iconObjects_MaterializedViewLog select a materialized view log for editing

 

General

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

iconPrint set printing options to print metadata of the materialized view log

iconTools_QB edit the materialized view log query using Design Query

iconRefresh refresh the content of the active tab

iconRestoreDefaultSize restore the default size and position of the editor window

 

View

iconTools_DependencyTree view the dependency tree for the materialized view log

 

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

 

DDL

iconSaveToFile save DDL to file

iconTools_SQLEditor open DDL in Query Data

 

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