Change Advanced Settings for File Import
Changes to advanced settings are remembered and applied to the next import operation.
You can change the following settings that control the import operation performed by SQL*Loader:
- 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.
- Rows to scan: The number of rows to scan in order to detect the data type of each attribute. The default value is 1000. If this number is larger than the total number of rows in the data set, scan to the end of the file.
- 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 © 2006, 2008, Oracle. All rights
reserved.