Create a Global Database Link

A global database link that is the same as the global database name is automatically registered with an Oracle Names server. Any client in the network can use a global database link to access an object in a database. For example, if the global database name is sales.us.acme.com, a global database link of sales.us.acme.com is created and registered with an Oracle Names server. A client can then use sales.us.acme.com to perform a SELECT statement on a table, for example:

SQL>SELECT * FROM emp@sales.us.acme.com

Unless you want to specify user name and password credentials, no additional configuration is required to use the default global database link. To define a user name and password for the default global database link, or create a new global database link:

  1. In the navigator pane, expand Oracle Net Configuration > Oracle Names Servers.

  2. Select the Oracle Names server.

  3. From the list in the right pane, select Manage Data.

  4. Select the Links tab.

  5. Select Add.

  6. Enter the global database link name in the DB Link Name field. If the GLOBAL_NAMES parameter has been set to true in the initialization parameter file, the name entered must be the global database name.

  7. If you want to use a link qualifier, see Append a Link Qualifier for a Global Database Link.

  8. Enter valid user name and password credentials for the database in the User and Password fields.

  9. Choose Execute.

  10. Choose File > Save Network Configuration.