Default: All records are loaded.
Purpose
The LOAD parameter specifies the number of records to be loaded.
Syntax and Description
LOAD=n
If you want to test that all parameters you have specified for the load are set correctly, you can use the LOAD parameter to specify a limited number of records rather than loading all records. No error occurs if fewer than the maximum number of records are found.
Restrictions
None
Example
The following example specifies that a maximum of 10 records be loaded:
> sqlldr hr TABLE=employees LOAD=10
For external tables method loads (the default load method for express mode), only successfully loaded records are counted toward the total. So if there are 15 records in the file and records 2 and 4 are bad, then the following records are loaded into the table, for a total of 10 records - 1, 3, 5, 6, 7, 8, 9, 10, 11, and 12.
For conventional and direct path loads, both successful and unsuccessful load attempts are counted toward the total. So if there are 15 records in the file and records 2 and 4 are bad, then only the following 8 records are actually loaded into the table - 1, 3, 5, 6, 7, 8, 9, and 10.