Use of SQLLDR in Oracle

This tool can be used to import data in batches as follows:
Usage: SQLLDR keyword = value [, keyword = value,...]
Valid keywords:
Userid -- Oracle user name/Password
Control -- control File Name
Log -- log File Name
Bad -- incorrect file name
Data -- data File Name
Discard -- discard file name
Discardmax -- number of files that can be discarded (all default values)
Skip -- number of logical records to be skipped (0 by default)
Load -- number of logical records to be loaded (all default values)
Errors -- number of allowed errors (50 by default)
Rows-the number of rows in an array bound to a conventional path or stored in a direct path
(Default: general path 64, all direct paths)
Bindsize -- size of the array bound to the regular path (in bytes) (256000 by default)
Silent -- hide messages (title, feedback, error, discard, partition) during running)
Direct -- use the direct path (default value: FALSE)
Parfile -- parameter file: name of the file containing the parameter description
Parallel -- execute parallel loading (default value: FALSE)
File -- the file from which the partition is to be allocated
Skip_unusable_indexes -- useless indexes or index partitions are not allowed/allowed (FALSE by default)
Skip_index_maintenance -- indexes are not maintained and the affected indexes are marked as useless (FALSE by default)
Commit_discontinued -- submit the rows that have been loaded when loading is interrupted (FALSE by default)
Readsize -- size of the read buffer (1048576 by default)
External_table -- use external tables for loading; NOT_USED, GENERATE_ONLY, EXECUTE (NOT_USED by default)
Columnarrayrows -- number of rows in the direct path column array (5000 by default)
Streamsize -- the size of the direct runoff buffer (in bytes) (256000 by default)
Multithreading -- use multithreading in the direct path
Resumable -- enable or disable the current recoverable SESSION (FALSE by default)
Resumable_name -- a text string that helps identify recoverable statements
Resumable_timeout -- waiting time of RESUMABLE (in seconds) (7200 by default)
Date_cache -- size of the date-converted high-speed cache (calculated by entries) (1000 by default)
Please note: the command line parameters can be specified by the location or keyword.
. The former example is 'sqlload
Scott/tiger foo '; the next example is 'sqlldr control = foo
Userid = scott/tiger '. The specified location parameter must be earlier
However, it cannot be later than the parameter specified by the keyword. For example,
'Sqlldr scott/tiger control = foo logfile = log' is allowed,
'Sqlldr scott/tiger control = foo log' is not allowed, even if
The location of the 'log' parameter is correct.

1 2 Next Page