How do I create a DB Link?

How do you create a database link?

To create a private database link, you must have the CREATE DATABASE LINK system privilege. To create a public database link, you must have the CREATE PUBLIC DATABASE LINK system privilege. Also, you must have the CREATE SESSION system privilege on the remote Oracle database.

What are db links?

A database link is a connection between two physical database servers that allows a client to access them as one logical database.

How do I find my DB Link?

Any user can query USER_DB_LINKS to determine which database links are available to that user. Only those with additional privileges can use the ALL_DB_LINKS or DBA_DB_LINKS view.

How do I drop and recreate a DB Link?

4.1Backup the existing database link. ... 2Connect as the database link owner. ... 3Test the database link. ... 4Drop the database link drop database link DB_LINK_NAME;5Create the database link create database link DB_LINK_NAME connect USER identified by PASSWORD using 'connect_string';