No. You are not missing anything. Actually You will not get benefit of
expdp / impdp if you are exporting one or two tables. As expdp / impdp
takes more time to start than exp/imp utilities. It will take less time
when you will do large export and import.
Regards,
Rajendra Prakash
-----Original Message-----
From: Srikrishan Malik
[mailto:oracledba-ezmlmshield-x75060262.[Email address protected]
Sent: Friday, March 30, 2007 6:30 PM
To: LazyDBA Discussion
Subject: expdp and empdp in 10g
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.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
Oracle LazyDBA home page