sqlldr 关键词详解

节录重要部分 详情请见：

http://camden-www.rutgers.edu/help/Documentation/Oracle/server.815/a67792/ch06.htm

sqlldr ... Valid Keywords:
        userid -- Oracle username/password       control -- Control file name            log -- Log file name            bad -- Bad file name          data -- Data file name       discard -- Discard file name    discardmax -- Number of discards to allow                 (Default all)          skip -- Number of logical records to skip                 (Default 0)          load -- Number of logical records to load                 (Default all)        errors -- Number of errors to allow                 (Default 50)          rows -- Number of rows in conventional path bind array                 or between direct path data saves                 (Default: Conventional Path 64, Direct path all)      bindsize -- Size of conventional path bind array in bytes                 (System-dependent default)        silent -- Suppress messages during run                  (header, feedback, errors, discards, partitions, all)        direct -- Use direct path                 (Default FALSE)       parfile -- Parameter file: name of file that contains                  parameter specifications      parallel -- Perform parallel load                 (Default FALSE)      readsize -- Size (in bytes) of the read buffer          file -- File to allocate extents from 

Using Command-Line Keywords

Keywords are optionally separated by commas. They are entered in any order. Keywords are followed by valid arguments.

For example:

SQLLDR CONTROL=foo.ctl, LOG=bar.log, BAD=baz.bad, DATA=etc.dat     USERID=scott/tiger, ERRORS=999, LOAD=2000, DISCARD=toss.dis,    DISCARDMAX=5