Re: bulk load of data

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 1 Mar 2003 09:45:08 -0800
Message-ID: <92eeeff0.0303010945.61dcb1ab@posting.google.com>

johnleslie_at_madasafish.com (John Leslie) wrote in message news:<4412dd31.0303010245.1b2bd4c2_at_posting.google.com>...
> 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

IMO, Sqlloader is your best option. Check out Sqlldr command line reference and usage, specifically DIRECT=TRUE switch, at http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76955/ch06.htm#496

Regards
/Rauf Sarwar Received on Sat Mar 01 2003 - 11:45:08 CST