I would do it by writing a batch file as follows:
export.bat
-------------------------------------------------------------
time /t > exp.log
exp userid=<USERID>/<PW>@<DATABASE> file=<EXP_FILENAME>.dmp
log=exptmp.log tables=(TABLE1,TABLE2,...)
time /t >> exptmp.log
type exptmp.log >> exp.log
del exptmp.log
-------------------------------------------------------------
-Madu
--- In VOUGlist@yahoogroups.com, "wbuker" <whbuker@...> wrote:
>
> Folks,
>
> We are doing daily exports as part of our backup strategy. We are
> working in a windows environment and with Oracle 10.0.2.0.3.
>
> I would like to see a time the export started in the export log file
> and the time the export completed in the same log file.
>
> Here is what I have tried. If I create a log file using notepad, and
> on the command line say: call time /t >> cb190t3.log, it will put the
> time in there fine.
>
> Then if I run my export and tell it to put the results in the same
> log, it will overwrite what I have already entered. So I need some
> help figuring out how to put the time it started, the export log, and
> the time it finished.
>
> Thanks in advance,
>
>
> Bill Buker,
> Enterprise Database Manager
> Swansons Services
> whbuker@...
>