Change Advanced Settings for File Import
You can change the following settings that control the import operation:
- Discard maximum: Sets an upper limit on the number of logical records that can be discarded before SQL*Loader terminates. The default is 0.
- Skip count: Allows an interrupted loading to continue by skipping the specified number of logical records. If the First record contains field names checkbox is checked, the skip count automatically defaults to 1 in order to avoid loading the field names row (first row) into a table; if the checkbox is not checked, the default is 0.
- Load count: A limit on the number of logical records to load; the default is no limit, that is, to load all records.
- Max errors: A limit on the number of errors permitted before the load is aborted. The default is to abort a load when the error count exceeds 50, the default value for SQL*Loader.
- Use direct path: This selection is checked by default. If load speed is most important, use direct path load because it is faster than conventional path load. Direct path load is not appropriate in all cases; for more information, see the discussion of conventional and direct path loads in the Oracle Database Utilities manual.
Click OK to continue.
Copyright © 2005, Oracle. All rights reserved.