[Oracle] Sql*loader Detailed Usage Tutorials (2)-Command line arguments

SQLLDR Tools

The Sql*loader client tool is Sqlldr, enter SQLLDR under the command line of the operating system, and then do not take any parameters, and the Help information shown below (a simple description of all command-line arguments and their default values), so you do not need to memorize the following parameters, and when you forget them, You can quickly query this way.

[Plain]View PlainCopyprint?

2. Valid Keywords:
6. UserID-ORACLE Username/password
8. Control--Control file name
10. Log--Log file name
12. Bad-Bad file name
14. Data--Data file name
16. Discard--Discard file name
18. Discardmax--number of discards to allow (Default all)
20. Skip--Number of logical records to skip (Default 0)
22. Load--Number of logical records to load (Default all)
24. Errors--Number of errors to allow (Default 50)
26. Rows-number of rows in conventional path bind array or between direct path data saves
28. (default:conventional path, Direct path All)
30. Bindsize--size of conventional path bind array in bytes (Default 256000)
32. Silent--Suppress messages during run (header,feedback,errors,discards,partitions)
34. Direct-use direct path (Default FALSE)
36. Parfile--Parameter file:name of file that contains parameter specifications
38. Parallel--Do parallel load (Default FALSE)
40. FILE--file to allocate extents from
42. Skip_unusable_indexes--Disallow/allow unusable indexes or index partitions (Default FALSE)
44. Skip_index_maintenance--Do not maintain indexes, mark affected indexes as unusable (Default FALSE)
46. Commit_discontinued--commit loaded rows when load is discontinued (Default FALSE)
48. ReadSize--size of read buffer (Default 1048576)
50. External_table--Use external table for load; not_used, Generate_only, EXECUTE (Default not_used)
52. Columnarrayrows--Number of rows for direct path column array (Default 5000)
54. Streamsize--size of direct path stream buffer in bytes (Default 256000)
56. Multithreading--use multithreading in direct path
58. Resumable-Enable or disable resumable for current session (Default FALSE)
60. Resumable_name--text string to help identify resumable statement
62. Resumable_timeout--wait time (in seconds) for resumable (Default 7200)
64. Date_cache--size (in entries) of date conversion cache (Default 1000)
66. 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 the Sqlldr every time, it's 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 Sqlldr with Parfile.

The second method is to write the general parameters in the options clause of the control file and specify the control file in Sqlldr.

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

And if the same parameter is configured on all three of the above, who has a big priority? Sqlldr command line > Parameters file > Control file.

Import data to a remote database

Sql*loader is imported to the local database by default, but it also supports importing to a remote database, as long as the "@ Remote database connection string" is behind username, as follows:

> Sqlldr control=ulcase1.ctlusername: [Email Protected]password:password

Command line Parameters detailed description

1. Specify file name: control, bad, log, data, discard, parfile

2. Traditional path loading: direct=false (default); Direct path loading: direct=true

3. Maximum allowable errors: errors; Number of records allowed to discard: Discardmax; maximum allowable number of records to load: Load

4. Parameters that can only be used under direct path loading: no_index_errors (default = False, if True indicates that index is not set to unusable during loading); Parallel (false by default, True if parallel loading is enabled); Skip_index_maintenance (False if true means that the maintenance of the index is stopped during the loading process)

5. Rows: Indicates how many rows to commit, default (traditional path load 64, direct path load all)

6. Skip: Omit the most previous record count

[Oracle] Sql*loader Detailed Usage Tutorials (1)-Overview [Oracle] Sql*loader Tutorial (2)-command line parameters [Oracle] sql*loader Detailed tutorial (3)-Control file

[Oracle] Sql*loader Detailed Usage Tutorials (4)-field list

[Oracle] Sql*loader Detailed Usage Tutorials (2)-Command line arguments