오라클에서 디비링크걸기

1. tnsnames에 원격DB 설정이 되어있는 경우 

create database link "ABCM_HBM"
connect to ODS_DEV
identified by "<pwd>"
using 'NEWGERY';

2. tnsnames에 원격DB 설정이 되어있지 않은 경우 

create public database link "ABCM_HBM"
  connect to ods_dev identified by ods_dev
  using '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.6.100)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = EDW)))';