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: 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)

Tue, 12 July 2011 20:45

BlackSwan
Messages: 26766
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

Tue, 12 July 2011 21:10

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?

Tue, 12 July 2011 22:08

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I was mistaken

Wed, 13 July 2011 08:18

joy_division
Messages: 4963
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: Sat Sep 23 15:39:42 CDT 2023