월드버텍 블로그

내일을 향한 준비~~

–생성
create public database link vtexlink connect to id identified by password 
  using ‘(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = test)))’;

–조회
select * from tab@vtexlink;

Add A Comment

You must be logged in to post a comment.

Subscribe to 월드버텍 블로그