Append a Link Qualifier to a Global Database Link

A link qualifier can be appended to a global database link. While one global database link per database is recommended, there is no limit on the number of link qualifiers that may be added. Link qualifiers are appended to global database links 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.

To create a link qualifier:

  1. Follow steps 1-6 in Create a Global Database Link.

  2. Choose DB Qualifiers.

  3. Choose Create Qualifier. The Database Qualifier dialog box appears.

  4. Enter a name for the link qualifier, a valid user name and password credentials, and then choose OK.