oracle数据导入导出脚本

oracle导入数据
imp oname/opass@orcl file="D:/oracle_backupfile/mydb.dmp" full=y

Oracle导出数据
@echo off
Set OrclSid=orcl
Set ExpUser=oname
Set ExpPass=opass
Set FileDir=D:/oracle_backupfile
Set SysDate=%date:~0,4%-%date:~5,2%-%date:~8,2%.%time:~0,2%%time:~3,2%

@echo * * * * * * * * * * * * * * * * * * * *
@echo * * * * * * * * * * * * * * * * * * * *
@echo * * * * * ORACLE 数据库导出 * * * * * *
@echo * * * * * * * * * * * * * * * * * * * *
@echo * * * * * * * * * * * * * * * * * * * *

@echo 服务名 = %OrclSid%
@echo 用户名 = %ExpUser%
@echo 密 码 = %ExpPass%
@echo 目 录 = %FileDir%
@echo 时 间 = %SysDate%

exp %ExpUser%/%ExpPass%@%OrclSid% file=%FileDir%/%ExpUser%_%OrclSid%_%SysDate%.dmp log=%FileDir%/%ExpUser%_%OrclSid%_%SysDate%.log

@echo 数据库导出完成
pause