日期:2014-05-16 浏览次数:20927 次
create database link "yuleiDBLink"
connect to "yulei" identified by "admin"
using ' (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.202)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ylwz)
)
)';
select * from test_user@yuleiDBLink.test.com.cn
Create snapshot log on test_user;
Create snapshot sn_test_user as select * from test_user @yuleiDBLink.test.com.cn