This content has been marked as final. Show 3 replies
any specific reason for using exp/imp inplace of datapump, try with expdp/impdp1 person found this helpful
Since both the source and target Oracle versions are 10 or greater, it should be faster to use data pump expdp/impdp. You should try parallel= max of 2 times the number of CPUs you want to use for data movement. Make sure you specify the same or more dump files in your expdp command, or wildcard them.
I haven't used exp/imp for quite some time, so I can't help much there.
Pl post the source and target database versions. What is your definition of "slow" ? Rule-of-thumb is that imp takes twice as long as exp.