Re: Import performance.

From: Murali Kazhipurath <murali_at_jps.net>
Date: Wed, 21 Oct 1998 00:00:49 -0700
Message-ID: <362d879c.0@blushng.jps.net>

From what I have understood, DIRECT PATH only works with EXPORT. Here are a few tips:

Drop all Indexes.
Import without indexes using the option indexes=n.
Rebuild indexes using the UNRECOVERABLE option.

Hope this helps.

Murali
murali_at_jps.net

xsun1913_at_my-dejanews.com wrote in message <70ilit$2j0$1_at_nnrp1.dejanews.com>...
>In article <01bdf5d0$fabc77a0$5feaabc3_at_ken-bailey>,
> "Ken Bailey" <Ken.Bailey_at_BLAENAU_GWENT.btinternet.com> wrote:
>> Can anyone give me any guidelines on improving import performace (
>> parameters etc) ?
>>
>>
>
>Use DIRECT PATH when running import; Set buffer to a large number.
>
>
>Xuening Sun
>
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Oct 21 1998 - 02:00:49 CDT