Default: 0 (No records are skipped.)
SKIP parameter specifies the number of logical records from the beginning of the file that should not be loaded. This allows you to continue loads that have been interrupted for some reason, without loading records that have already been processed.
Syntax and Description
SKIP parameter can be used for all conventional loads, for single-table direct path loads, and for multiple-table direct path loads when the same number of records was loaded into each table. It cannot be used for multiple-table direct path loads when a different number of records was loaded into each table.
WHEN clause is also present and the load involves secondary data, then the secondary data is skipped only if the
WHEN clause succeeds for the record in the primary data file.
SKIP parameter cannot be used for external table loads.
The following example skips the first 500 logical records in the data file(s) before proceeding with the load: