bat 脚本常用命令介绍:http://ysj5125094.iteye.com/blog/2348997
@echo offrem 导出ctTableProfix相关表rem 导入命令:imp iem/[email protected] file=D:/bak/ctTableProfix.dmp log=D:/bak/imp.log full=yset v_dump_dir=D:/bak/set v_dump_bak=%v_dump_dir%ctTableProfix.dmpset v_dump_bak_log=%v_dump_dir%exp.logset v_oracle_bin=D:/app/client/shaojian.yu/product/12.1.0/client_1/BINset v_userName=rootset v_password=rootset v_serviceName=devset v_tables=(aTable, bTable, cTable, dTable)rem 判断文件是否存在if exist %v_dump_bak_log% ( rem log文件已存在 echo log file exist... ... ) else ( rem log文件不存在, 自动创建 echo log file not exist... ... echo=>%v_dump_bak_log%)cd %v_oracle_bin%rem 执行导出命令echo execute exp... ...exp %v_userName%/%v_password%@%v_serviceName% file=%v_dump_bak% log=%v_dump_bak_log% tables=%v_tables%cd %v_dump_dir%rem 导出完成echo done... ...