Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to use the SQLLDR command in SQL. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

SQL*Loader is an operating tool under the command line, and the corresponding operating system command is SQLLDR

Syntax: SQLLDR keyword=value [, keyword=value,...]

Options:

Userid-- ORACLE username / password

Control-- Control file name

Log-- Log file name

Bad-- wrong file name

Data-data file name

Discard-obsolete file name

Discardmax-the number of files allowed to be obsolete (default for all)

Skip-number of logical records to skip (default 0)

Load-number of logical records to load (default for all)

Errors-number of errors allowed (default 50)

Rows-the number of rows in the regular path binding array or between direct paths saving data (default: regular path 64, all direct paths)

Bindsize-the size of the regular path binding array (in bytes) (default 256000)

Silent-Hidden messages during operation (title, feedback, error, obsolescence, partition)

Direct-use direct path (default FALSE)

Parfile-Parameter file: the name of the file containing the description of the parameter

Parallel-performs parallel loading (default FALSE)

File-A file to allocate extents from the following objects

Skip_unusable_indexes-useless indexes or index partitions are not allowed / allowed (default FALSE)

Skip_index_maintenance-No indexes are maintained and affected indexes are marked as useless (default FALSE)

Commit_discontinued-commit rows that were loaded when loading was interrupted (default FALSE)

Readsize-the size of the read buffer (default 1048576)

External_table-load using external tables; NOT_USED, GENERATE_ONLY, EXECUTE

Columnarrayrows-the number of rows in the direct path column array (default 5000)

Streamsize-size of the direct path stream buffer (in bytes) (default 256000)

Multithreading-using multithreading in a direct path

Resumable-enables or disables recoverability for the current session (default FALSE)

Resumable_name-text strings that help identify recoverable statements

Resumable_timeout-wait time for RESUMABLE (in seconds) (default 7200)

Date_cache-size of the date conversion cache (in entries) (default 1000)

No_index_errors-aborts loading if any index error occurs (default FALSE)

Partition_memory-Direct path partition memory limit (kb) to start overflow (default 0)

Table-tables for fast mode loading

Date_format-date format for Quick Mode loading

Timestamp_format-A timestamp format for fast mode loading

Terminated_by-terminated by characters used for quick mode loading

Enclosed_by-enclosed by characters for fast mode loading

Optionally_enclosed_by-(optional) is enclosed by characters for quick mode loading

Characterset-character set for fast mode loading

Degree_of_parallelism-parallelism for fast schema loading and external table loading

Trim-intercept types for fast schema loading and external table loading

Csv-csv format data file for fast mode loading

Nullif-A table-level nullif clause for fast mode loading

Field_names-the first record field name setting of the data file for quick mode loading

Dnfs_enable-the option to enable or disable the input data file Direct NFS (dNFS) (default FALSE)

Dnfs_readbuffers-Direct NFS (dNFS) number of read buffers (default 4)

Sdf_prefix-prefix to append to the beginning of each LOB file and auxiliary data file

Help-displays help messages (default FALSE)

Empty_lobs_are_null-set blank LOB to null (default FALSE)

Defaults-Direct path default load

EVALUATE_ONCE

EVALUATE_EVERY_ROW

IGNORE

IGNORE_UNSUPPORTED_EVALUATE_ONCE

IGNORE_UNSUPPORTED_EVALUATE_EVERY_ROW

Direct_path_lock_wait-wait for table access when currently locked (default FALSE)

This is the end of the article on "how to use SQLLDR commands in SQL". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.