不同数据库间拷贝数据 1、建立数据库dababase puble link create public database link link1 connect to uname identified by pwd using 'DB'; insert into A select * from B@link1 ;2、copy from 提示:bod 和snzj 服务名是远程或本地数据库在本地的服务名 copy from uname/pwd@db/*源库*/ to scott/tiger@snzj/*目标库*/ create/insert A using select * from B
1、在B中建立到A数据库的DBlink连接。例如: create public database link link_from_a connect to A数据库用户名 identified by 用户名对应的密码 using '(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = A数据库IP)(PORT = 1521)) ) (CONNECT_DATA = (SID = A数据库实例名) (SERVER = DEDICATED) )'; 2、insert into tb select * from tb@link_from_a;
1、建立数据库dababase puble link
create public database link link1 connect to uname identified by pwd using 'DB';
insert into A select * from B@link1 ;2、copy from
提示:bod 和snzj 服务名是远程或本地数据库在本地的服务名
copy from uname/pwd@db/*源库*/ to scott/tiger@snzj/*目标库*/ create/insert A using select * from B
create public database link link_from_a
connect to A数据库用户名 identified by 用户名对应的密码
using '(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = A数据库IP)(PORT = 1521))
)
(CONNECT_DATA =
(SID = A数据库实例名)
(SERVER = DEDICATED)
)';
2、insert into tb select * from tb@link_from_a;
或者 exp imp
建議可以用導出/導入,即exp/imp命令.
可以根据A中的数据,生成sql脚本,然后登录到B,执行这个脚本就可以了