Home » RDBMS Server » Server Utilities » How can i get the total time when using export a table(2 Merged) (11.1.0.7 windows)
How can i get the total time when using export a table(2 Merged) [message #515676] Tue, 12 July 2011 20:32 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
How can i get the total time when using export a table?
for example:
  exp userid=test/test file=d:\test.dmp tables=(tb_test)
  


Re: How can i get the total time when using export a table [message #515679 is a reply to message #515676] Tue, 12 July 2011 20:45 Go to previous messageGo to next message
BlackSwan
Messages: 26759
Registered: January 2009
Location: SoCal
Senior Member
exp userid=test/test file=d:\test.dmp tables=(tb_test) LOG=test.log

the LOG file will contain elapsed time
Re: How can i get the total time when using export a table [message #515682 is a reply to message #515679] Tue, 12 July 2011 21:10 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Hi,
I have get any elapsed time in the test.log,can you get me a example?
Re: How can i get the total time when using export a table [message #515684 is a reply to message #515682] Tue, 12 July 2011 22:08 Go to previous messageGo to next message
BlackSwan
Messages: 26759
Registered: January 2009
Location: SoCal
Senior Member
I was mistaken
Re: How can i get the total time when using export a table(2 Merged) [message #515824 is a reply to message #515676] Wed, 13 July 2011 08:18 Go to previous message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
One way, but possibly not what you wanted:
date
exp
date
Previous Topic: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
Next Topic: SQL Loader handling different date formats in same csv file
Goto Forum:
  


Current Time: Sun Mar 07 22:21:02 CST 2021