Re: bulk load of data

Hi John
I read a good article on sql*loader vs. external tables on asktom.com, heres the link:

http://asktom.oracle.com/pls/ask/f?p=4950:8:53531320491742419::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1615330671789,

It gives some examples and opinions on both. My opinion would be that if this is a one-time load of data, sql*loader might be the way to go.

hth
John

John Leslie wrote:

> Age old question I guess, but looking for the up to date answer.
>
> We have requirement to process up to 500,000 records of data currently
> held in a text file.
>
> Currently we process these through external C procedures and only
> totals are loaded into the database, Now we have a functional
> requirement which probably means we need to load all the records into
> a database table.
>
> Is sqlloader still the quickest option?
>
> What other options are there? We know that utl_file is too slow.
> External tables?
>
> Platform is 8.1.7 on AIX moving soon to 9i release 2
>
> If there any up to date documents or discussion threads you can point
> me at please do so.
>
> John
Received on Sat Mar 01 2003 - 10:57:37 CST