Is also works for me ;-)

Regards,

----- Original Message -----
From: "Mir Aijaz A "
<oracledba-ezmlmshield-x17306855.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, October 30, 2007 4:27 PM
Subject: RE: Scheduled export in windows...


> 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] file=E:\Dumps\exp_%DATE%.dmp 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.c
om/Disclaimer.html</a>
>
> externally and <a
>
href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.c
om/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.
>
>
> ---------------------------------------------------------------------
> 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