Create a .bat/.cmd file like so:
@echo off
for /f "tokens=2-4 delims=/ " %%a in ('date /t') do set EXP_DATE=%%c-%%a-%%b
set EXP_DIR=E:\Dumps
set EXP_PARFILE=%EXP_DIR%\exp_%EXP_DATE%.par
set PASSWORD=password
echo [Email Address Removed] <mailto:[Email Address Removed] >%EXP_PARFILE%
echo file=%EXP_DIR%\exp_%EXP_DATE%.dmp >>%EXP_PARFILE%
echo log=%EXP_DIR%\exp_%EXP_DATE%.log >>%EXP_PARFILE%
echo tables=(test) >>%EXP_PARFILE%
echo consistent=y >>%EXP_PARFILE%
echo statistics=none >>%EXP_PARFILE%
echo %PASSWORD% | D:\oracle\ora92\bin\EXP.EXE parfile=%EXP_PARFILE%
Todd Pepling
[Email address protected]
724-766-3492
________________________________
From: Manash Baruah [mailto:oracledba-ezmlmshield-x67384497.[Email address protected]
Sent: Tue 10/30/2007 3:29
To: LazyDBA Discussion
Subject: Scheduled export in windows...
Hi All,
I need to run export utility (EXP) every day in windows to export a
particular table. I have scheduled the job in windows job scheduler
which is working fine. But the problem is, it overwrites the existing
dump file created the previous day. To avoid this I wanted to create the
dump file suffixed with the date it is created and used the following
string in the Run parameter to be provided in the job:
D:\oracle\ora92\bin\EXP.EXE Username/[Email Address Removed] log=E:\Dumps\exp_%DATE%.log tables=(test)
consistent=y statistics=none
But, it created a dump file with the name "exp_%DATE%.dmp" and not with
the name exp_30-10-07.dmp or something like that. I have tried the
following:
exp_%DATE%.dmp
exp_%date%.dmp
exp_%SYSDATE%.dmp
exp_%TODAY%.dmp
etc...
Could anybody provide a solution please...
Thanks & Regards,
Manash Pratim Baruah | Collaboration Platform LCS-E-commerce| DBA Team|
Tech Mahindra Ltd.|
Sharda Center, 6th Floor Annex Building, Pune-4
( Office: 91-20-66018100 | Extn: 8028 |
Email: manashb <mailto:[Email address protected] @techmahindra.com
www.techmahindra.com <http://www.techmahindra.com/>
============================================================================================================================
Disclaimer:
This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.
============================================================================================================================
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page