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