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.
|