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

Home -> Community -> Usenet -> c.d.o.server -> Re: Import into a database takes a long time

Re: Import into a database takes a long time

From: RP Data Solutions <rpdata_at_cyberus.ca>
Date: Sun, 22 Nov 1998 18:45:24 GMT
Message-ID: <36585b0d.1120379220@news.cyberus.ca>


direct import???? And what version would this be available on??? "Vinay Joshi" <vjoshi_at_pinnacle.co.uk> wrote:

>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 Sun Nov 22 1998 - 12:45:24 CST

Original text of this message

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