Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Installation Notes

Object Menu

Operations on database objects.

Menu Icon Menu Name More Information

Create DB Object

Create a database object.

Open DB Object

Locate and open a database object.

Select DB Object Dialog


Open the selected database object for editing.

Not all database objects can be altered. You may need to drop the object and create a new one.


Show attributes, methods and arguments of the selected procedure, function, package, synonym, table, index or cluster.

Ensure the required database connection is active.


See also Auto Describe Tool


Rename the selected object.

Rename Object


Remove the selected object from the database.

To disable the Drop command: View | Preferences | General | "Drop" and "Truncate" safety options

(Oracle 10g and later): A recycle bin is available for handling and restoring dropped objects. You can use DB Navigator to retrieve objects dropped from the database. See also Find Recycle Bin Objects Dialog.

Drop with Purge

Remove the selected object from the database permanently. Do not place the object in the Recycle Bin.



Restore the selected object from the Recycle Bin.

Use DB Navigator to select an object in the Recycle Bin.

You can type a new name for the object in the New Name column if required.

Extract DDL

Extract the DDL or other SQL statements that define the selected object or access control. On requesting Extract DDL the SQL Navigator Preferences open: View | PreferencesExtract DDL | General.

SQL Navigator encloses non-alphanumeric and mixed-case object names inside double-quotes

You may like to use DB Navigator to select object(s).

Extract DDL runs as a background task. See Task Manager.

Get Metadata Get the metadata of the selected object(s).

Publish Java to PL/SQL

Create a PL/SQL package from the selected Java class stored in the database.

Publish Java to PL/SQL

Import Table

Import objects from a DMP file.

Import Table

Export Table

Export objects to a DMP file.

Export Table


Compile/Rebuild the selected object.

Menu Icon Menu Name More Information
Compile/Rebuild Compile the selected object.

Compile Dependents

Compile dependents of the selected object.

This eliminates the need to find and compile all dependent objects that became invalid when altering a procedure, table, or other structure.

Compile Dependencies Compile dependencies of the selected object.

See also Task Manager, Code Editor.

Watch for feedback in the Output Window. If the object compiles with errors, open it in the Code Editor and compile to make use of the Code Editor's error handling facilities.

If the object has been modified, you will need to save it before you can compile it. This is to ensure that the changes in the object have been applied to the database.


Execute the selected stored program and display the results in the PL/SQL Execution Console.

SQL Modeler

Open the selected object in SQL Modeler.

Scenario Example: Select a table in DB Navigator. Open the table in SQL Modeler. Build a query by selecting and dragging columns.

Quick Browse

Execute the SQL query for the selected table object in the Code Editor to view chained rows information.

See Quick Browse, SQL Query Results Data Grid

Edit Data

Execute the SQL query for the selected table object in the Code Editor with Updateable switched on.

See Edit Data, SQL Query Results Data Grid


View and collect statistics, validate structure and list chained rows for database structures such as tables, clusters and indexes.

Analyze Tool


Remove all rows from a table and reset the STORAGE parameters to the values when the table or cluster was created.

See also Task Manager.

To disable the Truncate command: View | Preferences | General | "Drop" and "Truncate" safety options


Oracle allocates space to objects in segments. Segments consist of contiguous sections called extents.

Menu Icon Menu Name More Information
Allocate Explicitly allocate a new extent for a selected table or index.


Deallocate unused space at "the end" of a segment and make that space available for other segments within the tablespace.

Coalasce Put together discontinuous fragmented extents.

For more information, see the Oracle documentation on the ALTER TABLE and ALTER INDEX commands.


Enable/Disable the selected constraint object.

If a constraint is enabled, Oracle automatically enforces it. If a constraint is disabled, Oracle does not enforce it.

See also Constraint Editor.

See also Task Manager.

Locate objects of type Constraint using Find objects Dialog.

Grant Grant object privileges for the selected object.
Revoke Revoke object privileges for the selected object.

Locate in Tree

When an object is open in an editing window, and you want to see where that object resides in the schema, you can use Locate in Tree to jump to that object’s node in DB Navigator.

Locate In Tree

Properties Show the properties of the selected object
Add to Project Add the selected object to the Project Manager
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating