OraFAQ Forum: Server Utilities » How can i get the total time when using export a table(2 Merged)

Home » RDBMS Server » Server Utilities » How can i get the total time when using export a table(2 Merged) (11.1.0.7 windows)

Tue, 12 July 2011 20:32

andy huang
Messages: 485
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)

Tue, 12 July 2011 20:45

BlackSwan
Messages: 20245
Registered: January 2009

Senior Member

exp userid=test/test file=d:\test.dmp tables=(tb_test) LOG=test.log

the LOG file will contain elapsed time

Tue, 12 July 2011 21:10

andy huang
Messages: 485
Registered: July 2011

Senior Member

Hi,
I have get any elapsed time in the test.log,can you get me a example?

Tue, 12 July 2011 22:08

BlackSwan
Messages: 20245
Registered: January 2009

Senior Member

I was mistaken

Wed, 13 July 2011 08:18

joy_division
Messages: 4288
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: Wed Jun 19 17:19:02 CDT 2013

Total time taken to generate the page: 0.10304 seconds