imp 用户/密码@实例名 file=XXX.dmp log=XXX.log tables=表名
或者@ip:端口
向数据库B(目标库)的五张表:table11,table22,table33,table44,table55导入数据库A(源库)table11,table22,table33,table44,table55表的数据
1.先把数据库A的表rename为table1,table2,table3,table4,table5
2.导出:
exp erp/erp@erp_sj file=D:\erp.dmp log=erp.log tables=(table1,table2,table3,table4,table5)
3.导入:
imp erp/erp_2013@10.228.6.86:1521 file=D:\erp.dmp log=erp.log tables=(table1,table2,table3,table4,table5)
4.插入数据:
insert into table11 select * from table1;
insert into table22 select * from table2;
insert into table33 select * from table3;
insert into table44 select * from table4;
insert into table55 select * from table5;