Hi,

The new data pump utilities(expdp and impdp) are supposd to be faster
than old imp and exp utilities in oracle.
But this is not the case on my machine .

exp exported a table in 3 minutes and 30 secs while expdp took more
than 6 mins.

Am I missing something ?

Below are the command used:

$ date ; exp hpbi_owner/hpbi TABLES=big_tab DIRECT=Y COMPRESS=N; date
Fri Mar 30 12:00:26 BST 2007

logs truncated
. . exporting table BIG_TAB 4194304 rows
exported
Export terminated successfully without warnings.
Fri Mar 30 12:03:57 BST 2007

###############################################################333

$ date ; expdp hpbi_owner/hpbi DIRECTORY=data_pump_dir
DUMPFILE=expdp.dmp logfile=expdp.log TABLES=big_tab; date
Fri Mar 30 13:21:13 BST 2007
logs truncated
. . exported "HPBI_OWNER"."BIG_TAB" 1.605 GB
4194304 rows
Master table "HPBI_OWNER"."SYS_EXPORT_TABLE_01" successfully
loaded/unloaded


Regards
Srikrishan Malik
Member of Technical Staff
Persistent Systems Pvt Ltd.

DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the property of Persistent Systems Pvt. Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Pvt. Ltd. does not accept any liability for virus infected mails.

Oracle LazyDBA home page