"Scarab" <yw_at_lucent.com> wrote in message
news:dodsja$46u_at_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.
>
>
Yes, use the array interface in OCI. Experiment with a good size. I think
there is a direct load API also.
Jim
Received on Thu Dec 22 2005 - 10:03:13 CST
