Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Release Notes

DB Navigator

DB Navigator shows the entire database structure as a tree with expandable nodes.

DB Navigator Toolbar

Icon Tool Tip Description

Back and Forward

Retrace your steps. Navigate between hyperlinked database objects and their dependent objects and components. Move between—

  • An object and its dependencies, and vice-versa
  • An index or trigger and the table to which it refers, and vice-versa
  • A collector type and the base type of table it is related to
  • A synonym and its base object

You can also use the Forward and Back buttons in conjunction with Up One Level.

Up One Level

Change hierarchy levels in the DB Navigator tree.

TIP: Use Back to return to the level where you first used moved up.

DB Navigator Preferences

Set and Save filters to limit the objects displayed in the tree.

Open the Filter Properties Dialog.

Fully Expand Node from DB Expand the selected DB Navigator node and all its descendants.
Refresh from Current Node Refresh the selected DB Navigator node.

Show/Hide Details Panel

Show / Hide details about the selected DB Navigator node.

  • When you select a Schema node or Object Type node (for example, Tables or Indexes) the details pane shows a list of objects contained in that node. This list allows for selection of multiple objects for batch operations like Drop, Extract DDL, or Compile.
  • When you select a specific object the details pane shows attributes of the selected object.

 

Using DB Navigator

DB Navigator displays all types of Oracle objects, giving you a hierarchical view of any schema, including dependent objects. The tree view includes nodes for "My Schema," "All Schemas," and "Current Instance."

This symbol

Indicates

The node can be expanded.

Click + to drill down to underlying objects or data.

Alternatively, press the right arrow key or the space bar while the node is selected.

The node can be collapsed.

Click the – sign.

Alternatively, press the left arrow key while the node is selected.

(Grayed text)

The database object at that node is disabled or offline.

(Red text)

The database object at that node is invalid.

 

TIP:

  • Drag objects or connections that you use frequently to the Project Manager for fast access.
  • Double click on an object to open it for editing (Visual Object Editors, Code Editor).
  • Further commands are available on a selected object (or objects). Try the Object Menu. Right click on the object.
  • When a property is a reference to another database object (for example the base table for an index, or synonym's base object), click on the reference in the Value column to jump to the referenced object's node and display its properties.
  • To move around in the Navigator window you can use the keyboard arrow keys. Use Page Up and Page Down to scroll multiple lines.
  • To purge objects: Select the object(s) in the Recycle Bin and right click Purge. Alternatively, right-click on the Recycle Bin node and select Empty Recycle Bin.

  • To copy an object from one schema to another:

    1. Open a second DB Navigator window.
    2. Drag the object from the source window to the target window.
    3. Execute the DDL displayed in the editing window
  • To switch to another session's DB Navigator window, select the session and click View | DB Navigator.
  • Your view of the Oracle Data Dictionary determines what objects you can see. For more information, see DBA Dictionary Views.

 

Related Topics

Open From: View Menu | DB Navigator

SQL Navigator Preferences: View | Preferences | General | Session

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating