Hi,
w.r.t below subject , i had tried this long back - but it wasn't possible
in batch file.
hence forth i am using a workaround - i have built a small program in C
using "Spawnlp" command i am able to run the same with req format.
Regards,
Sushil Kumar Mudlaiar
-----"Manash Baruah "
<oracledba-ezmlmshield-x67384497.[Email address protected] wrote: -----
To: "LazyDBA Discussion" <[Email address protected]
From: "Manash Baruah "
<oracledba-ezmlmshield-x67384497.[Email address protected]
Date: 10/30/2007 12:59PM
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
To Subscribe :
http://www.LazyDBA.com
To unsubscribe:
http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page