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

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 ...

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