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

Oracle TNS Configuration Dialog

Oracle Logon > Oracle TNS Configuration Dialog
Field Description


The service name of the database.

Click Add to create a new configuration - Oracle TNS Configuration

Service configuration

Field Description


Specify the Oracle Instance.

Click Advanced to open the Advanced Service Options Dialog.

This field is visible if Use Oracle 8i release 8.0 Compatible Identification is selected.

Service name

Type the service name.

This field is visible if Use Oracle 8i release 8.0 Compatible Identification is clear.

Connection type

Select a database connection type from the Connection Type list for the net service name.

Oracle Corporation recommends you use the default setting of Database Default.

Use Oracle 8i release 8.0 Compatible Identification

Select if the destination service is prior to release 8.1, then type its SID in the SID field.

Clear if the destination service is an Oracle release 8.1 database, then type the service name in the Service Name field.

Address configuration

Field Description
Protocol Select a protocol from the list.
Host Name The host name of the computer where the database is located.
Port Number The TCP/IP port number. The default is 1521.
Add Add an address configuration.
Advanced Address List Options Dialog

Advanced Service Options Dialog

Oracle Logon > Advanced Service Options Dialog
Option Description
Instance Name Type the database instance to access
Session Data Unit Type the SDU (Session Data Unit) to optimize the transfer rate of data packets being sent across the network.
Use for Heterogeneous Services Select this option, if you want an Oracle8i server to access a non-Oracle system.

For further information see the Oracle Administrator’s Guide.

Address List Options Dialog

Oracle Logon > Address List Options Dialog
Option Description Compatibly with Net8 8.0 Clients

Try each address in order, until one succeeds

FAILOVER=ON for release 8.1 clients

SOURCE_ROUTE=OFF for pre-release 8.1 clients.


Randomly try each address until one succeeds




Try one address selected at random



Use each address in order until a destination is reached



Use only the first address





Best Practice: Unless multiple address options are configured, the first address in the list is contacted.

DBA Dictionary Views

Oracle Logon > DBA Dictionary Views

By default, SQL Navigator gives you USER object data dictionary views, meaning you can see only objects you own or for which you have been granted object privileges.

When you Enable DBA views in SQL Navigator you can...

Edit Profiles, Roles, and Users.

View the following nodes of the DB Navigator tree:

  • Roles
  • Some nodes under Users
  • Datafiles under Tablespaces
  • Redo Log Groups
  • Rollback Segments
  • Partitioned tables in another user’s schema

How to enable DBA views in SQL Navigator

Oracle Logon Dialog | Enable DBA Views

Oracle requirements to query DBA views

Your username must have one of the following roles or privileges:

  • DBA Role
  • SELECT ANY TABLE Privilege

DBA role and SELECT_CATALOG_ROLE role must be defined as the default roles in Oracle.

In addition to the SELECT ANY TABLE privilege, Oracle 9i may also require the user to have the SELECT ANY DICTIONARY privilege if the O7_DICTIONARY_ACCESSIBILITY initialization parameter is set to FALSE.

For information about system privileges, see the Oracle Database Administrator’s guide.


Note: Enabling DBA dictionary views may affect performance for some Oracle instances, depending on the number of users and objects, as well as other environmental factors.


How SQL Navigator handles the views

When DBA dictionary views are selected, SQL Navigator interrogates the data dictionary differently:

Regardless of DBA View setting, SQL Navigator uses USER_% views for the logged-on user's objects.

Without DBA Views, SQL Navigator uses ALL_% views for other user's objects.

With DBA Views, SQL Navigator uses SYS.DBA_% views for other user's objects.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating