Descriptions and Default Values of SQL*Loader Parameters
(Doc ID 222769.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Standard Edition - Version 126.96.36.199 to 10.2.0.5 [Release 8.1.7 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 22-SEP-2011***
This document provides a description of the various SQL*Loader command-line parameters used while invoking SQL*Loader, their default values and limits.
Users who need to make use of SQL*Loader utility to load data can refer to the following table for the meaning and default values for the parameter. To have a listing of the command-line parameters, invoke "sqlldr" without any parameters at the command prompt:
Parameters can be specified:
- At the command-line, in any order, optionally separated by commas.
- In the control file using the OPTIONS clause.
- In a separate file specified by the PARFILE parameter.
Parameters specified at the Command-Line override the others.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!