Search the web
Sign In
New User? Sign Up
VOUGlist · Virginia Oracle User's Group
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Dates in export log files   Message List  
Reply | Forward Message #921 of 923 |
Re: Dates in export log files

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@...
>





Wed Apr 2, 2008 1:28 pm

mk_upadhya
Offline Offline
Send Email Send Email

Forward
Message #921 of 923 |
Expand Messages Author Sort by Date

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...
wbuker
Offline Send Email
Apr 1, 2008
3:06 pm

Bill - I don't work on windows much so I am not familiar with the commands, but how about the following steps. 1. Capture the start time in a file -...
Bill Zakrzewski
bill@...
Send Email
Apr 1, 2008
5:33 pm

Echo your start and end time to a different log, then append that log to the exp log when exp is done -- Mark C. Stock enQuery ... From: wbuker To:...
Mark C. Stock
mcstock@...
Send Email
Apr 1, 2008
5:34 pm

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...
Madu Upadhya
mk_upadhya
Offline Send Email
Apr 2, 2008
1:49 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help