Oracle Sql*loader Detailed (2) command-line arguments

SQLLDR Tools

The Sql*loader client tool is Sqlldr, enter SQLLDR at the command line of the operating system, followed by no arguments, will display Help information as follows (a simple description of all command-line arguments and their default values), so you don't need to memorize the following parameters, You can query quickly in this way.

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 disc Ards to allow (default all) skip--The number of logical records to skip (default 0) load--Numb Er of logical records to load (default all) errors-number of errors to allow (default) r OWS--number of rows in conventional path bind array or between direct path data saves (Default:conve Ntional path, Direct path All) bindsize--the size of conventional path bind array in bytes (Default 256000) si                      Lent--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--do parallel load (Default FALSE) file--file to allocate extents from skip_unusable_indexes--Disallo W/allow unusable indexes or index partitions (Default FALSE) skip_index_maintenance-does not maintain indexes, mark Affected indexes as unusable (Default FALSE) commit_discontinued--commit loaded rows when load is discontinued (De  Fault 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 Multith  Reading in direct path resumable--the Enable or disable resumable for the current session (Default FALSE) resumable_name --Text StriNg to help identify resumable statement Resumable_timeout--The wait time (in seconds) for resumable (Default 7200) Date  _cache--size (in entries) of the date conversion cache (Default 1000) no_index_errors--abort load on any index errors (Default FALSE)

Two other ways to configure command line arguments

If you have to enter parameters in Sqlldr each time, it must be annoying, so Oracle provides two ways to store common parameters for easy reuse.

The first method is to use the parameter file, write the common parameters in the parameter file, and then specify the parameter file in the Sqlldr with Parfile.

The second method is to write the generic parameters in the options section of the control file and to specify the control file in the Sqlldr by controlling.

I usually use the second method, because this can save the parameter file, more convenient.

So, if the top three places are configured with the same parameter, who has a high priority? SQLLDR command line > Parameter file > Control file.