Folks 1 more issue There exist 2 Target partitions each of Size 400 GB in which the respective 700 GB Table needs to be exported using Datapump. Additionally a High Value of PARALLEL parameter is preferred to Speed up the 700 GB Export. What Value of PARALLEL is Advisable for an 8 CPU machine connected to an EMC Storage Box? Are the following parameters & Syntax Advisable? If so, will it restrict the PARALLEL parameter specification to a MAX value of 2 only? DUMPFILE=/Partition1:Tbl_Part%U.dmp, /Partition2:Tbl_Part%U.dmp FILESIZE=350G PARALLEL=8 Can /Partition1 & /Partition2 be explicitly Specified? I am unable to follow the meaning of the word "directory_object" Is the Directory Object an Environment Variable which needs to be set on the O.S.? Cheers ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of VIVEK_SHARMA Sent: Wednesday, January 24, 2007 6:16 PM To: oracle-l@xxxxxxxxxxxxx Subject: Best Practises/parameters for speeding Datapump Folks Using Datapump need to export & import a 700 GB Table having a LONG Column (containing JPEGs). Any Rough Estimate on Time needed for the same? What best practices / parameters are Advisable to speed up the same? Any Links will help. Config:- Oracle 10gR2 Solaris 10 SunFire - 8 CPUs RAM 32 GB Cheers **************** 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***