Network Topology   «Prev  Next»

Lesson 10 Creating a database link
Objective Explain the purpose and syntax of Oracle database links.

Creating Database Link using Oracle

After TNS connectivity has been established, database links are used to establish SQL-level connectivity between distributed databases. The first step is to create a hierarchical model to define the topology of your system. For our class project, the model might look like the following:

Database links are essentially transparent to the users of an Oracle distributed database system because the name of a database link is the same as the global name of the database to which the link points. For example, the following SQL statement creates a database link in the local database that describes a path to the remote Raleigh database.

connect to order_schema_user using secret_password
using ‘RAL’

Purpose of Database link