메뉴 건너뛰기

tnt_db

Oracle 오라클 DB 링크 만들기

구퍼 2011.01.06 15:39 조회 수 : 6825

drop database link linkDB;

 

create database link linkDBconnect to bscuser identified by userpass
using '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 211.232.0.432)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = ora9)))';

 

select * from user_tables@linkDB;

위로