Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Export of CLOB too slow ?!!

Re: Export of CLOB too slow ?!!

From: Prem <premjhere_at_gmail.com>
Date: Thu, 24 Aug 2006 23:36:48 +0530
Message-ID: <56d3d5610608241106x4e7bc540r4a941afc603e9c79@mail.gmail.com>


No Keith . The export runs on the database server itself.

Regards | Jp.
>
> On 8/24/06, Keith Moore <kmoore_at_zephyrus.com> wrote:
> > Are you running it over a (slow) network?
> >
> > CLOBs are exported a row at a time instead of a block at a time,
>> so there is a network round trip for each row. I learned this when
>> I tried to export a database in Japan from the U.S. over a very
slow >> network link. A small database, much smaller than yours would
>>have taken over 20 hours.
> >
> > Keith

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 24 2006 - 13:06:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US