exp可以实现远程的导出和导入
-- 按用户远程导出
exp san/passward@10.24.135.26/orcl file=san_20220525.dmp log=exp_san.log ower=san;
-- 按表远程导出
exp san/passward@10.24.135.26/orcl file=san_20220525.dmp log=exp_san.log tables=channel_user,user_info,user_id_card_info,electronic_bank_card,electronic_bind_card,user_bind_card;
-- 按表导入到本地数据库
imp san/passward@localhost/orcl fromuser=san touser=san file=san_20220525.dmp log=imp_san.log ables=channel_user,user_info,user_id_card_info,electronic_bank_card,electronic_bind_card,user_bind_card;
参考博客:
https://blog.csdn.net/zmj1049933053/article/details/106528594
https://www.cnblogs.com/bugzeroman/p/12858112.html