Re: Fast bulk load with API?
From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Wed, 23 Mar 2005 17:52:06 -0800
Message-ID: <85ednTRbBJfEgN_fRVn-jw_at_comcast.com>
Date: Wed, 23 Mar 2005 17:52:06 -0800
Message-ID: <85ednTRbBJfEgN_fRVn-jw_at_comcast.com>
<tachoknight_at_gmail.com> wrote in message
news: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,
>
> Ron
>
Are you using bind variables in your program? (and leaving the cursors open) If not that is why performance sucks. Jim Received on Thu Mar 24 2005 - 02:52:06 CET