17,377
社区成员
发帖
与我相关
我的任务
分享
--把.BAT文件内容改为
@echo off
set dts=%date:~0,10%
imp jjwgps/jjwgps@orcl file=D:\work\buckup\test%dts%.dmp full=y ignore=y
-- 给个例子给你:
exp system/bee56915 file=D:\oracle_bak\system%date:~0,10%.dmp log=D:\oracle_bak\system%date:~0,10%.log owner=system
exp system/bee56915 file=D:\oracle_bak\scott%date:~0,10%.dmp log=D:\oracle_bak\scott%date:~0,10%.log owner=scott
exp system/bee56915 file=D:\oracle_bak\hedge%date:~0,10%.dmp log=D:\oracle_bak\hedge%date:~0,10%.log owner=hedge
path=C:\Program Files\WinRAR
rar a Date%date:~0,10%.rar *%date:~0,10%.dmp
rar a Log%date:~0,10%.rar *%date:~0,10%.log
del *%date:~0,10%.dmp
del *%date:~0,10%.log