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']

For some reason periods *are* allowed within a link_name so a dblink called MY.LINK is valid.

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 



Back to the Top

Simon Sheppard
SS64.com