CREATE DATABASE LINK

Create a Database Link.

Syntax:

   CREATE [SHARED][PUBLIC] DATABASE LINK link_name
     [CONNECT TO CURRENT_USER]
        [USING 'connect_string']

   CREATE [SHARED][PUBLIC] DATABASE LINK link_name
      [CONNECT TO user IDENTIFIED BY password]
      [AUTHENTICATED BY user IDENTIFIED BY password]
         [USING 'connect_string']

Periods *are* allowed within a link_name so a dblink called MY.LINK is valid.

Example

CREATE Public Database Link SS64
Connect To scott Identified By demo
Using test;

SELECT count(*) from table@ss64;

"During my service in the U.S. Congress, I took the initiative in creating the Internet" - Al Gore

Related Commands:

DROP DATABASE LINK
ALTER SESSION CLOSE DATABASE LINK link_name
DBMS_HS_PASSTHROUGH

Related Views:

DBA_DB_LINKS        ALL_DB_LINKS        USER_DB_LINKS