Re: datapump export incredibly slow

From: Jinwen Zou <>
Date: Mon, 17 Feb 2014 16:18:43 +1100
Message-ID: <>

I believe what Raj mean to to say is that: sometimes ACCESS_METHOD=external_table export is better than direct path export for table/partition that has out-of-line stored LOBs or many chained rows, because direct path export will not use more than 1 PX process for a single segment, but external_table export will. Agreed.

Per note 552424.1, the external_table path impdp can't import LOB in parallel in 11g or lower.

On Mon, Feb 17, 2014 at 12:35 PM, rjamya <> wrote:

> And remember, if you are exporting CLOBs, then you are out of luck :)
> Sometimes you will get better performance with ACCESS_METHOD=external_table
> but that you have to try out. Also if flashback_time is not critical for
> you, I'd take it out.
> Raj

Received on Mon Feb 17 2014 - 06:18:43 CET

Original text of this message