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:
|
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
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 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
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:
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
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:
- You must have the CREATE PROFILE system privilege.
- Query the Oracle Data Dictionary with DBA Views. For more information, see DBA Dictionary Views.
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. |