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 -> Batch insert data into oracle from text file.

Batch insert data into oracle from text file.

From: Scarab <yw_at_lucent.com>
Date: Thu, 22 Dec 2005 17:45:27 +0800
Message-ID: <dodsja$46u@netnews.net.lucent.com> 





Hi,


I have some files contains the rows of a table, and I can parse the files
and get the values of each collumn for the table, and my task is import the
data into the table. I want to write an application to do this.
What is the most smart way? Can OCI APIs do batch commit?



Because I have about 3G files to import every day, so performance is greatly
valued.



Thanks.
Received on Thu Dec 22 2005 - 03:45:27 CST












Original text of this message













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