O'Reilly logo

Oracle Database Administration: The Essential Refe by Brian Laskey, David C. Kreines

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Command-Line Syntax

SQL*Loader may be invoked from a host system command-line prompt or from a batch script, using the following syntax:

sqlload [USERID=username/password[@hostname]] 
[,BAD=badfile] [,BINDSIZE=bindsize] 
[,CONTROL=controlfile] [,DATA=datafile] 
[,DIRECT={TRUE|FALSE}] [,DISCARD=discard_count] 
[,DISCARDMAX=max_discard_count] [,ERRORS=max_error_count] [,FILE=filename] 
[,LOAD=max_record_count] [,LOG=logfile] 
[,PARFILE=parfile] [,PARALLEL=[TRUE |
FALSE}]  [,ROWS=rows_per_commit] 
[,SILENT=({[[HEADER][,FEEDBACK][,ERRORS][,DISCARDS]
[,PARTITIONS]] | ALL)}] [SKIP=skip_count]  
[,SKIP_UNUSABLE_INDEXES={TRUE | FALSE}]  
[,SKIP_INDEX_MAINTENANCE={TRUE | FALSE}]

Tip

Note that the actual name of the SQL*Loader executable may vary from platform to platform, and from release to release. For example, the executable name for SQL*Loader for Windows 95 is sqlldr73.exe, and is therefore entered on the command line as sqlldr73.

BAD

Specifies the name of a file to store records that cause errors during insert or are improperly formatted. If a badfile is not specified, the name of the control file is used by default, along with the .bad extension. This file has the same format as the input datafile, so it can be loaded by the same control file after corrections are made.

BINDSIZE

Specifies the maximum size in bytes of the bind array. The default size is operating system dependent.

CONTROL

Specifies the name of the file that describes how to load data. If the file extension or file type is not specified, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required