Little more if you want. It works for me
exp usr/[Email Address Removed] owner=usr grants=y compress=y
Regards
Aijaz
-----Original Message-----
From: sushil_mudaliar [mailto:oracledba-ezmlmshield-x52376738.[Email address protected]
Sent: Tuesday, October 30, 2007 10:46 AM
To: LazyDBA Discussion
Subject: Re: Scheduled export in windows...
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
---------------------------------------------------------------------
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
DISCLAIMER:
Notice : This e-mail and any attachments may contain information which is confidential to the addressee and may also be privileged. If you are not the intended recipient of this e-mail, you may not copy, forward, disclose or otherwise use it in any way whatsoever. If you have received this e-mail by mistake, please e-mail the sender by replying to this message, and deleting the original and any printout thereof.
Oracle LazyDBA home page