CREATE DATABASE LINK dblink
CONNECT TO remote_user IDENTIFIED BY password
USING 'remote_database';
== Lister ==
set lines 600
col DB_LINK format A30
col USERNAMEformat A20
col HOST format A40
SELECT DB_LINK, CREATED,USERNAME, HOST FROM ALL_DB_LINKS ;