Re: Import into a database takes a long time

From: Vinay Joshi <vjoshi_at_pinnacle.co.uk>
Date: Fri, 20 Nov 1998 18:58:43 -0000
Message-ID: <911588540.17491.0.nnrp-09.9e980b2b@news.demon.co.uk>

Try increasing the BUFFER= ... parameter.

Also if you are on V7.3.+ you can use DIRECT option.

Diego Pafumi wrote in message <36558DF1.CD9813E5_at_us.oracle.com>...
>Hi !!!
>First try to delete all the indexes, then you can recreate it.
>Then when you are making the import, commit each row, so it will go faster.
>
>Good luck !!!
>Diego
>
>MTaylo1987 wrote:
>
>> I am trying to do an import of data into a database using the standard
import
>> facility but it seems to take forever. What areas should I look at for
possible
>> performance gains.
>>
>> Ta
>>
>> Mike
>
Received on Fri Nov 20 1998 - 12:58:43 CST