Manage Data: Links

A global database link is a database link that links each database in a network to all other databases. This enables any user of any database in the network to specify a global object name in a SQL statement or object definition. The Links tab enables you to query, add or remove global database link.

Action

Query
Click to query for the global database link specified in the DB Link Name field.
Add
Click to create a new global database link. Specify the database link name in the DB Link Name field, and a valid user name and password credentials for the database.
Remove
Click to remove the global database link specified in the DB Link Name field.
Execute button
Click to perform the global database link query, add or remove operation.

DB Link

DB Link Name
Enter the global database link to query, add or remove.
User
Enter the global database user name when adding a global database link
Password
Enter the password for the database user name when adding a global database link.
DB Qualifiers button
Click to create or remove a link qualifier. A link qualifier is appended to a global database link to provide alternate settings for the database user name and password credentials. Link qualifiers are primarily for older Oracle database environments where multiple database links are used. Rather than use multiple database links, multiple link qualifiers can be created for a database link.