CREATE DATABASE LINK GUOYAO_KF
CONNECT TO guoyao
IDENTIFIED BY guoyao
USING 'GUOYAO_CS'
/
create database link guoyao
connect to GUOYAO identified by GUOYAO
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 173.3.51.207)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = GY)
)
)';
select * from t_restype@GUOYAO
CONNECT TO guoyao
IDENTIFIED BY guoyao
USING 'GUOYAO_CS'
/
create database link guoyao
connect to GUOYAO identified by GUOYAO
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 173.3.51.207)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = GY)
)
)';
select * from t_restype@GUOYAO