======oracle备份数据===========================
-- exp(导出) system(用户名) root(密码) owner(服务名) file(导出文件地址) log(导出日志地址)
exp system/root@ORCLS owner=HDWCS file=D:\SJ\hdwcs.dmp log=D:\SJ\hdwcs.txt
-- imp(导入)
imp coop/coop file= /data/oradata/backup/data_dbbak/exp_data_2.18.2.26dmp ignore=y log=/data/oradata/backup/data_dbbak/imp_data_2.18.2.26.txt fromuser="(coop,test1,test2)" touser="(coop,test1,test2)"
===================================远程================================
-- exp (导出)
exp hongtastock_account/hongtastock_account@192.168.1.22/orcl file=D:\hongta\hongtastock_account.dmp log=D:\hongta\hongtastock_account.log
--imp(导入) sdjyhtyw(用户名)10.1.69.99(远程地址) ORCLS(服务名) sdjyhtyw(密码) fromuser为导出时数据的归属用户 touser指定导入到某用户的表空间中 ignore=y:忽略创建表的错误
imp sdjyhtyw/sdjyhtyw@10.1.69.99/ORCLS file=E:\hongtastock_trade_service.dmp log=E:\hongtastock_trade_service.log fromuser=hongtastock_trade_service touser=sdjyhtyw ignore=y