My Oracle Support Banner

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 8.1.7.4 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***

Purpose

This document provides a description of the various SQL*Loader command-line parameters used while invoking SQL*Loader, their default values and limits.

Scope

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:

#> sqlldr

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.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.