Oracle Database Administration: The Essential Refe

Control File Syntax

Detailed instructions to SQL*Loader are contained in a control file, which may contain entries with the following syntax:

[OPTIONS
  [SKIP=n[,]] 
  [LOAD=n[,]]
  [ERRORS=n[,]]
  [ROWS=n[,]]
  [BINDSIZE=n[,]] 
  [SILENT={FEEDBACK | ERRORS | DISCARDS | ALL},]]
  [DIRECT={TRUE | FALSE}[,]] [PARALLEL={TRUE | FALSE}])]
[{UNRECOVERABLE | RECOVERABLE}]
{LOAD [DATA] | CONTINUE_LOAD [DATA]} 
  [{INFILE | INDDN} {filename | *} [CHARACTERSET charsetname] 
[os_options] [READBUFFERS n]
    [{INSERT | APPEND | REPLACE | TRUNCATE}]
    [{BADFILE | BADDN} filename]
    [{DISCARDFILE | DISCARDDN} filename]
    [{DISCARD | DISCARDMAX} n]
    [{CONCATENATE n | CONTINUEIF {[THIS | NEXT] 
[(start [:end]) | LAST} operator {'string' | X'hexstring'}}]
    [PRESERVE BLANKS] 
INTO TABLE [schema.]tablename [INSERT | APPEND | REPLACE | TRUNCATE] 
  [SORTED [INDEXES] (indexname[, ...])] [SINGLEROW]
  [WHEN condition [AND condition ...] [FIELDS delimiter_spec]
  [TRAILING [NULLCOLS]]
  [SKIP n]
  [REENABLE [DISABLED_CONSTRAINTS] [EXCEPTIONS tablename]
(column_name {RECNUM | SYSDATE | CONSTANT value | SEQUENCE 
[( {n | MAX | COUNT} [,incr] ) | column_spec} 
[POSITION ({start | * [+n]} [{: | -}end]})] [datatype_spec] [PIECED] 
  [NULLIF ({fieldname | {start | * [+n]} 
[{: | -}end]}) operator {'string' | X'hexstring' | BLANKS]]
  [DEFAULTIF ({fieldname | {start | * [+n]} 
[{: | -}end]}) operator {'string' | X'hexstring' | BLANKS]]
  [, ...] )

OPTIONS

Allows you to specify runtime parameters in the control file, rather than on the command line. Values specified ...