A database link that is centrally stored in an Oracle Names server. 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 the 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
|
Note: A global database link that matches the database global database name is automatically registered with the Oracle Names server. |
|
See Also: Create a Global Database Link to create an global database link in an Oracle Names server. |