Re: Export file Generation

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Wed, 20 Jun 2001 11:37:11 +0100
Message-ID: <993033361.29621.0.nnrp-01.c30bdde2@news.demon.co.uk>

You can get the date into an environment variable like this: for /f "tokens=2" %i in ('date /t') do set today=%i

However, %today% is like "20/06/01", so you would need to pipe that through SED or similar (you can find unixtools.zip on the web which gives you awk etc - try http://www.cygwin.com) to change the "/" to "-" and then write a batch file similar to

exp file=%today%.exp etc...

and then call that batch file. Bit of hoop-jumping but it can be done.

"Jimi" <Jimi_at_NOSPAM.com> wrote in message news:qzXX6.8109$qJ4.332260_at_ozemail.com.au...
> Hi,
>
> I would like to know how i can write the files that are generate from a
> direct path export form Oracle 8i to be named from the date and time that
> they are generated? Could someone paste an example or tell me the command
> that I have to incorporate into my .bat files? I am using Oracle 8i on Win
> NT4.0.
>
> Thanks in advance for your answer
>
> Jimi
>
>
Received on Wed Jun 20 2001 - 05:37:11 CDT