Re: DataPump question
Date: Fri, 29 Aug 2008 09:57:33 -0700 (PDT)
Message-ID: <8c3d6721-db4d-44bf-bbed-6005cd2b9e36@f63g2000hsf.googlegroups.com>
On Aug 29, 9:39 am, mak..._at_gmail.com wrote:
> Thanks Steve.
>
> > 1 is possible, but while doing this with datapump in parallel on a
> > fairly large (700GB) 16 partition table we ran into an "enqueue TM
> > contention" event that Oracle support is still chewing on (10.2.0.3 on
> > x86-64). Effectively, it limited us to loading only one partition at
> > a time. Something to watch out for...
>
> Steve, so from your reply , by design, It's possible to run multiple
> Datapump import jobs in parallel for mutiple partitions [ one impdp
> job per one partition ] but due to some bug you are not able to run
> this... Did I get this right?
Yes, that's what we found. We still have an SR open on it, but we ended up not using DP and just insert as selects from the source table. Received on Fri Aug 29 2008 - 11:57:33 CDT