-
Could someone tell me how I can display the current time of the database????
thanks
-
What's wrong with SYSDATE?
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
select to_char(sysdate, 'dd-mon-yyyy, hh24:mi:ss') as date_time from sys.dual
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
Thanks so much for both reply
I have another question.
I have an full export run everynight and I want to capture to the log the time to see how long it take to export the full database.
For example
EXP SYSTEM/MANAGER FILE=EXP_FULL.DMP LOG=EXP_FULL.LOG FULL=Y
Please show me how to capture the time.
-
create am OS batch file/unix script to start your export.
put the os date/time command at the begining.
start the export
finish with another date/time command
redirect output to a file.
study the output file.
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
Could you please give me more detail about
"put the os date/time command at the begining" Etc
Thanks
-
Some [people] succeed by what they know; some by what they do; and a few by what they are.
VenDe ChukPeen Zuri
Someone who quotes himself as a DBA and posts simple question in forums is a big idiot to me . I donot care what others think
-
What OS u are using?
If any unix then some idea for u:
DB=sodom
cat tpl_$DB.par | sed -e s/#DMP#/d_${DB}_$(date +%m%d%Y)/g > exp_$DB.par
exp parfile=exp_sodom.par
about current date/tine in filename.
-
Questions
1.What is your OS
2.Do you know any commands or the workings of your OS ?
If not.. contact you OS manager for actual syntax.
In unix your script would look something like this :
date
EXP SYSTEM/MANAGER FILE=EXP_FULL.DMP LOG=EXP_FULL.LOG FULL=Y
date
The script would be a cron job to run at a certain time and output redirected to a file,
In windows you would use schedular to run a batch file at a certain time.
If you haven't got a clue what I'm talking about, I suggest you contact your OS administrator. And get his/her advice.
Once you have eliminated all of the impossible,
whatever remains however improbable,
must be true.
-
I am on Wndows 2000 server
Please advise
Shureshy,
I know how to use scheduler, but I want to capture the time of how long this export will run instead of looking into the property of the file.( I like to have this info capture to the log file)
thanks
[Edited by ashley75 on 07-03-2002 at 11:00 AM]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|