Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> bulk load of data
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 - 04:45:25 CST