1、数据库导出命令
exp wesoftwcp/wesoft@oradb file=f:/backup/%date:~0,10%.dmp log=f:/backup/%date:~0,10%.log
compress=n buffer=8092 consistent=y direct=n constraints=y feedback=10000 grants=y record=y indexes=y triggers=y rows=y
2、数据库导入命令
set UserName=wesoftwcp
set Passwd=wesoft
set DBName=@oradb
#set LogName=%UserName%gz.log
set FromUser=wesoftwcp
set ToUser=wesoftwcp
set FileName=F:/backup/2009-12-03.dmp
imp %UserName%/%Passwd%%DBName% fromuser=%FromUser% touser=%ToUser% file=%FileName%
pause