[Oracle] SQL * Loader detailed tutorial (2)-command line parameters

[Oracle] SQL * Loader detailed tutorial (2)-input sqlldr in command line parameters without any parameters, the simple description of all command line parameters and their default values are displayed. (You can also use this method to quickly query some parameters if you forget them ):

[plain] 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  (Default 256000)      silent -- suppress messages during run (header,feedback,errors,discards,partitions)      direct -- use direct path                      (Default FALSE)     parfile -- parameter file: name of file that contains parameter specifications    parallel -- do parallel load                     (Default FALSE)        file -- file to allocate extents from        skip_unusable_indexes -- disallow/allow unusable indexes or index partitions  (Default FALSE)  skip_index_maintenance -- do not maintain indexes, mark affected indexes as unusable  (Default FALSE)  commit_discontinued -- commit loaded rows when load is discontinued  (Default FALSE)    readsize -- size of read buffer                  (Default 1048576)  external_table -- use external table for load; NOT_USED, GENERATE_ONLY, EXECUTE  (Default NOT_USED)  columnarrayrows -- number of rows for direct path column array  (Default 5000)  streamsize -- size of direct path stream buffer in bytes  (Default 256000)  multithreading -- use multithreading in direct path     resumable -- enable or disable resumable for current session  (Default FALSE)  resumable_name -- text string to help identify resumable statement  resumable_timeout -- wait time (in seconds) for RESUMABLE  (Default 7200)  date_cache -- size (in entries) of date conversion cache  (Default 1000)  no_index_errors -- abort load on any index errors  (Default FALSE)  

 

To avoid entering the same parameter in the command line every time, you can also use the parameter file or write the parameter in the OPTIONS clause of the control file. Of course, the command line parameter has the highest priority, it can overwrite the parameter configurations in the parameter file and control file. SQL * Loader is imported to the local database by default, but it also supports importing to the remote database. You only need to add "@ remote database connection string" after username, as shown below:

> sqlldr CONTROL=ulcase1.ctlUsername: scott@inst1Password: password

 

The following is a detailed explanation of the command line parameters: BAD-BAD file name (. bad) CONTROL-CONTROL file name (. ctl) DATA-DATA file name (. dat), equivalent to the INFILE in the control file. You can specify multiple data files. DIRECT-true indicates DIRECT path loading, and false indicates loading DISCARD-lost file names using the traditional path (. dsc) DISCARDMAC-the maximum number of records allowed to be lost. If this number is exceeded, the loading of ERRORS will be stopped-the maximum number of records to be previewed will fail to be inserted. If this number is exceeded, will Stop loading EXTERNAL_TABLE-whether to use the External table loading mode FILE-this parameter is only used for parallel loading of direct paths-the maximum number of records allowed to be loaded LOG-log file name (. log) PARALLEL-true or false, whether to use the PARALLEL mode PARFILE-parameter file name (. par) ROWS-specify how many records are submitted when the number of records reaches-specify to ignore the first number of records SKIP_INDEX_MAINTENANCE-true indicates that the index is not maintained during direct path loading, resulting in the index status changing to unusable