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

This article mainly explains "how to use SQLLDR grammar". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn how to use SQLLDR grammar.

1. SQLLDR grammar

Grammar

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

Valid keyword

1. Userid-- ORACLE username / password

2. Control-- Control file name

3. Log-- log file name

4. Bad-- error file name

5. Data-- data file name

6. Discard-- obsolete file name

7. Discardmax-the number of files allowed to be discarded (default for all)

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

9. Load-the number of logical records to load (all default)

10. Errors-the number of errors allowed (default 50)

11. Rows-- number of rows in the regular path binding array or between data saved by the direct path (default: regular path 64, all direct paths) bindsize-- size of the regular path binding array in bytes (default 256000)

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

13. Direct-use direct path (default FALSE)

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

15. Parallel-performs parallel loading (default FALSE)

16. File-- A file to allocate extents from the following objects

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

18. Skip_index_maintenance-the index is not maintained and the affected index is marked as useless (default FALSE)

19. Commit_discontinued-commit rows that were loaded when the load was interrupted (default FALSE)

20. Readsize-the size of the read buffer (default is 1048576)

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

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

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

24. Multithreading-using multithreading in a direct path

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

26. Resumable_name-- A text string that helps identify recoverable statements

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

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

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

30. Partition_memory-the direct path partition memory limit (kb) to start the overflow (default 0)

31. Table-- tables for fast mode loading

32. Date_format-date format for Quick Mode loading

33. Timestamp_format-- timestamp format for fast mode loading

34. Terminated_by-- terminated by characters for quick mode loading

35. Enclosed_by-enclosed by characters for fast mode loading

36. Optionally_enclosed_by-- (optional) is enclosed by characters for fast mode loading

37. Characterset-- character set for fast mode loading

38. Degree_of_parallelism-parallelism for fast schema loading and external table loading

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

40. Csv-csv format data file for fast mode loading

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

42. Field_names-- the setting of the first record field name of the data file for fast mode loading

43. Dnfs_enable-enables or disables the option for the input data file Direct NFS (dNFS) (default FALSE)

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

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

46. Help-displays help messages (default FALSE)

47, empty_lobs_are_null-- set blank LOB to null (default FALSE)

48, defaults-direct path default load; EVALUATE_ONCE, EVALUATE_EVERY_ROW, IGNORE, IGNORE_UNSUPPORTED_EVALUATE_ONCE, IGNORE_UNSUPPORTED_EVALUATE_EVERY_ROW

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

2. Sample

CTL:LDR_TEST.CTL

LOAD DATA

INFILE *

INTO TABLE BONUS

FIELDS TERMINATED BY ","

(ENAME, JOB, SAL)

BEGINDATA

SMITH,CLEAK,3904

ALLEN,SALESMAN,2891

WARD,SALESMAN,3128

KING,PRESIDENT,2523

Import command

SOLLDR SCOTT/TIGER CONTROL=LDR_TEST.CTL

Check

Select * from scott.BONUS

At this point, I believe you have a deeper understanding of "how to use SQLLDR grammar". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.