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.

============================================================================================================================

Oracle LazyDBA home page