Skip to content

08. Database link

Jump to bottom
eshan3101 edited this page Jul 28, 2026 · 3 revisions

1] A Database Link (DB Link) in Oracle is an object that allows one database to access objects (tables, views, procedures, etc.) in another Oracle database as if they were local.

2]Think of it as a bridge that connects two Oracle databases so that one database can access objects in another database.

3]

+------------------+ +------------------+ | Database A | | Database B | | | | | | User: SCOTT | | User: HR | | EMP table | | EMPLOYEES table | +------------------+ +------------------+

A Database Link creates a connection between them. Database Link Database A -----------------------> Database B

TERMINAL 1 image

image image

TERMINAL 2 SOURCE DATABASE

image

TERMINAL 3 TARGET DB

image

Create DB Link │ ▼ Oracle checks tnsnames.ora │ ▼ Finds service name (PROD) │ ▼ Listener receives request │ ▼ Listener connects to PROD database │ ▼ SCOTT logs in │ ▼ Runs: SELECT SYSDATE FROM DUAL │ ▼ Returns result to local database

image

2.Checking IP image

3.seconf way to check IP image

4.opening 2nd VM image

5.doing settings in 2nd VM & pitting the IP address manually image

6.Checking IP address in 2nd machine image

7.checking connections in both the VM image

image

8.setting environment image

9.creating listners image

10.starting listener image

Clone this wiki locally