Fast bulk load with API?
From: <tachoknight_at_gmail.com>
Date: 23 Mar 2005 13:11:43 -0800
Message-ID: <1111612303.901336.54150_at_g14g2000cwa.googlegroups.com>
Hi all-
Date: 23 Mar 2005 13:11:43 -0800
Message-ID: <1111612303.901336.54150_at_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,