Re: Loading Records into Oracle Applications

Try using DIRECT PATH option. You may not need to split into different sets.Good luck !

Uday Kumar
ukumar_at_qntm.com
"Opinion is my own"

In article <DHBEn2.I25_at_corsair.daytonoh.attgis.com>, Bruce Murphy <> says:
>
>I am loading 50,000 records into a temporary table. Using the Standard Oracle
>Item Loader (SOIL), I found it is faster to run 5 sets of 10,000 than 1 set of
>50,000 records. In using SOIL I would like to kick off a Unix script within a
>PL/SQL Script to break the 50K records into 10K sets and not have to do this
>in Unix.
>
>Can anyone help me in this matter.
  Received on Wed Nov 01 1995 - 00:00:00 CET