Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - User Guide

Quick Overview Working With SQL Navigator Navigation Oracle Logon Code Editor Visual Object Editors Team Coding and Version Control Systems Modules, Windows And Dialogs
Analyze Tool Auto Describe Tool Benchmark Factory Bookmarks Dialog Capture Web Output Change Logon Password Dialog Code Analysis Code Assistant Code Road Map Code Templates Code Test Database Source Code Search Dialog DB Navigator Describe Difference Viewer Edit Data ER Diagram Explain Plan Tool Export Table Find and Replace Dialog Find objects Dialog Find Recycle Bin Objects Dialog Formatting Options HTML Viewer Import HTML as PL/SQL Import Table Java Manager Job Scheduler Locate In Tree Output Window PL/SQL Profiler Profile Manager Project Manager Publish Java to PL/SQL Quick Browse Rename Object Search Knowledge Xpert Select DB Object Dialog Server Output Server Side Installation Wizard Session Browser Source Preview SQL Modeler SQL Optimizer Task Manager Web Support Configuration Dialog Wrap Code
View | Preferences About Us

Redo Log Group Editor

Visual Object Editors > Redo Log Group Editor

Use the Redo Log Editor to view, create, or alter Redo Logs.

About Redo Logs

Every Oracle database has a set of two or more redo log files, collectively known as the database's redo log. Oracle uses the redo log to record all changes made to data.

The characteristics and usage of this database object are described in Oracle documentation.

 

Ways to Open The Redo Log Group Editor

Icon Action Description

From the Main Menu

View Menu | Visual Object Editors | Redo Log Group Editor

Open the Redo Log Group Editor.

From DB Navigator

Right click on a Redo Log Group object and click Open.

Open the selected Redo Log Group object in the Redo Log Group Editor.

Role Editor

Visual Object Editors > Role Editor

Use the Role Editor to view or create roles.

About Roles

A Role is a set of privileges that can be assigned to or removed from a user. (Use the User Editor to create and grant or revoke roles and privileges to users.)

The characteristics and usage of this database object are described in Oracle documentation.

Requirements

To edit roles:

 

Ways to Open The Role Editor

Icon Action Description

From the Main Menu

View Menu | Visual Object Editors | Role Editor

Open the Role Editor.

From DB Navigator

Right click on a Role object and click Open.

Open the selected Role object in the Role Editor.

Materialized View Editor

Visual Object Editors > Materialized View Editor

Use the Materialized (Snapshot) View Editor to view, create or define snapshots.

About Snapshots A snapshot is a segment that contains the result of a query. The snapshot typically contains local copies of remote objects. From Oracle 8i onwards a materialized view is equivalent to a snapshot but allows queries to be dynamically and transparently rewritten to use the materialized view.

 

Using The Editor

Editor Toolbar

Icon Tool Tip Description

Create new Materialized view

Open the New Materialized View dialog.

Field Description
Schema Select the parent schema for the new Materialized view.
Name Name the new Materialized view.

Open object from DB

Open the Select Materialized View dialog.

Select the materialized view from the database.

Clone current Materialized view Create a clone of the selected materialized view. You will be prompted in the New Materialized View dialog to enter new name.
Revert to pervious Materialized view Undo or revert any modifications made to the view.
Generate SQL for changes Generate SQL code for the changes made.
Apply changes to DB Apply changes to the database.

Editor Tabs

Tab Description

Details
  1. Select the Updateable and Query Rewrite options to include them in the query’s DLL.
  2. Set the Parallel options and turn Logging and Cache on or off.

Refresh
  1. Set the frequency of the refresh.
  2. Set the rollback segments to be included.
  3. Set when to populate the materialized view.

Storage
  1. Set the Physical Attributes for the materialized view log.
  2. Set the Storage Clause options for the materialized view log.

Master Info

Display the owner, table and links for the materialized view (after the materialized view has been saved).

 

Ways to Open The Materialized View Editor

Icon Action Description

From the Main Menu

View Menu | Visual Object Editors | Materialized View Editor

Open the Materialized View Editor.

From DB Navigator or Find objects Dialog

Right click on a Materialized View object and click Open.

Open the selected Materialized View object in the Materialized View Editor.

Sequence Editor

Visual Object Editors > Sequence Editor

Use the Sequence Editor to view, create, or alter sequences.

About Sequence Objects

A sequence is an Oracle object that delivers a unique number, incremented by some specified amount, every time it is requested. Sequences are usually used to generate a primary key for a table or for a set of tables. You can use the sequence to create unique number that you can use in your tables as primary identifiers.

The characteristics and usage of this database object are described in Oracle documentation.

 

Ways to Open The Sequence Editor

Icon Action Description

From the Main Menu

View Menu | Visual Object Editors | Sequence Editor

Open the Sequence Editor.

From DB Navigator or Find objects Dialog

Right click on a Sequence object and click Open.

Open the selected object in the Sequence Editor.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating