批量执行,赋值,备份

set filename=D:\databack\%date:~0,10%
exp.exe rpt/oracle@PGXCDW  file=%filename%_rpt.dmp  log=%filename%_rpt.log feedback=10000
exp.exe dw/oracle@PGXCDW  file=%filename%_dw.dmp  log=%filename%_dw.log feedback=10000
exp.exe ods/oracle@PGXCDW  file=%filename%_ods.dmp  log=%filename%_ods.log feedback=10000

COPY D:\databack\%date:~0,10%_rpt.*  \\10.192.220.61\d$\databack\60\CopyFrom60
COPY D:\databack\%date:~0,10%_dw.*  \\10.192.220.61\d$\databack\60\CopyFrom60
COPY D:\databack\%date:~0,10%_ods.*  \\10.192.220.61\d$\databack\60\CopyFrom60

posted @ 2011-12-23 10:10  木子非  阅读(213)  评论(0编辑  收藏  举报