I am using the SQL*Loader from 8.1.6.2 version it's taking 15-25 minutes to load
1,600,000 to 2,000,000. i am using Direct load option. i will do this every day.
Good Luck.
rs_arwar_at_hotmail.com (Rauf Sarwar) wrote in message news:<92eeeff0.0303010945.61dcb1ab_at_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 - 20:10:44 CST
