[oracle] link db

# 링크 생성 쿼리 (to 원격)

create database link LinkNaming
  connect to idname identified by "password"
  using '(DESCRIPTION =

    (ADDRESS =

      (PROTOCOL = TCP)

      (HOST = 111.111.111.111)

      (PORT = 1521))

    (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))';

# link 사용방법
select * from APP_AUTH@LinkNaming;
select max(LOG_DT) from APP_LOG@LinkNaming;

 

 

# 출처

계정리스트 및 권한 : https://aileen93.tistory.com/17
원격 오라클 링크DB : https://mikyung.net/479