Hello All,
I am trying to perform a windows scheduler job which will create back up of my database daily once. So for this reason i have created batch file `PREPROD_BACKUP.bat` which contains data:
@echo off
setlocal EnableDelayedExpansion
expdp SYSTEM/Leosoft@XE PARFILE=export_dump.par
The export_dump.par file contains information:
DIRECTORY=preprod_cron_jobs
DUMPFILE=ratormonitor_!date:~10,4!!date:~6,2!.!date:~4,2!.dmp
LOGFILE=ratormonitor.log
SCHEMAS=RATOR_MONITORING,RATOR_MONITORING_CONFIGURATION
CONTENT=ALL
When i trying to run the `PREPROD_BACKUP.bat` i am getting error as `ORA-39001:invalid argument value`,`ORA-39000 bad dump file specification`,ORA-39087:directory name ratormonitor_!date is invalid. I am trying to create dump file with current datetimestamp attached to the file so the dump file name should look like this `ratormonitor_2015.02.03.37.029062831` but getting an error.