Oracle PL/SQL: Create DB Link - Shows how to create a link to another oracle database and connect to it.

Quick Search:

Oracle PL/SQL: Create DB Link

Jump to:

Snippet Name: Create DB Link

Description: Shows how to create a link to another oracle database and connect to it.

Also see:
» Database Links: Close Database Link
» Create Database Link
» Database Link

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: February 27th, 2009

CREATE database link my_db_link
CONNECT TO x_username
identified BY x_userpassword
using 'orcl';
 
 
--to connect:
 
CONNECT x_user/x_user@orcl