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: Diego Pafumi <dpafumi_at_us.oracle.com>
Date: Fri, 20 Nov 1998 07:42:41 -0800
Message-ID: <36558DF1.CD9813E5@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 - 09:42:41 CST












Original text of this message













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