DATABASE LINK

#오라클 DB링크
CREATE [PUBLIC] DATABASE LINK 링크명
[CONNECT TO 유져명 IDENTIFIED BY 패스워드]
USING '연결명';

DROP [PUBLIC] DATABASE LINK 링크명;

예)
drop public database link nbas_nm;

create public database link nbas_nm
connect to nbas_id identified by nbas_pw
using 'noribox_sid'

사용방법)
SELECT * FROM dept@nbas_nm

 

 

- write by 꼬마갱이 2009.12.11 -

-- 2019.04.28 추가

CREATE DATABASE LINK "DB링크명"
CONNECT TO "계정명"
IDENTIFIED BY "비번"
USING '(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = "아이피")(PORT = "포트"))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = "SID명")
    )
)';

GRANT CREATE DATABASE LINK TO "계정명";

.