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

Home -> Community -> Usenet -> comp.databases.oracle -> Fast bulk load with API?

Fast bulk load with API?

From: <tachoknight_at_gmail.com>
Date: 23 Mar 2005 13:11:43 -0800
Message-ID: <1111612303.901336.54150@g14g2000cwa.googlegroups.com>


Hi all-

I have a windows service (like a Unix daemon) that loads flat files into an 8.1.7 database. I use Oracle Objects for this, but it takes a very long time, especially with CLOBs to do > 10,000 records. I would use SQL Loader, but because this is a service, I can't spawn SQLLoader to do the load for me.

Is there a SQLLoader-type API that I can call to do the same functionality from within my program?

Thanks,

Ron Received on Wed Mar 23 2005 - 15:11:43 CST

Original text of this message

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