Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Import performance.
Correct, only EXPORT supports DIRECT.
And remember to take a *backup* after recreation of the indexes, unless you want to go through the whole procedure again should you suffer media failure...
MotoX.
Murali Kazhipurath wrote in message <362d879c.0_at_blushng.jps.net>...
>From what I have understood, DIRECT PATH only works with EXPORT. Here are a
>few tips:
>
>1. Drop all Indexes.
>2. Import without indexes using the option indexes=n.
>3. 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 - 07:33:41 CDT