Use of SQLLDR in Oracle

Source: Internet
Author: User
This tool can import data in batches. The usage is as follows: SQLLDRkeywordvalue [, keywordvalue,...] valid Keyword: userid --

This tool can import data in batches. The usage is as follows: SQLLDR keyword = value [, keyword = value,...] valid keyword: userid --

This tool can import data in batches. The usage is 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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.