Re: Batch insert data into oracle from text file.

Scarab wrote:
> 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.

I wouldn't call OCI the "smart way" unless what I was doing was part of an application being written in C/C++. Why not just use an external table and do the work inside the database.

Likely doing it inside the database will take 1/10th the time of doing it in C.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)