SQL LOader script

[jmodic]

use a sequence and call nextval

Or use SQL*Loader's own SEQUENCE generator (it might be faster than calling database's sequence NEXTVAL).
http://download-west.oracle.com/docs...06.htm#1008321