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

Database Link Editor

Visual Object Editors > Database Link Editor

Use the Database Link Editor to view, create or define database links.

About Database Links

A database link allows access to a username on a remote database through the local database. A public database link (which only a DBA can create) allows the remote database access to all users of the local database.

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

 

Note:

  • The SQL Navigator Database Link editor will try to automatically add the domain name when required by the server. However if the user cannot see the view v$parameter, then the domain name is not automatically added. The user should enter a fully qualified database link name in the New Database Link dialog.
  • Due to limitations in the Oracle Data Dictionary it is not possible for Extract DDL to correctly apply the SHARED and AUTHENTICATED clauses in a CREATE DATABASE LINK statement

 

Ways to Open The Database Link Editor

Icon Action Description

From the Main Menu

View Menu | Visual Object Editors | Database Link Editor

Open the Database Link Editor.

From DB Navigator or Find objects Dialog

Right click on a Database Link object and click Open.

Open the selected Database Link object in the Database Link Editor.

Index Editor

Visual Object Editors > Index Editor

Use the Index Editor to view, create or alter indexes, and to set storage allocation.

About Index Objects

An index is a sorted map of selected columns in a table or object. Therefore an index is similar to a table, and the columns in an index refer to the rows and columns of the associated table. By indexing columns frequently used in queries, you can improve data retrieval performance.

An index can be either unique or non-unique.

  • A unique index validates every new or changed row in a table for a unique value in the column(s) in the index.
  • A non-unique index allows duplicate values in rows.

A non-unique index often enables faster queries.

Oracle8 supports a type of index called a bitmap index. A bitmap index uses a compressed bit-stream storage technique that allows very fast retrieval.

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

 

Ways to Open The Index Editor

Icon Action Description

From the Main Menu

View Menu | Visual Object Editors | Index Editor

Open the Index Editor.

From DB Navigator or Find objects Dialog

Right click on an Index object and click Open.

Open the selected Index object in the Index Editor.

Nested Table Editor

Visual Object Editors > Nested Table Editor

Use the nested table editor when you require a large, efficient collection.

About Nested Tables

A nested table type is an unordered set of elements. The elements may be built-in datatypes or user-defined types. You can view a nested table as a single-column table or, if the nested table is an object type, as a multicolumn table, with a column representing each attribute of the object type.

A nested table definition does not allocate space. It defines a datatype, which can then be used to declare:

  • columns of a relational table
  • object type attributes
  • PL/SQL variables, parameters, and function return values.

When a nested table appears as the type of a column in a relational table or as an attribute of the underlying object type of an object table, Oracle stores all of the nested table data in a single table, which it associates with the enclosing relational or object table.

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

Profile Editor

Visual Object Editors > Profile Editor

Use the Profile Editor to view, create or alter profiles.

About Profiles

A profile is a set of limits on the use of database resources that can be applied to a user. If you assign the profile to a user, that user cannot exceed those limits. If a user exceeds a limit, Oracle aborts and rolls back the transaction, and then ends the session. Profile settings include connect time, password lifetime and reuse, idle time, and similar restrictions.

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

Requirements

To edit profiles:

 

Ways to Open The Profile Editor

Icon Action Description

From the Main Menu

View Menu | Visual Object Editors | Profile Editor

Open the Profile Editor.

From DB Navigator

Right click on a Profile object and click Open.

Open the selected Profile object in the Profile Editor.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating