SQL*Loader inserts as many records as are specified by the
LOAD statement. The
SKIP parameter is not permitted in this situation.
SQL*Loader is optimized for this case. Whenever SQL*Loader detects that only generated specifications are used, it ignores any specified data file—no read I/O is performed.
In addition, no memory is required for a bind array. If there are any
WHEN clauses in the control file, then SQL*Loader assumes that data evaluation is necessary, and input records are read.