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 to share photos of your group with the world? 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 #920 of 923 |
Re: Dates in export log files

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

----- Original Message -----
From: wbuker
To: VOUGlist@yahoogroups.com
Sent: Tuesday, April 01, 2008 9:45 AM
Subject: (VOUG) Dates in export log files


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






Tue Apr 1, 2008 5:27 pm

mcstock@...
Send Email Send Email

Forward
Message #920 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