global database link

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

 

notice.gif

Note: A global database link that matches the database global database name is automatically registered with the Oracle Names server.

 

seealso.gif

See Also: Create a Global Database Link to create an global database link in an Oracle Names server.