Message-ID: <4FA57AE7.20309@interia.pl>
Date: Sat, 05 May 2012 21:09:27 +0200
From: GG <grzegorzof@interia.pl>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
To: maureen.english@alaska.edu
CC: "oracle-l@freelists.org" <oracle-l@freelists.org>
Subject: Re: speeding up expdp
References: <CAAzCTjEZXGrRcagXdNQTrnDyf2Sf_3rUqDnKigX-NqZuuR_wBw@mail.gmail.com> <4814386347E41145AAE79139EAA398981CC0B5180C@ws03-exch07.iconos.be> <CAAzCTjEGS88q3cScr8t7-KNaMTs_LgoZngU2HnbH8MRAW0nypg@mail.gmail.com>
In-Reply-To: <CAAzCTjEGS88q3cScr8t7-KNaMTs_LgoZngU2HnbH8MRAW0nypg@mail.gmail.com>
Content-type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: grzegorzof@interia.pl

W dniu 2012-05-05 19:52, Maureen English pisze:
>
> I do believe that both of these tables have a lob column.  Does that
> mean I just have
> to live with the 7.5 hours?  At least the import to the new machine
> only takes about
> 1.5 hours.
>
> I'm also excluding indexes/constraints for the export and import.
>
> I'm pretty sure I read through the checklist document, but not the
> other 2.  I'll
> check them out.
>
Hi,
lobs are pain and there is no magic way to make them performance friendly .
You have to be creative in such situations .
How about moving them to separated tablespace via online redefinition
and then transport that tablespace and 'plug in' .

Secondly, You have to know Your system limits , maybe thats the case why 
parallel did not help.
Regards
GregG

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