I want to set the name of a file that will be generated automatically by adding a timestamp to its name.
the batch file is as follows:
echo export database for HR account
SET YYYYMMDD_HHMMSS=%DATE:~6,4%%DATE:~0,2%%DATE:~3,2%_%TIME:~0,2%%TIME:~3,2%
exp hr/esprit parfile=D:\exp_imp_4DS1\parfile_exp.par
rem pause end of export
parfile_exp.par:
FILE=D:\exp_imp_4DS1\hr_%YYYYMMDD_HHMMSS%.dmp
GRANTS=Y
INDEXES=Y
ROWS=Y
COMPRESS=Y
Executing the bat file gives me this error:
EXP-00028: failed to open D:\exp_imp_4DS1\hr_/28/Fr 1_1136.dmp for write
You should try with WMIC to get date independent of user settings date