need help in modification with oracle export script
Windows 2003, Oracle 8.1.7
I am trying to write a script for oracle export of whole database which i have to schedule every week. My script is as follows:
# export_full.bat
exp userid=system/manager
file= e:\exportsorcl_%date:~4,2%-%date:~7,2%-%date:~12,2%.dmp
log=e:\exportsmysid_%date:~4,2%-%date:~7,2%-%date:~12,2%.log
full=y
consistent=y
-------------------------------- ******** -------------------------------
I would like to name each dump file by the date on which it is exported. When i try the above script, it creates a simple dump file like expdat.dmp and no logfile is generated.
can someone please help me in correcting this script.