I tried to create a windows shell script to execute data dump work on daily basis. However, the command seems didn't work because it even didn't generate log file for me to identify the problem. Please give me a hand to solve this problem. Here is the windows command file and expdp parameter file.
1. windows command file
@echo off
rem
rem Filename: My_Expdp.bat
rem Purpose: Export tables of My database
rem Date: 08-Jan-2010
rem Author:
rem
rem -- Set parameters --
set EXPNAME=DB_Daily
set PATH=F:\ORACLE\PRODUCT\10.2.0\ADMIN\MYDB\DPDUMP
rem -- Keep 5 versions of the expdp log file --
if exist %PATH%%EXPNAME%_4.log copy %PATH%%EXPNAME%.log %PATH%%EXPNAME%_5.log >NUL:
if exist %PATH%%EXPNAME%_3.log copy %PATH%%EXPNAME%.log %PATH%%EXPNAME%_4.log >NUL:
if exist %PATH%%EXPNAME%_2.log copy %PATH%%EXPNAME%.log %PATH%%EXPNAME%_3.log >NUL:
if exist %PATH%%EXPNAME%_1.log copy %PATH%%EXPNAME%.log %PATH%%EXPNAME%_2.log >NUL:
if exist %PATH%%EXPNAME%.log copy %PATH%%EXPNAME%.log %PATH%%EXPNAME%_1.log >NUL:
rem -- Keep 5 versions of the expdp dump file --
if exist %PATH%%EXPNAME%_4.dmp copy %PATH%%EXPNAME%.dmp %PATH%%EXPNAME%_5.dmp >NUL:
if exist %PATH%%EXPNAME%_3.dmp copy %PATH%%EXPNAME%.dmp %PATH%%EXPNAME%_4.dmp >NUL:
if exist %PATH%%EXPNAME%_2.dmp copy %PATH%%EXPNAME%.dmp %PATH%%EXPNAME%_3.dmp >NUL:
if exist %PATH%%EXPNAME%_1.dmp copy %PATH%%EXPNAME%.dmp %PATH%%EXPNAME%_2.dmp >NUL:
if exist %PATH%%EXPNAME%.dmp copy %PATH%%EXPNAME%.dmp %PATH%%EXPNAME%_1.dmp >NUL:
rem -- Do the data pump --
expdp sys/syspassword@db parfile=%PATH%my_expdp.par
rem -- Add timestamp to top of export log file --
date /T >timestamp.tmp
copy timestamp.tmp + %PATH%%EXPNAME%.log %PATH%%EXPNAME%.tmp
copy %PATH%%EXPNAME%.tmp %PATH%%EXPNAME%.log
rem -- Cleanup temporary files --
del %PATH%%EXPNAME%.tmp
del timestamp.tmp
---parameter file
DUMPFILE=My_DB.DMP
LOGFILE=My_DB.LOG
DIRECTORY=Mydb_DIR
TABLE=My_table1, My_table2, My_table3
CONTENT=DATA_ONLY
JOB_NAME=My_DB_1