因项目需要,将A库上的hr schema复制到B库下hr scheme,使用oracle database link 能简单,快速处理。
A库,ip是192.168.201.148, 库名和服务名都是orcl9i, tnsnames.ora的连接名也是orcl9i
B库上,修改tnsnames.ora, 加入以下连接
orcl9i =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.201.148)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl9i)
)
)
然后就在B库上创建database link,
SQL> create public database link to_orcl9i connect hr identified by hr using 'orcl9i';
SQL> create user hr identified by hr default tablespace users;
SQL> create table jobs as select * from jobs@to_orcl9i;
ok, 可以检查两边数据了。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22126868/viewspace-1063528/,如需转载,请注明出处,否则将追究法律责任。