Hi Manash,
Instead of calling the command directly, why don't you call a batch file
which contains the command indeed?
Suresh
-----Original Message-----
From: Manash Baruah
[mailto:oracledba-ezmlmshield-x67040485.[Email address protected]
Sent: Tuesday, October 30, 2007 3:37 PM
To: LazyDBA Discussion
Subject: RE: Scheduled export in windows...
Thanks a lot Praveen, Aijaz, Sushil for your response
Its working... but only from the command prompt. When I pass it to the
Run parameter of the Windows job scheduler as follows:
D:\oracle\ora92\bin\EXP.EXE Username/[Email Address Removed] tables=(test) consistent=y statistics=none
It gives the following error:
EXP-00028: failed to open E:\Dumps\exp_%date:~10.DMP for write
I am trying to find a way around...
Regards,
Manash Pratim Baruah | Collaboration Platform LCS-E-commerce| DBA Team|
Tech Mahindra Ltd.|
Sharda Center, 6th Floor Annex Building, Pune-4
www.techmahindra.com
-----Original Message-----
From: RAMASWAMY Praveen Kumar
[mailto:oracledba-ezmlmshield-x96435001.[Email address protected]
Sent: Tuesday, October 30, 2007 1:36 PM
To: LazyDBA Discussion
Subject: RE: Scheduled export in windows...
Manash
Try this.
copy c:\temp\sql.txt
c:\temp\%date:~10,4%_%date:~4,2%_%date:~7,2%_%date:~0,3%.txt.
And schedule this. This will not oeverwrite the dmp file rather I will
create a new logfile everyday
Truly,
Praveen
-----Original Message-----
From: sushil_mudaliar [mailto:oracledba-ezmlmshield-x52376738.[Email
address protected]
Sent: Tuesday, October 30, 2007 1:16 PM
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.techmahind
ra.com/Disclaimer.html</a>
externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.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
Confidentiality Statement:
This message is intended only for the individual or entity to which it
is addressed. It may contain privileged, confidential information which
is exempt from disclosure under applicable laws. If you are not the
intended recipient, please note that you are strictly prohibited from
disseminating or distributing this information (other than to the
intended recipient) or copying this information. If you have received
this communication in error, please notify us immediately by return
email.
-----------------------------
---------------------------------------------------------------------
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:
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.techmahind
ra.com/Disclaimer.html</a> externally and <a
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahind
ra.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