DB 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

 

 

 

by 꼬마갱이 2008-01-16