为了将一个数据库里的数据导入到另一个数据库中,可以使用Oracle的db_link功能来完成。
1.创建db_link:
CREATE database link to_SC_LOCAL
CONNECT TO portal IDENTIFIED BY portal
USING '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.95.238.81)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';
2.删除db_link:
drop database link to_SC_LOCAL;
3.使用db_link查询远程数据库中的数据:
select * from tablename@to_SC_LOCAL(只有查询)
select t.*, t.rowid from tablename@to_SC_LOCAL t(可以修改,立即生效)
4.使用db_link导入数据:
insert into table select * from table@to_SC_LOCAL