Re: datapump export incredibly slow
- From: Jinwen Zou <zjworacle@xxxxxxxxx>
- To: rjamya@xxxxxxxxx
- Date: Mon, 17 Feb 2014 16:32:23 +1100
Correction, neither export nor import in external_table path can't
unload/upload table with LOB per note 552424.1 in 11g or lower.
On Mon, Feb 17, 2014 at 4:18 PM, Jinwen Zou <zjworacle@xxxxxxxxx> wrote:
> 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 <rjamya@xxxxxxxxx> 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
>>
>
>
Other related posts:
