CREATE DATABASE LINK dblink CONNECT TO remote_user IDENTIFIED BY password USING 'remote_database';
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 ;