Re: datapump export incredibly slow

From: Jinwen Zou <zjworacle_at_gmail.com>
Date: Mon, 17 Feb 2014 16:32:23 +1100
Message-ID: <CAOEQsPKti1CGvbCCc1yhUoD_8-wEgUoLW+Lc_HqQiUim92TffQ_at_mail.gmail.com>

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_at_gmail.com> 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_at_gmail.com> 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
>>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 17 2014 - 06:32:23 CET