{"id":263,"date":"2011-12-31T15:36:47","date_gmt":"2011-12-31T07:36:47","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=263"},"modified":"2014-01-14T21:08:29","modified_gmt":"2014-01-14T13:08:29","slug":"%e5%af%bc%e5%85%a5%e5%af%bc%e5%87%ba%e5%b7%a5%e5%85%b702-sqlloader%e5%b7%a5%e5%85%b7%e4%b8%8e%e5%a4%96%e9%83%a8%e8%a1%a8","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=263","title":{"rendered":"\u5bfc\u5165\u5bfc\u51fa\u5de5\u517702–SQL*Loader\u5de5\u5177\u4e0e\u5916\u90e8\u8868"},"content":{"rendered":"
SQL*Loader\u5de5\u5177\u4e0e\u5916\u90e8\u8868<\/p>\n
\n
    \n
  1. SQL*Loader:\n
      \n
    1. \u6982\u5ff5:\n
        \n
      1. \u53ef\u4ee5\u5728\u670d\u52a1\u5668\u7aef\u548c\u5ba2\u6237\u7aef\u64cd\u4f5c,\u6570\u636e\u53ef\u4ee5\u5b58\u653e\u5728\u670d\u52a1\u5668\u7aef\u6216\u8005\u5ba2\u6237\u7aef;<\/li>\n
      2. \u53ef\u4ee5\u5bfc\u5165\u56fa\u5b9a\u683c\u5f0f\u7684TXT\u6587\u4ef6\u7684\u6570\u636e;<\/li>\n<\/ol>\n<\/li>\n
      3. INSERT INTO … SELECT …\u7684\u4e24\u79cd\u63d2\u5165\u6570\u636e\u7684\u65b9\u6cd5:\n
          \n
        1. conventional INSERT\u64cd\u4f5c:\u901a\u7528\u7684\u63d2\u5165\u65b9\u6cd5,\u6570\u636e\u5e93\u4f1a\u4f18\u5148\u91cd\u65b0\u5229\u7528HWM(High Water Mark)\u4ee5\u4e0b\u7684\u6570\u636e\u5757,\u7136\u540e\u518d\u4f7f\u7528HWM\u4ee5\u4e0a\u7684\u6570\u636e\u5757,\u4f7f\u5f97\u65b0\u65e7\u6570\u636e\u4ea4\u53c9\u5b58\u653e,\u540c\u65f6\u8fd8\u8981\u7ef4\u62a4\u6570\u636e\u7684\u5b8c\u6574\u6027(\u4e3b\u5916\u952e,CHECK\u7ea6\u675f\u7b49);<\/li>\n
        2. direct-path INSERT\u64cd\u4f5c:\u76f4\u63a5\u8def\u5f84\u63d2\u5165\u65b9\u6cd5,\u6570\u636e\u5e93\u628a\u6570\u636e\u76f4\u63a5\u63d2\u5165\u5230\u9ad8\u6c34\u4f4d\u4e4b\u540e\u7684\u6570\u636e\u5757\u4e2d,\u6570\u636e\u4e0d\u7ecf\u8fc7buffer cache,\u76f4\u63a5\u5199\u5165\u6570\u636e\u6587\u4ef6,\u5ffd\u7565\u6570\u636e\u7684\u5b8c\u6574\u6027,\u4f7f\u5f97\u6027\u80fd\u6700\u5927\u7684\u63d0\u5347;\n
            \n
          1. \u987a\u5e8f\u63d2\u5165\u5206\u533a\/\u975e\u5206\u533a\u8868:\u53ea\u6709\u4e00\u4e2a\u7ebf\u7a0b\u628a\u6570\u636e\u5199\u5230HWM\u4e4b\u540e;<\/li>\n
          2. \u5e76\u884c\u63d2\u5165\u5206\u533a\u8868:\u6bcf\u4e2a\u8fdb\u7a0b\u53ef\u4ee5\u88ab\u5206\u914d\u5230\u4e00\u4e2a\u6216\u8005\u591a\u4e2a\u5206\u533a,\u4f46\u662f\u4e00\u4e2a\u5206\u533a\u6700\u591a\u53ea\u6709\u4e00\u4e2a\u8fdb\u7a0b\u8d1f\u8d23,\u63a8\u8350\u4f7f\u7528\u8ddf\u5206\u533a\u6570\u91cf\u76f8\u540c\u7684\u5e76\u884c\u5ea6;\u6570\u636e\u540c\u6837\u53ea\u5728\u6bcf\u4e2a\u5206\u533a\u7684HWM\u4e4b\u540e\u7684\u6570\u636e\u5757\u5199\u5165;<\/li>\n
          3. \u5e76\u884c\u63d2\u5165\u975e\u5206\u533a\u8868:\u6bcf\u4e2a\u8fdb\u7a0b\u5206\u914d\u4e00\u4e2a\u4e34\u65f6\u7684\u6bb5,\u7136\u540e\u628a\u6240\u6709\u4e34\u65f6\u6bb5\u5408\u5e76;<\/li>\n<\/ol>\n<\/li>\n
          4. SQL*Loader\u7684convention-path load\u65b9\u5f0f\u548cdirect-path load\u65b9\u5f0f\u8ddf\u8fd9\u4e2a\u76f8\u4f3c;<\/li>\n
          5. \u53ef\u4ee5\u901a\u8fc7\u4f7f\u7528\/*+ APPEND *\/\u7684hint,\u6765\u4f7f\u7528\u76f4\u63a5\u5bfc\u5165\u6570\u636e,\u4f8b\u5b50;<\/li>\n
          6. conventional\u65b9\u5f0f\u4f7f\u7528\u4f1a\u4ea7\u751fredo\u65e5\u5fd7,\u800cdirect-path\u65b9\u5f0f\u59cb\u7ec8\u4e0d\u4ea7\u751f\u65e5\u5fd7,\u4e0e\u8868\u672c\u8eab\u662f\u5426\u662fLOGGING\u6a21\u5f0f\u65e0\u5173,\u5982\u679c\u6570\u636e\u5e93\u662fFORCE LOGGING\u6a21\u5f0f,\u5219\u65e0\u8bba\u90a3\u79cd\u65b9\u5f0f\u90fd\u4f1a\u8bb0\u5f55\u65e5\u5fd7<\/span>,\u4f8b\u5b50;<\/li>\n<\/ol>\n<\/li>\n
          7. SQL*Loader\u7684\u4ecb\u7ecd;\n
              \n
            1. Input data files:\u8981\u5bfc\u5165\u7684\u6570\u636e\u6587\u4ef6;\n
                \n
              1. \u4ee5\u6587\u672c\u5f62\u5f0f\u5b58\u5728;<\/li>\n
              2. \u53ef\u4ee5\u6709\u591a\u4e2a\u6570\u636e\u6587\u4ef6;<\/li>\n
              3. \u652f\u6301\u4e09\u79cd\u6570\u636e\u683c\u5f0f:\n
                  \n
                1. Fixed-Record Format:\u6bcf\u4e2a\u5217\u6709\u56fa\u5b9a\u7684\u957f\u5ea6,\u6548\u7387\u9ad8\u5355\u7075\u6d3b\u6027\u5dee,\u5982:\u6570\u636e\u6587\u4ef6\u4e2d\u6bcf11\u4e2a\u5b57\u8282\u662f\u4e00\u4e2a\u5b57\u6bb5infile ‘example.dat’ “fix 11”;<\/li>\n
                2. Variable-Record Format:\u6bcf\u4e2a\u5217\u957f\u5ea6\u4e0d\u56fa\u5b9a,\u5728\u6700\u524d\u9762n\u4f4d\u6765\u8bb0\u5f55\u5b83\u7684\u957f\u5ea6,\u5982:\u524d\u4e09\u4e2a\u5b57\u7b26\u8868\u793a\u8bb0\u5f55\u7684\u957f\u5ea6infile ‘example.dat’ “var 3”;<\/li>\n
                3. Stream-Record Format:\u6d41\u8bb0\u5f55,\u4ee5\u67d0\u4e2a\u7b26\u53f7\u533a\u5206\u5217,\u6700\u5e38\u7528\u7684\u65b9\u5f0f;<\/li>\n<\/ol>\n<\/li>\n
                4. \u8bb0\u5f55\u7684\u79cd\u7c7b:\n
                    \n
                  1. Physical Record:\u5373\u6570\u636e\u6587\u672c\u4e2d\u7684\u4e00\u884c\u8bb0\u5f55;<\/li>\n
                  2. Logical Record:\u5728\u6570\u636e\u5e93\u4e2d\u8868\u7684\u4e00\u884c\u8bb0\u5f55,\u53ef\u4ee5\u5408\u5e76\u51e0\u884c\u7269\u7406\u8bb0\u5f55\u7ec4\u6210\u4e00\u4e2a\u903b\u8f91\u8bb0\u5f55;<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
                  3. Loader control file:\u5bfc\u5165\u6570\u636e\u7684\u63a7\u5236\u6587\u4ef6;\n
                      \n
                    1. \u6307\u5b9a\u5bfc\u5165\u6570\u636e\u7684\u76ee\u5f55;<\/li>\n
                    2. \u6570\u636e\u7684\u683c\u5f0f\u5316;<\/li>\n
                    3. \u914d\u7f6e\u4fe1\u606f:\u5185\u5b58,\u62d2\u7edd\u8bb0\u5f55\u7684\u89c4\u5219,\u5f02\u5e38\u7ec8\u6b62\u540e\u7684\u5904\u7406;<\/li>\n
                    4. \u5982\u4f55\u64cd\u4f5c\u6570\u636e;<\/li>\n
                    5. \u6ce8\u91ca\u4f7f\u7528[–]\u7b26\u53f7;<\/li>\n
                    6. \u4e0d\u80fd\u4f7f\u7528CONSTANT\u548cZONE\u5173\u952e\u5b57;<\/li>\n<\/ol>\n<\/li>\n
                    7. Parameter file:\u53ef\u9009,\u53ef\u4ee5\u628asqlldr\u547d\u4ee4\u540e\u9762\u7684\u53c2\u6570\u4fdd\u5b58\u8d77\u6765,\u53ea\u9700\u8981\u6307\u5b9a\u53c2\u6570\u6587\u4ef6\u5373\u53ef;<\/li>\n
                    8. Discard file:\u53ef\u9009,\u88ab\u629b\u5f03\u7684\u6570\u636e,\u4e0d\u6ee1\u8db3\u8fc7\u6ee4\u5668\u6761\u4ef6\u7684\u8bb0\u5f55;\n
                        \n
                      1. \u53ef\u4ee5\u63a7\u5236\u6253\u5f00\u6216\u8005\u5173\u95ed\u6b64\u529f\u80fd;<\/li>\n
                      2. \u53ef\u4ee5\u5728\u63a7\u5236\u6587\u4ef6\u4e2d\u5b9a\u4e49\u8bb0\u5f55\u9009\u62e9\u7684\u6807\u51c6;<\/li>\n
                      3. \u53ef\u4ee5\u89c4\u5b9a\u5f53discard file\u4e2d\u8bb0\u5f55\u8d85\u8fc7\u4e00\u5b9a\u6570\u91cf\u7684\u8bdd\u5c31\u7ec8\u6b62;<\/li>\n<\/ol>\n<\/li>\n
                      4. Bad file:\u53ef\u9009,\u88ab\u62d2\u7edd\u7684\u6570\u636e;\n
                          \n
                        1. SQL*Loader\u62d2\u7edd\u7684\u6570\u636e,\u6bd4\u5982\u8f93\u5165\u6570\u636e\u7684\u683c\u5f0f\u4e0d\u5bf9;<\/li>\n
                        2. Oracle\u6570\u636e\u5e93\u62d2\u7edd\u7684\u6570\u636e,\u6bd4\u5982\u8fdd\u53cd\u7ea6\u675f\u7684\u8bb0\u5f55;<\/li>\n<\/ol>\n<\/li>\n
                        3. Log file:\u53ef\u9009,\u65e5\u5fd7\u4fe1\u606f,\u5982\u679c\u6ca1\u6709\u6307\u5b9a\u5c31\u4f1a\u751f\u6210\u4ee5.log\u7ed3\u5c3e\u7684\u8ddf\u6570\u636e\u6587\u4ef6\u540c\u540d\u7684\u6587\u4ef6;\n
                            \n
                          1. \u5934\u4fe1\u606f;<\/li>\n
                          2. \u5168\u5c40\u4fe1\u606f;<\/li>\n
                          3. \u8868\u4fe1\u606f;<\/li>\n
                          4. \u6570\u636e\u6587\u4ef6\u4fe1\u606f;<\/li>\n
                          5. \u8868\u52a0\u8f7d\u7684\u4fe1\u606f;<\/li>\n
                          6. \u7edf\u8ba1\u4fe1\u606f;<\/li>\n
                          7. \u9644\u52a0\u4fe1\u606f,\u6bd4\u5982\u82b1\u8d39\u7684\u65f6\u95f4\u7b49\u5f85;<\/li>\n<\/ol>\n<\/li>\n
                          8. \u67b6\u6784\u56fe; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\"\"<\/li>\n<\/ol>\n<\/li>\n
                          9. Conventional\u548cDirect-Path Load\u65b9\u6cd5\u7684\u5bf9\u6bd4:\n
                              \n
                            1. Conventional Load:\n
                                \n
                              1. \u8bfb\u53d6\u4e00\u6761\u8bb0\u5f55,\u89e3\u6790,\u63d2\u5165,\u63d0\u4ea4;<\/li>\n
                              2. \u603b\u662f\u4f1a\u4ea7\u751fREDO\u65e5\u5fd7;<\/li>\n
                              3. \u5f3a\u5236\u68c0\u67e5\u6240\u6709\u7ea6\u675f;<\/li>\n
                              4. \u4f1a\u6fc0\u6d3b\u89e6\u53d1\u5668;<\/li>\n
                              5. \u53ef\u4ee5\u63d2\u5165\u5230\u7c07\u8868;<\/li>\n
                              6. \u5176\u5b83\u7528\u6237\u53ef\u4ee5\u4fee\u6539\u8868;<\/li>\n<\/ol>\n<\/li>\n
                              7. Direct-Path Load:\n
                                  \n
                                1. \u628a\u8bb0\u5f55\u6784\u9020\u6210\u5757,\u76f4\u63a5\u8fdb\u884c\u5757\u62f7\u8d1d;<\/li>\n
                                2. \u53ea\u6709\u5728\u6570\u636e\u5e93\u4e3aFORCE LOGGING\u6a21\u5f0f\u4e0b\u624d\u4f1a\u4ea7\u751fREDO\u65e5\u5fd7;<\/li>\n
                                3. \u53ea\u68c0\u67e5\u4e3b\u952e,\u552f\u4e00\u952e,NOT NULL\u7ea6\u675f;<\/li>\n
                                4. \u5ffd\u7565\u89e6\u53d1\u5668;<\/li>\n
                                5. \u4e0d\u80fd\u5bf9\u7c07\u8868\u52a0\u8f7d\u6570\u636e;<\/li>\n
                                6. \u5176\u5b83\u7528\u6237\u4e0d\u80fd\u4fee\u6539\u8868;<\/li>\n<\/ol>\n<\/li>\n
                                7. \u53ef\u4ee5\u4f7f\u7528\u5e76\u884c\u64cd\u4f5c\u6765\u52a0\u5feb\u901f\u5ea6,\u4f46\u662f\u9700\u8981\u624b\u52a8\u6307\u5b9a\u5e76\u884c\u5ea6;<\/li>\n<\/ol>\n<\/li>\n
                                8. SQL*Loader\u7684\u8bed\u6cd5:sqlldr keyword=value,\u547d\u4ee4\u540e\u9762\u662f\u952e\u503c\u5bf9\u7684\u7ec4\u5408;\n
                                    \n
                                  1. userid:username\/password;<\/span><\/li>\n
                                  2. control:\u63a7\u5236\u6587\u4ef6\u540d\u79f0;<\/span><\/li>\n
                                  3. log:\u65e5\u5fd7\u6587\u4ef6\u540d\u79f0;<\/span><\/li>\n
                                  4. bad:bad\u6587\u4ef6\u540d\u79f0;<\/span><\/li>\n
                                  5. data:\u6570\u636e\u6587\u4ef6\u540d\u79f0;<\/span><\/li>\n
                                  6. discard:discard\u6587\u4ef6\u540d\u79f0;<\/span><\/li>\n
                                  7. discardmax:\u5141\u8bb8\u6700\u5927\u7684discard\u7684\u8bb0\u5f55\u6570,\u9ed8\u8ba4\u4e3a\u6240\u6709\u8bb0\u5f55;<\/li>\n
                                  8. skip:\u8df3\u8fc7\u7684\u903b\u8f91\u8bb0\u5f55\u6570,\u9ed8\u8ba4\u4e3a0;<\/li>\n
                                  9. load:\u52a0\u8f7d\u7684\u903b\u8f91\u8bb0\u5f55\u6570,\u9ed8\u8ba4\u4e3a\u6240\u6709\u8bb0\u5f55;<\/li>\n
                                  10. errors:\u5141\u8bb8\u9519\u8bef\u7684\u8bb0\u5f55\u6570,\u9ed8\u8ba4\u4e3a50;<\/li>\n
                                  11. silent:\u4e0d\u63d0\u793aheader\/feedback\/errors\/discards\/partitions\u7b49\u4fe1\u606f,\u9ed8\u8ba4\u4e3aFALSE;<\/li>\n
                                  12. direct:\u4f7f\u7528\u76f4\u63a5\u8def\u5f84,\u9ed8\u8ba4\u4e3aFALSE;<\/span><\/li>\n
                                  13. multithreading:\u76f4\u63a5\u6570\u636e\u5bfc\u5165\u65f6\u4f7f\u7528\u591a\u7ebf\u7a0b;<\/span><\/li>\n
                                  14. parfile:\u4f7f\u7528\u7684\u53c2\u6570\u6587\u4ef6\u7684\u540d\u79f0;<\/span><\/li>\n
                                  15. parallel:\u4f7f\u7528\u5e76\u884c\u52a0\u8f7d,\u9ed8\u8ba4\u662fFALSE;<\/span><\/li>\n
                                  16. skip_unusable_indexes:\u8df3\u8fc7unusable\u7684\u7d22\u5f15,\u9ed8\u8ba4\u4e3aFALSE;<\/li>\n
                                  17. skip_index_maintenance:\u4e0d\u7ef4\u62a4\u7d22\u5f15,\u6807\u8bb0\u7d22\u5f15\u4e3aunusable,\u9ed8\u8ba4\u4e3aFALSE;<\/li>\n
                                  18. commit_discontinued:\u5f53\u52a0\u8f7d\u6570\u636e\u7ec8\u6b62\u65f6,\u63d0\u4ea4\u5df2\u7ecf\u52a0\u8f7d\u4e86\u7684\u6570\u636e,\u9ed8\u8ba4\u4e3aFALSE;<\/li>\n
                                  19. streamsize:\u4f7f\u7528\u76f4\u63a5\u8def\u5f84\u52a0\u8f7d\u65f6\u7684\u7f13\u5b58\u533a\u5927\u5c0f,\u9ed8\u8ba4\u662f256000;<\/li>\n
                                  20. external_table:\u4f7f\u7528\u5916\u90e8\u8868\u5bfc\u5165\u6570\u636e;\n
                                      \n
                                    1. NOT_USED:\u4e0d\u4f7f\u7528\u5916\u90e8\u8868;<\/li>\n
                                    2. GENERATE_ONLY:\u53ea\u751f\u6210\u5916\u90e8\u8868\u7684\u521b\u5efa\u8bed\u6cd5,\u751f\u6210\u5728log\u6587\u4ef6\u4e2d;<\/span><\/li>\n
                                    3. EXECUTE:\u4f7f\u7528\u5916\u90e8\u8868\u5bfc\u5165\u6570\u636e;<\/li>\n<\/ol>\n<\/li>\n
                                    4. date_cache:\u5bfc\u5165\u6570\u636e\u7684cache\u5927\u5c0f;<\/li>\n
                                    5. _display_exitcode:\u663e\u793asqlloader\u9000\u51fa\u65f6\u7684\u9000\u51fa\u7801;<\/li>\n<\/ol>\n<\/li>\n
                                    6. SQL*Loader\u7684\u9000\u51fa\u7801,\u7528\u5728SHELL\u7f16\u7a0b\u4e2d:\n
                                        \n
                                      1. EX_SUCC(0):\u6240\u6709\u7684\u8bb0\u5f55\u52a0\u8f7d\u6210\u529f;<\/li>\n
                                      2. EX_WARN(2):\u4e00\u4e9b\u8bb0\u5f55\u88ab\u653e\u5230bad file\/discard file\/\u5f02\u5e38\u7ec8\u6b62;<\/li>\n
                                      3. EX_FAIL(1):\u8bed\u6cd5\u9519\u8bef,\u64cd\u4f5c\u9519\u8bef;<\/li>\n
                                      4. \u5982\u679c\u72b6\u6001\u7801\u5927\u4e8e0\u7684\u8bdd,\u5c31\u6709\u95ee\u9898;<\/li>\n<\/ol>\n<\/li>\n
                                      5. SQL*Loader\u7684\u4f8b\u5b50:\n
                                          \n
                                        1. \u57289i\u7684\u6570\u636e\u5e93\u7684$ORACLE_HOME\/rdbms\/demo\/\u76ee\u5f55\u4e0bul*\u768411\u4e2a\u4f8b\u5b50(.ctl\u662f\u63a7\u5236\u6587\u4ef6,.sql\u662f\u4fee\u6539\u8868\u7684\u811a\u672c,.dat\u662f\u6570\u636e,\u5728scott\u7528\u6237\u4e0b\u5b8c\u6210);<\/li>\n
                                        2. EXAMPLE1:\u52a0\u8f7d\u53d8\u957f\u7684\u6570\u636e,\u6570\u636e\u5217\u4e4b\u95f4\u4ee5\u9017\u53f7\u5206\u9694,\u53ef\u80fd\u8fd8\u4ee5\u5f15\u53f7\u5305\u56f4,\u6570\u636e\u548c\u63a7\u5236\u6587\u4ef6\u5728\u4e00\u8d77;<\/li>\n
                                        3. EXAMPLE2:\u52a0\u8f7d\u56fa\u5b9a\u683c\u5f0f\u7684\u6570\u636e,\u6570\u636e\u548c\u63a7\u5236\u6587\u4ef6\u5206\u5f00;<\/li>\n
                                        4. EXAMPLE3:\u52a0\u8f7d\u6709\u5b9a\u754c\u7b26\u7684,\u968f\u610f\u683c\u5f0f\u7684\u6587\u4ef6,\u6570\u636e\u4e0e\u63a7\u5236\u6587\u4ef6\u5728\u4e00\u8d77;<\/li>\n
                                        5. EXAMPLE4:\u52a0\u8f7d\u5408\u5e76\u7684\u7269\u7406\u8bb0\u5f55,\u5408\u5e76\u591a\u4e2a\u7269\u7406\u8bb0\u5f55\u5230\u4e00\u4e2a\u903b\u8f91\u8bb0\u5f55\u4e2d;<\/li>\n
                                        6. EXAMPLE5:\u52a0\u8f7d\u6570\u636e\u5230\u591a\u4e2a\u8868\u4e2d;<\/li>\n
                                        7. EXAMPLE6:\u4f7f\u7528\u76f4\u63a5\u8def\u5f84\u7684\u65b9\u5f0f\u52a0\u8f7d\u6570\u636e;<\/li>\n
                                        8. EXAMPLE7:\u4ece\u4e00\u4e2a\u683c\u5f0f\u5316\u7684\u62a5\u8868\u4e2d\u62bd\u53d6\u6570\u636e\u5e76\u52a0\u8f7d;<\/li>\n
                                        9. EXAMPLE8:\u52a0\u8f7d\u5206\u533a\u8868;<\/li>\n
                                        10. EXAMPLE9:\u52a0\u8f7dCLOB\u5217;<\/li>\n
                                        11. EXAMPLE10:\u52a0\u8f7dREF\u5217\u548cARRAYs\u5217;<\/li>\n
                                        12. EXAMPLE11:\u8f6c\u6362\u5b57\u7b26\u96c6,\u4f7f\u7528Unicode\u7f16\u7801\u52a0\u8f7d\u6570\u636e;<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
                                        13. DIRECTORY\u5bf9\u8c61:\n
                                            \n
                                          1. \u53ea\u6709SYS\u7528\u6237\u53ef\u4ee5\u62e5\u6709DIRECTORY\u5bf9\u8c61,\u4f46\u662f\u5b83\u53ef\u4ee5\u6388\u6743\u5176\u5b83\u7528\u6237\u521b\u5efa\u7684\u6743\u9650;<\/li>\n
                                          2. DIRECTORY\u5bf9\u8c61\u53ea\u662f\u4e00\u4e2a\u6587\u4ef6\u7cfb\u7edf\u76ee\u5f55\u7684\u6620\u5c04\/\u522b\u540d(\u5982\u679coracle\u7528\u6237\u6ca1\u6709\u8fd9\u4e2a\u76ee\u5f55\u7684\u6743\u9650\u600e\u4e48\u529e?<\/span>);<\/li>\n
                                          3. \u5177\u6709DBA\u89d2\u8272\u6216\u8005CREATE ANY\u00a0DIRECTORY\u6743\u9650\u7684\u7528\u6237\u53ef\u4ee5\u521b\u5efaDIRECTORY\u5bf9\u8c61:CREATE DIRECTORY ext_tab_dir AS ‘\/u01\/datafiles’;<\/li>\n
                                          4. \u67e5\u770b\u7cfb\u7edf\u4e2d\u5b58\u5728\u7684DIRECTORY\u5bf9\u8c61:SELECT * FROM dba_directories;<\/li>\n
                                          5. \u521b\u5efa\u8005\/DBA\u53ef\u4ee5\u5bf9\u5176\u5b83\u7528\u6237\/\u89d2\u8272\u6388\u6743:GRANT READ, WRITE ON DIRECTORY ext_tab_dir TO hr;<\/li>\n
                                          6. \u67e5\u770b\u67d0\u4e2aDIRECTORY\u5bf9\u8c61\u7684\u6743\u9650:SELECT * FROM dba_tab_privs WHERE table_name = ‘EXT_TAB_DIR’;<\/li>\n
                                          7. \u521b\u5efa\u8005\u548cDBA\u81ea\u52a8\u5177\u6709RW\u6743\u9650;<\/li>\n
                                          8. \u5220\u9664DIRECTORY\u5bf9\u8c61:DROP DIRECTORY\u00a0ext_tab_dir;<\/li>\n<\/ol>\n<\/li>\n
                                          9. \u5916\u90e8\u8868(External Tables):\n
                                              \n
                                            1. \u5916\u90e8\u8868\u7684\u6982\u5ff5:\n
                                                \n
                                              1. 10g\u4e4b\u524d,\u5916\u90e8\u8868\u662f\u53ea\u8bfb\u7684;10g\u4e4b\u540e,\u5916\u90e8\u8868\u53ef\u8bfb\u53ef\u5199;<\/li>\n
                                              2. \u5916\u90e8\u8868\u662f\u5bf9SQL*Loader\u529f\u80fd\u7684\u8865\u5145,\u53ef\u4ee5\u50cf\u8bbf\u95ee\u6570\u636e\u5e93\u4e2d\u8868\u4e00\u6837\u8bbf\u95ee\u6570\u636e\u5e93\u5916\u7684\u8d44\u6e90;<\/li>\n
                                              3. \u53ea\u80fd\u5728\u670d\u52a1\u5668\u7aef\u64cd\u4f5c,\u6570\u636e\u8981\u5b58\u653e\u5728\u670d\u52a1\u5668\u7aef,\u56e0\u4e3a\u9700\u8981\u4f7f\u7528DIRECTORY;<\/li>\n
                                              4. \u53ef\u4ee5\u5bfc\u5165\u56fa\u5b9a\u683c\u5f0f\u7684TXT\u6587\u4ef6\u7684\u6570\u636e;<\/li>\n
                                              5. \u5728ETL\u4e2d\u5c3d\u91cf\u591a\u7528\u5916\u90e8\u8868,\u800c\u5c11\u7528SQL*Loader;<\/span><\/li>\n<\/ol>\n<\/li>\n
                                              6. \u521b\u5efa\u5916\u90e8\u8868:\n
                                                  \n
                                                1. \u4f7f\u7528CREATE TABLE table_name(…) ORGANIZATION EXTERNAL\u8bed\u6cd5,\u9700\u8981\u6307\u5b9a\u7684\u5c5e\u6027:\n
                                                    \n
                                                  1. TYPE:\u6307\u5b9a\u5916\u90e8\u8868\u4f7f\u7528\u7684\u8bbf\u95ee\u5f15\u64ce;\n
                                                      \n
                                                    1. ORACLE_LOADER:\u9ed8\u8ba4\u503c,\u53ea\u80fd\u8fdb\u884c\u6570\u636e\u52a0\u8f7d\u64cd\u4f5c,\u800c\u4e14\u6570\u636e\u5fc5\u987b\u662f\u6587\u672c\u6587\u4ef6;<\/li>\n
                                                    2. ORACLE_DATAPUMP:\u53ef\u4ee5\u8fdb\u884c\u6570\u636e\u52a0\u8f7d\/\u5378\u8f7d\u7684\u64cd\u4f5c,\u6570\u636e\u5fc5\u987b\u662f\u4e8c\u8fdb\u5236\u7684dump\u6587\u4ef6;<\/li>\n<\/ol>\n<\/li>\n
                                                    3. DEFAULT DIRECTORY:\u6307\u5b9a\u5916\u90e8\u8868\u6240\u4f7f\u7528\u7684\u9ed8\u8ba4\u76ee\u5f55,\u662f\u4e00\u4e2aDIRECTORY\u5bf9\u8c61,\u800c\u4e0d\u662f\u4e00\u4e2a\u8def\u5f84;<\/li>\n
                                                    4. ACCESS PARAMETERS:\u6307\u5b9a\u5916\u90e8\u8868\u6570\u636e\u5bf9\u5e94\u7684\u8868\u4e2d\u7684\u5217\u548c\u67d0\u4e00\u5217\u7684\u683c\u5f0f\u5316\u4fe1\u606f,\u4e0e\u4f7f\u7528\u7684\u5f15\u64ce\u6709\u5173;<\/li>\n
                                                    5. LOCATION:\u6307\u5b9a\u5916\u90e8\u8868\u7684\u4f4d\u7f6e,\u662f\u76ee\u5f55\u548c\u6587\u4ef6\u540d\u7684\u7ec4\u5408(directory:file),\u5982\u679c\u6ca1\u6709\u6307\u5b9a\u76ee\u5f55\u5219\u4f7f\u7528\u9ed8\u8ba4\u7684\u76ee\u5f55;<\/li>\n<\/ol>\n<\/li>\n
                                                    6. \u521b\u5efa\u7684\u6b65\u9aa4:\n
                                                        \n
                                                      1. \u521b\u5efaDIRECTORY\u5bf9\u8c61;<\/li>\n
                                                      2. \u521b\u5efa\u5916\u90e8\u8868;<\/li>\n
                                                      3. \u5176\u5b83\u64cd\u4f5c:\u53ef\u4ee5\u518d\u521b\u5efa\u4e00\u4e2a\u8868,\u7136\u540e\u4f7f\u7528INSERT INTO … SELECT …\u8bed\u6cd5\u5bfc\u5165\u6570\u636e;<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
                                                      4. \u52a0\u8f7d\u548c\u5378\u8f7d\u6570\u636e:\n
                                                          \n
                                                        1. \u52a0\u8f7d\u6570\u636e:\u628a\u5916\u90e8\u8868\u4e2d\u7684\u6570\u636e\u5bfc\u5165\u5230\u6570\u636e\u5e93\u7684\u8868\u4e2d;<\/li>\n
                                                        2. \u5378\u8f7d\u6570\u636e:\u628a\u6570\u636e\u5e93\u8868\u4e2d\u7684\u5185\u5bb9\u5bfc\u5165\u5230\u5916\u90e8\u4e0d\u8868\u4e2d,\u53ea\u80fd\u4f7f\u7528ORACLE_DATAPUMP\u5f15\u64ce;<\/li>\n<\/ol>\n<\/li>\n
                                                        3. \u4f7f\u7528\u5916\u90e8\u8868\u65f6\u7684\u6570\u636e\u7c7b\u578b\u8f6c\u6362,LOB\u5b57\u6bb5:CREATE TABLE LONG_TAB_XT (LONG_COL CLOB) ORGANIZATION EXTERNAL…SELECT\u00a0TO_LOB(LONG_COL)<\/span>\u00a0FROM LONG_TAB;<\/li>\n
                                                        4. \u5e76\u884c\u67e5\u8be2\u5916\u90e8\u8868:\n
                                                            \n
                                                          1. ORACLE_LOADER\u5f15\u64ce:\n
                                                              \n
                                                            1. \u5982\u679c\u52a0\u8f7d\u6587\u4ef6\u65f6\u987a\u5e8f\u6307\u5b9a\u4e86\u591a\u4e2a\u6587\u4ef6;<\/li>\n
                                                            2. \u8bb0\u5f55\u4f7f\u7528VAR\u683c\u5f0f\u5316;<\/li>\n<\/ol>\n<\/li>\n
                                                            3. ORACLE_DATAPUMP\u5f15\u64ce:\n
                                                                \n
                                                              1. \u52a0\u8f7d\u6570\u636e\u65f6:\n
                                                                  \n
                                                                1. \u52a0\u8f7d\u65f6\u4f7f\u7528\u4e86\u591a\u4e2a\u6587\u4ef6;<\/li>\n
                                                                2. \u4f7f\u7528\u4e00\u4e2a\u5927\u7684\u6587\u4ef6\u65f6\u4e5f\u4f1a\u5e76\u884c,\u56e0\u4e3a\u4f1a\u8bb0\u5f55\u6587\u4ef6\u8bfb\u53d6\u7684\u504f\u79fb\u91cf;<\/li>\n<\/ol>\n<\/li>\n
                                                                3. \u5378\u8f7d\u6570\u636e\u65f6:\n
                                                                    \n
                                                                  1. LOCATION\u53c2\u6570\u6307\u5b9a\u591a\u4e2a\u6587\u4ef6\u65f6\u53ef\u4ee5\u53d1\u751f\u5e76\u884c;<\/li>\n
                                                                  2. \u5982\u679c\u5e76\u884c\u5ea6\u7b49\u4e8e\u6587\u4ef6\u7684\u4e2a\u6570\u7684\u8bdd,\u6bcf\u4e2a\u8fdb\u7a0b\u5199\u4e00\u4e2a\u6587\u4ef6;<\/li>\n
                                                                  3. \u5982\u679c\u5e76\u884c\u5ea6\u5927\u4e8e\u6587\u4ef6\u7684\u4e2a\u6570\u7684\u8bdd,\u5e76\u884c\u5ea6\u964d\u4f4e\u4e3a\u6587\u4ef6\u7684\u4e2a\u6570;<\/li>\n
                                                                  4. \u5982\u679c\u5e76\u884c\u5ea6\u5c0f\u4e8e\u6587\u4ef6\u7684\u4e2a\u6570\u7684\u8bdd,\u5916\u90e8\u6587\u4ef6\u5c06\u4e0d\u4f1a\u88ab\u4f7f\u7528;<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
                                                                  5. \u81ea\u5df1\u51b3\u5b9a\u5e76\u884c\u5ea6;<\/li>\n<\/ol>\n<\/li>\n
                                                                  6. \u5916\u90e8\u8868\u7684\u9650\u5236:\n
                                                                      \n
                                                                    1. \u4e0d\u652f\u6301\u52a0\u5bc6\u5217;<\/li>\n
                                                                    2. \u4e0d\u652f\u6301LONG\u7c7b\u578b\u7684\u5217;<\/li>\n
                                                                    3. \u7279\u6b8a\u5b57\u7b26\u9700\u8981\u7528\u53cc\u5f15\u53f7\u8f6c\u6362;<\/li>\n
                                                                    4. \u4e0d\u80fd\u662f\u4e34\u65f6\u8868;<\/li>\n
                                                                    5. \u4e0d\u80fd\u6dfb\u52a0\u7ea6\u675f;<\/li>\n<\/ol>\n<\/li>\n
                                                                    6. SQL*Loader\u548c\u5916\u90e8\u8868\u7684\u4e0d\u540c:\n
                                                                        \n
                                                                      1. \u5728sql*loader\u4e2d\u53ef\u4ee5\u4f7f\u7528\u53cd\u659c\u6760\u6765\u8f6c\u4e49\u4e00\u4e2a\u5b57\u7b26:FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘\\”;<\/li>\n
                                                                      2. \u5728\u5916\u90e8\u8868\u4e2d\u4f7f\u7528\u53cd\u659c\u6760\u4f1a\u62a5\u9519,\u53ef\u4ee5\u4f7f\u7528\u5f15\u53f7\u6765\u5206\u5272\u5b57\u6bb5:TERMINATED BY ‘,’ ENCLOSED BY “‘”;<\/li>\n<\/ol>\n<\/li>\n
                                                                      3. \u5916\u90e8\u8868\u7684\u4f8b\u5b50:\n
                                                                          \n
                                                                        1. ORACLE_LOADER\u5f15\u64ce:\u4f7f\u7528\u811a\u672c\u5bfc\u5165\u7684\u4f8b\u5b50;<\/li>\n
                                                                        2. ORACLE_LOADER\u5f15\u64ce:\u4f7f\u7528sql*loader\u751f\u6210\u5916\u90e8\u8868\u811a\u672c\u7684\u4f8b\u5b50;<\/span><\/li>\n
                                                                        3. ORACLE_DATADUMP\u5f15\u64ce:\u5bfc\u51fa\u6570\u636e\u7684\u4f8b\u5b50;<\/li>\n
                                                                        4. ORACLE_DATADUMP\u5f15\u64ce:\u5bfc\u5165\u6570\u636e\u7684\u4f8b\u5b50;<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/div>\n
                                                                          <\/div>\n
                                                                          ————————- Direct-Path INSERT\u7684\u4f8b\u5b50 ————————-<\/div>\n
                                                                          — \u521b\u5efa\u4e00\u4e2a\u7a7a\u8868;
                                                                          \nCREATE TABLE bt AS SELECT * FROM dba_objects WHERE 1 = 0;
                                                                          \n— \u6b63\u5e38\u63d2\u5165\u6570\u636e;<\/div>\n
                                                                          INSERT INTO bt SELECT * FROM dba_objects;<\/div>\n
                                                                          — \u5728\u63d0\u4ea4\u4e4b\u524d\u5c31\u53ef\u4ee5\u67e5\u8be2\u5230\u8868\u7684\u6570\u91cf;
                                                                          \nSELECT COUNT(*) FROM bt;
                                                                          \nCOMMIT;
                                                                          \n\"\"<\/div>\n
                                                                          — \u4f7f\u7528\u76f4\u63a5\u8def\u5f84\u7684\u65b9\u5f0f;
                                                                          \nINSERT\u00a0\/*+ APPEND *\/<\/span>\u00a0INTO bt SELECT * FROM dba_objects;<\/div>\n
                                                                          — \u63d0\u4ea4\u4e4b\u524d\u67e5\u8be2\u8868\u62a5\u9519,\u4ece\u4e00\u65b9\u9762\u8bf4\u660e\u4e86\u76f4\u63a5\u8def\u5f84\u63d2\u5165;
                                                                          \nSELECT COUNT(*) FROM bt;
                                                                          \nSELECT COUNT(*) FROM bt
                                                                          \n*
                                                                          \nERROR at line 1:
                                                                          \nORA-12838: cannot read\/modify an object after modifying it in parallel
                                                                          \n\"\"<\/div>\n
                                                                          ————————- Direct-Path INSERT\u7684\u4f8b\u5b50 ————————-<\/div>\n
                                                                          <\/div>\n
                                                                          ————————- Direct-Path INSERT NOLOGGING\u7684\u4f8b\u5b50 ————————-<\/div>\n
                                                                          — \u4e00,\u8868\u5904\u4e8eLOGGING\u6a21\u5f0f,\u6570\u636e\u5e93\u4e0d\u662fFORCE LOGGING\u6a21\u5f0f,\u89c2\u5bdf\u51e0\u79cd\u63d2\u5165\u65b9\u5f0f\u4ea7\u751f\u7684\u65e5\u5fd7;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          <\/div>\n
                                                                          — 1.\u4f20\u7edf\u63d2\u5165,LOGGING\u6a21\u5f0f,\u4f1a\u4ea7\u751f\u65e5\u5fd7;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          <\/div>\n
                                                                          — 2.\u4f20\u7edf\u63d2\u5165,NOLOGGING\u6a21\u5f0f,\u540c\u6837\u4f1a\u4ea7\u751f\u65e5\u5fd7;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          <\/div>\n
                                                                          — 3.\u76f4\u63a5\u63d2\u5165,LOGGING\u6a21\u5f0f,\u4e0d\u4f1a\u4ea7\u751f\u65e5\u5fd7;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          <\/div>\n
                                                                          — 4.\u76f4\u63a5\u63d2\u5165,NOLOGGING\u6a21\u5f0f,\u4e5f\u4e0d\u4f1a\u4ea7\u751f\u65e5\u5fd7;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          <\/div>\n
                                                                          — \u4e8c,\u8868\u5904\u4e8eNOLOGGING\u6a21\u5f0f,\u6570\u636e\u5e93\u5904\u4e8e\u975eFORCE LOGGING\u6a21\u5f0f:\u4f20\u7edf\u65b9\u5f0f\u90fd\u4f1a\u4ea7\u751f\u65e5\u5fd7,\u76f4\u63a5\u63d2\u5165\u65b9\u5f0f\u90fd\u4e0d\u4ea7\u751f\u65e5\u5fd7;<\/div>\n
                                                                          — \u4e09,\u6570\u636e\u5e93\u5904\u4e8eFORCE LOGGING\u6a21\u5f0f,\u65e0\u8bba\u8868\u662f\u4ec0\u4e48\u6a21\u5f0f,\u65e0\u8bba\u54ea\u79cd\u65b9\u5f0f\u90fd\u4f1a\u8bb0\u5f55\u65e5\u5fd7;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          ————————- Direct-Path INSERT NOLOGGING\u7684\u4f8b\u5b50 ————————-<\/div>\n
                                                                          <\/div>\n
                                                                          ————————- SQL*Loader\u7684\u4f8b\u5b50 ————————-<\/div>\n
                                                                          — EXAMPLE1:\u52a0\u8f7d\u53d8\u957f\u7684\u6570\u636e,\u6570\u636e\u5217\u4e4b\u95f4\u4ee5\u9017\u53f7\u5206\u9694,\u53ef\u80fd\u8fd8\u4ee5\u5f15\u53f7\u5305\u56f4,\u6570\u636e\u548c\u63a7\u5236\u6587\u4ef6\u5728\u4e00\u8d77;<\/div>\n
                                                                          — \u521b\u5efa\u6d4b\u8bd5\u8868;<\/div>\n
                                                                          DROP TABLE EMP;<\/div>\n
                                                                          DROP TABLE DEPT;<\/div>\n
                                                                          CREATE TABLE DEPT
                                                                          \n(
                                                                          \nDEPTNO NUMBER(2) not null,
                                                                          \nDNAME\u00a0 VARCHAR2(14),
                                                                          \nLOC\u00a0\u00a0\u00a0 VARCHAR2(13)
                                                                          \n);
                                                                          \nCREATE TABLE EMP
                                                                          \n(
                                                                          \nEMPNO\u00a0\u00a0\u00a0 NUMBER(4) not null,
                                                                          \nENAME\u00a0\u00a0\u00a0 VARCHAR2(10),
                                                                          \nJOB\u00a0\u00a0\u00a0\u00a0\u00a0 VARCHAR2(9),
                                                                          \nMGR\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER(4),
                                                                          \nHIREDATE DATE,
                                                                          \nSAL\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER(7,2),
                                                                          \nCOMM\u00a0\u00a0\u00a0\u00a0 NUMBER(7,2),
                                                                          \nDEPTNO\u00a0\u00a0 NUMBER(2)
                                                                          \n);<\/div>\n
                                                                          — \u63a7\u5236\u6587\u4ef6\u548c\u6570\u636e;<\/div>\n
                                                                          LOAD DATA
                                                                          \nINFILE *
                                                                          \nINTO TABLE DEPT
                                                                          \nFIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘”‘<\/span>
                                                                          \n(DEPTNO, DNAME, LOC)
                                                                          \nBEGINDATA
                                                                          \n12,RESEARCH,”SARATOGA”
                                                                          \n10,”ACCOUNTING”,CLEVELAND
                                                                          \n11,”ART”,SALEM
                                                                          \n13,FINANCE,”BOSTON”
                                                                          \n21,”SALES”,PHILA.<\/div>\n
                                                                          — \u5bfc\u5165\u6570\u636e:sqlldr scott\/tiger control=\/u01\/sqlldrdemo\/demo1.ctl;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          — \u9a8c\u8bc1\u6570\u636e;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          <\/div>\n
                                                                          — EXAMPLE2:\u52a0\u8f7d\u56fa\u5b9a\u683c\u5f0f\u7684\u6570\u636e,\u6570\u636e\u548c\u63a7\u5236\u6587\u4ef6\u5206\u5f00;<\/div>\n
                                                                          — \u63a7\u5236\u6587\u4ef6;<\/div>\n
                                                                          LOAD DATA
                                                                          \nINFILE ‘\/u01\/sqlldrdemo\/demo2.dat’
                                                                          \nINTO TABLE EMP
                                                                          \n( EMPNO\u00a0\u00a0\u00a0\u00a0POSITION(01:04)<\/span>\u00a0INTEGER EXTERNAL,
                                                                          \nENAME\u00a0\u00a0\u00a0 POSITION(06:15) CHAR,
                                                                          \nJOB\u00a0\u00a0\u00a0\u00a0\u00a0 POSITION(17:25) CHAR,
                                                                          \nMGR\u00a0\u00a0\u00a0\u00a0\u00a0 POSITION(27:30) INTEGER EXTERNAL,
                                                                          \nSAL\u00a0\u00a0\u00a0\u00a0\u00a0 POSITION(32:39) DECIMAL EXTERNAL,
                                                                          \nCOMM\u00a0\u00a0\u00a0\u00a0 POSITION(41:48) DECIMAL EXTERNAL,
                                                                          \nDEPTNO\u00a0\u00a0 POSITION(50:51) INTEGER EXTERNAL)<\/div>\n
                                                                          — \u6570\u636e\u6587\u4ef6;<\/div>\n
                                                                          7782 CLARK\u00a0\u00a0\u00a0\u00a0\u00a0 MANAGER\u00a0\u00a0 7839\u00a0 2572.50\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10
                                                                          \n7839 KING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PRESIDENT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5500.00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10
                                                                          \n7934 MILLER\u00a0\u00a0\u00a0\u00a0 CLERK\u00a0\u00a0\u00a0\u00a0 7782\u00a0\u00a0 920.00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10
                                                                          \n7566 JONES\u00a0\u00a0\u00a0\u00a0\u00a0 MANAGER\u00a0\u00a0 7839\u00a0 3123.75\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 20
                                                                          \n7499 ALLEN\u00a0\u00a0\u00a0\u00a0\u00a0 SALESMAN\u00a0 7698\u00a0 1600.00\u00a0\u00a0 300.00 30
                                                                          \n7654 MARTIN\u00a0\u00a0\u00a0\u00a0 SALESMAN\u00a0 7698\u00a0 1312.50\u00a0 1400.00 30
                                                                          \n7658 CHAN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ANALYST\u00a0\u00a0 7566\u00a0 3450.00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 20<\/div>\n
                                                                          — \u5bfc\u5165\u6570\u636e:sqlldr scott\/tiger control=\/u01\/sqlldrdemo\/demo2.ctl;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          — \u9a8c\u8bc1\u6570\u636e;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          <\/div>\n
                                                                          — EXAMPLE3:\u52a0\u8f7d\u6709\u5b9a\u754c\u7b26\u7684,\u968f\u610f\u683c\u5f0f\u7684\u6587\u4ef6,\u6570\u636e\u4e0e\u63a7\u5236\u6587\u4ef6\u5728\u4e00\u8d77;<\/div>\n
                                                                          — \u4fee\u6539\u8868\u7ed3\u6784:alter table emp add (projno number, loadseq number);<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          — \u63a7\u5236\u6587\u4ef6;<\/div>\n
                                                                          LOAD DATA
                                                                          \nINFILE *
                                                                          \nAPPEND<\/span>
                                                                          \nINTO TABLE EMP
                                                                          \nFIELDS TERMINATED BY “,” OPTIONALLY ENCLOSED BY ‘”‘
                                                                          \n(empno, ename, job, mgr,
                                                                          \nhiredate DATE(20) “DD-Month-YYYY”,
                                                                          \nsal, comm,
                                                                          \ndeptno\u00a0\u00a0\u00a0CHAR TERMINATED BY ‘:’<\/span>,
                                                                          \nprojno,
                                                                          \nloadseq\u00a0\u00a0SEQUENCE(MAX,1)<\/span>)
                                                                          \nBEGINDATA
                                                                          \n7782, “Clark”, “Manager”, 7839, 09-June-1981, 2572.50,, 10:101
                                                                          \n7839, “King”, “President”, , 17-November-1981, 5500.00,, 10:102
                                                                          \n7934, “Miller”, “Clerk”, 7782, 23-January-1982, 920.00,, 10:102
                                                                          \n7566, “Jones”, “Manager”, 7839, 02-April-1981, 3123.75,, 20:101
                                                                          \n7499, “Allen”, “Salesman”, 7698, 20-February-1981, 1600.00, 300.00, 30:103
                                                                          \n7654, “Martin”, “Salesman”, 7698, 28-September-1981, 1312.50, 1400.00, 30:103
                                                                          \n7658, “Chan”, “Analyst”, 7566, 03-May-1982, 3450,, 20:101<\/div>\n
                                                                          — \u5bfc\u5165\u6570\u636e:sqlldr scott\/tiger control=\/u01\/sqlldrdemo\/demo3.ctl;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          — \u9a8c\u8bc1\u6570\u636e;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          <\/div>\n
                                                                          — EXAMPLE4:\u52a0\u8f7d\u5408\u5e76\u7684\u7269\u7406\u8bb0\u5f55,\u5408\u5e76\u591a\u4e2a\u7269\u7406\u8bb0\u5f55\u5230\u4e00\u4e2a\u903b\u8f91\u8bb0\u5f55\u4e2d;<\/div>\n
                                                                          — \u4fee\u6539\u8868\u7ed3\u6784;<\/div>\n
                                                                          DROP TABLE EMP;<\/div>\n
                                                                          CREATE TABLE EMP
                                                                          \n(
                                                                          \nEMPNO\u00a0\u00a0\u00a0 NUMBER(4) not null,
                                                                          \nENAME\u00a0\u00a0\u00a0 VARCHAR2(10),
                                                                          \nJOB\u00a0\u00a0\u00a0\u00a0\u00a0 VARCHAR2(9),
                                                                          \nMGR\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER(4),
                                                                          \nHIREDATE DATE,
                                                                          \nSAL\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER(7,2),
                                                                          \nCOMM\u00a0\u00a0\u00a0\u00a0 NUMBER(7,2),
                                                                          \nDEPTNO\u00a0\u00a0 NUMBER(2)
                                                                          \n);<\/div>\n
                                                                          CREATE UNIQUE INDEX UNQ_EMPNO ON EMP(EMPNO);<\/div>\n
                                                                          — \u63a7\u5236\u6587\u4ef6;<\/div>\n
                                                                          LOAD DATA
                                                                          \nINFILE “\/u01\/sqlldrdemo\/demo4.dat”
                                                                          \nDISCARDFILE “\/u01\/sqlldrdemo\/demo4.dis”
                                                                          \nDISCARDMAX 999
                                                                          \nREPLACE
                                                                          \nCONTINUEIF (1) = ‘*’<\/span>
                                                                          \nINTO TABLE EMP
                                                                          \n( EMPNO\u00a0\u00a0\u00a0 POSITION(01:04) INTEGER EXTERNAL,
                                                                          \nENAME\u00a0\u00a0\u00a0 POSITION(06:15) CHAR,
                                                                          \nJOB\u00a0\u00a0\u00a0\u00a0\u00a0 POSITION(17:25) CHAR,
                                                                          \nMGR\u00a0\u00a0\u00a0\u00a0\u00a0 POSITION(27:30) INTEGER EXTERNAL,
                                                                          \nSAL\u00a0\u00a0\u00a0\u00a0\u00a0 POSITION(32:39) DECIMAL EXTERNAL,
                                                                          \nCOMM\u00a0\u00a0\u00a0\u00a0 POSITION(41:48) DECIMAL EXTERNAL,
                                                                          \nDEPTNO\u00a0\u00a0 POSITION(50:51) INTEGER EXTERNAL,
                                                                          \nHIREDATE POSITION(52:60) INTEGER EXTERNAL)<\/div>\n
                                                                          — \u6570\u636e\u6587\u4ef6;<\/div>\n
                                                                          *7782 CLARK\u00a0\u00a0\u00a0\u00a0\u00a0 MA
                                                                          \nNAGER\u00a0\u00a0 7839\u00a0 2572.50\u00a0\u00a0 -10\u00a0\u00a0\u00a0 2512-NOV-85
                                                                          \n*7839 KING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PR
                                                                          \nESIDENT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5500.00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2505-APR-83
                                                                          \n*7934 MILLER\u00a0\u00a0\u00a0\u00a0 CL
                                                                          \nERK\u00a0\u00a0\u00a0\u00a0 7782\u00a0\u00a0 920.00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2508-MAY-80
                                                                          \n*7566 JONES\u00a0\u00a0\u00a0\u00a0\u00a0 MA
                                                                          \nNAGER\u00a0\u00a0 7839\u00a0 3123.75\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2517-JUL-85
                                                                          \n*7499 ALLEN\u00a0\u00a0\u00a0\u00a0\u00a0 SA
                                                                          \nLESMAN\u00a0 7698\u00a0 1600.00\u00a0\u00a0 300.00 25 3-JUN-84
                                                                          \n*7654 MARTIN\u00a0\u00a0\u00a0\u00a0 SA
                                                                          \nLESMAN\u00a0 7698\u00a0 1312.50\u00a0 1400.00 2521-DEC-85
                                                                          \n*7658 CHAN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AN
                                                                          \nALYST\u00a0\u00a0 7566\u00a0 3450.00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2516-FEB-84
                                                                          \n*\u00a0\u00a0\u00a0\u00a0 CHEN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AN
                                                                          \nALYST\u00a0\u00a0 7566\u00a0 3450.00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2516-FEB-84
                                                                          \n*7658 CHIN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 AN
                                                                          \nALYST\u00a0\u00a0 7566\u00a0 3450.00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2516-FEB-84<\/span><\/div>\n
                                                                          — \u5bfc\u5165\u6570\u636e:sqlldr scott\/tiger control=\/u01\/sqlldrdemo\/demo4.ctl;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          — \u9a8c\u8bc1\u6570\u636e;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          — \u68c0\u67e5\u4e0d\u6ee1\u8db3\u6761\u4ef6\u7684\u8bb0\u5f55;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          <\/div>\n
                                                                          — EXAMPLE5:\u52a0\u8f7d\u6570\u636e\u5230\u591a\u4e2a\u8868\u4e2d;<\/div>\n
                                                                          — \u521b\u5efa\u6d4b\u8bd5\u8868;<\/div>\n
                                                                          DROP TABLE emp;
                                                                          \nDROP TABLE proj;
                                                                          \nCREATE TABLE EMP
                                                                          \n(
                                                                          \nEMPNO\u00a0\u00a0\u00a0 NUMBER(4) not null,
                                                                          \nENAME\u00a0\u00a0\u00a0 CHAR(10),
                                                                          \nJOB\u00a0\u00a0\u00a0\u00a0\u00a0 CHAR(9),
                                                                          \nMGR\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER(4),
                                                                          \nHIREDATE DATE,
                                                                          \nSAL\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER(7,2),
                                                                          \nCOMM\u00a0\u00a0\u00a0\u00a0 NUMBER(7,2),
                                                                          \nDEPTNO\u00a0\u00a0 NUMBER(2)
                                                                          \n);
                                                                          \nCREATE UNIQUE INDEX unq_empno ON EMP (EMPNO);
                                                                          \nCREATE TABLE PROJ
                                                                          \n(
                                                                          \nEMPNO\u00a0 NUMBER,
                                                                          \nPROJNO NUMBER
                                                                          \n);<\/div>\n
                                                                          — \u63a7\u5236\u6587\u4ef6;<\/div>\n
                                                                          LOAD DATA
                                                                          \nINFILE ‘\/u01\/sqlldrdemo\/demo5.dat’
                                                                          \nBADFILE ‘\/u01\/sqlldrdemo\/demo5.bad’
                                                                          \nDISCARDFILE ‘\/u01\/sqlldrdemo\/demo5.dis’
                                                                          \nREPLACE<\/span>
                                                                          \nINTO TABLE EMP
                                                                          \n(EMPNO\u00a0\u00a0\u00a0 POSITION(1:4)\u00a0\u00a0 INTEGER EXTERNAL,
                                                                          \nENAME\u00a0\u00a0\u00a0 POSITION(6:15)\u00a0 CHAR,
                                                                          \nDEPTNO\u00a0\u00a0 POSITION(17:18) CHAR,
                                                                          \nMGR\u00a0\u00a0\u00a0\u00a0\u00a0 POSITION(20:23) INTEGER EXTERNAL)
                                                                          \nINTO TABLE PROJ
                                                                          \n— PROJ has two columns, both not null: EMPNO and PROJNO
                                                                          \nWHEN PROJNO != ‘\u00a0\u00a0 ‘<\/span>
                                                                          \n(EMPNO\u00a0\u00a0\u00a0 POSITION(1:4)\u00a0\u00a0 INTEGER EXTERNAL,
                                                                          \nPROJNO\u00a0\u00a0 POSITION(25:27) INTEGER EXTERNAL)\u00a0\u00a0 — 1st proj
                                                                          \nINTO TABLE PROJ
                                                                          \nWHEN PROJNO != ‘\u00a0\u00a0 ‘
                                                                          \n(EMPNO\u00a0\u00a0\u00a0 POSITION(1:4)\u00a0\u00a0 INTEGER EXTERNAL,
                                                                          \nPROJNO\u00a0\u00a0 POSITION(29:31) INTEGER EXTERNAL)\u00a0\u00a0 — 2nd proj
                                                                          \nINTO TABLE PROJ
                                                                          \nWHEN PROJNO != ‘\u00a0\u00a0 ‘
                                                                          \n(EMPNO\u00a0\u00a0\u00a0 POSITION(1:4)\u00a0\u00a0 INTEGER EXTERNAL,
                                                                          \nPROJNO\u00a0\u00a0 POSITION(33:35) INTEGER EXTERNAL)\u00a0\u00a0 — 3rd proj<\/div>\n
                                                                          — \u6570\u636e\u6587\u4ef6;<\/div>\n
                                                                          1234 BAKER\u00a0\u00a0\u00a0\u00a0\u00a0 10 9999 101 102 103
                                                                          \n1234 JOKER\u00a0\u00a0\u00a0\u00a0\u00a0 10 9999 777 888 999<\/span>
                                                                          \n2664 YOUNG\u00a0\u00a0\u00a0\u00a0\u00a0 20 2893 425 abc 102<\/span>
                                                                          \n5321 OTOOLE\u00a0\u00a0\u00a0\u00a0 10 9999 321\u00a0 55\u00a0 40
                                                                          \n2134 FARMER\u00a0\u00a0\u00a0\u00a0 20 4555 236 456
                                                                          \n2414 LITTLE\u00a0\u00a0\u00a0\u00a0 20 5634 236 456\u00a0 40
                                                                          \n6542 LEE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10 4532 102 321\u00a0 14
                                                                          \n2849 EDDS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 xx 4555\u00a0\u00a0\u00a0\u00a0 294\u00a0 40<\/span>
                                                                          \n4532 PERKINS\u00a0\u00a0\u00a0 10 9999\u00a0 40
                                                                          \n1244 HUNT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 11 3452 665 133 456
                                                                          \n123 DOOLITTLE\u00a0 12 9940\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 132
                                                                          \n1453 MACDONALD\u00a0 25 5532\u00a0\u00a0\u00a0\u00a0 200<\/div>\n
                                                                          — \u5bfc\u5165\u6570\u636e:sqlldr scott\/tiger control=\/u01\/sqlldrdemo\/demo5.ctl;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          — \u9a8c\u8bc1\u6570\u636e;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          — \u68c0\u67e5\u4e0d\u6ee1\u8db3\u6761\u4ef6\u7684\u8bb0\u5f55;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          <\/div>\n
                                                                          — EXAMPLE6:\u4f7f\u7528\u76f4\u63a5\u8def\u5f84\u7684\u65b9\u5f0f\u52a0\u8f7d\u6570\u636e;<\/div>\n
                                                                          — \u521b\u5efa\u6d4b\u8bd5\u8868;<\/div>\n
                                                                          DROP TABLE emp;
                                                                          \nCREATE TABLE EMP
                                                                          \n(
                                                                          \nEMPNO\u00a0\u00a0\u00a0 NUMBER(4) not null,
                                                                          \nENAME\u00a0\u00a0\u00a0 CHAR(10),
                                                                          \nJOB\u00a0\u00a0\u00a0\u00a0\u00a0 CHAR(9),
                                                                          \nMGR\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER(4),
                                                                          \nHIREDATE DATE,
                                                                          \nSAL\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER(7,2),
                                                                          \nCOMM\u00a0\u00a0\u00a0\u00a0 NUMBER(7,2),
                                                                          \nDEPTNO\u00a0\u00a0 NUMBER(2)
                                                                          \n)
                                                                          \nCREATE UNIQUE INDEX unq_empno ON emp(empno);<\/div>\n
                                                                          — \u63a7\u5236\u6587\u4ef6;<\/div>\n
                                                                          LOAD DATA<\/div>\n
                                                                          INFILE ‘\/u01\/sqlldrdemo\/demo6.dat’
                                                                          \nREPLACE<\/div>\n
                                                                          INTO TABLE emp<\/div>\n
                                                                          SORTED INDEXES (unq_empno)
                                                                          \n(empno position(1:4),
                                                                          \nename position(6:15),
                                                                          \njob position(17:25),
                                                                          \nmgr position(27:30) nullif mgr=blanks,
                                                                          \nsal position(32:39) nullif sal=blanks,
                                                                          \ncomm position(41:48) nullif comm=blanks,
                                                                          \ndeptno position(50:51) nullif empno=blanks)<\/div>\n
                                                                          — \u6570\u636e\u6587\u4ef6;<\/div>\n
                                                                          7566 JONES\u00a0\u00a0\u00a0\u00a0\u00a0 MANAGER\u00a0\u00a0 7839\u00a0 3123.75\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 20
                                                                          \n7654 MARTIN\u00a0\u00a0\u00a0\u00a0 SALESMAN\u00a0 7698\u00a0 1312.50\u00a0 1400.00 30
                                                                          \n7658 CHAN\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ANALYST\u00a0\u00a0 7566\u00a0 3450.00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 20
                                                                          \n7782 CLARK\u00a0\u00a0\u00a0\u00a0\u00a0 MANAGER\u00a0\u00a0 7839\u00a0 2572.50\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10
                                                                          \n7839 KING\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PRESIDENT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5500.00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10
                                                                          \n7934 MILLER\u00a0\u00a0\u00a0\u00a0 CLERK\u00a0\u00a0\u00a0\u00a0 7782\u00a0\u00a0 920.00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10<\/div>\n
                                                                          — \u5bfc\u5165\u6570\u636e:sqlldr scott\/tiger control=\/u01\/sqlldrdemo\/demo6.ctl direct=y;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          — \u9a8c\u8bc1\u6570\u636e;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          <\/div>\n
                                                                          — EXAMPLE7:\u4ece\u4e00\u4e2a\u683c\u5f0f\u5316\u7684\u62a5\u8868\u4e2d\u62bd\u53d6\u6570\u636e\u5e76\u52a0\u8f7d;<\/div>\n
                                                                          — \u521b\u5efa\u6d4b\u8bd5\u8868;<\/div>\n
                                                                          CREATE TABLE EMP
                                                                          \n(
                                                                          \nEMPNO\u00a0\u00a0\u00a0 NUMBER(4) not null,
                                                                          \nENAME\u00a0\u00a0\u00a0 CHAR(10),
                                                                          \nJOB\u00a0\u00a0\u00a0\u00a0\u00a0 CHAR(9),
                                                                          \nMGR\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER(4),
                                                                          \nHIREDATE DATE,
                                                                          \nSAL\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER(7,2),
                                                                          \nCOMM\u00a0\u00a0\u00a0\u00a0 NUMBER(7,2),
                                                                          \nDEPTNO\u00a0\u00a0 NUMBER(2)
                                                                          \n);
                                                                          \nCREATE UNIQUE INDEX UNQ_EMPNO on EMP (EMPNO);<\/div>\n
                                                                          — \u6dfb\u52a0\u89e6\u53d1\u5668,\u8fd9\u4e00\u6b65\u662f\u5173\u952e;<\/div>\n
                                                                          CREATE OR REPLACE PACKAGE sqlloader AS
                                                                          \nlast_deptno\u00a0 NUMBER;
                                                                          \nlast_job\u00a0\u00a0\u00a0\u00a0 CHAR(9);
                                                                          \nlast_mgr\u00a0\u00a0\u00a0\u00a0 NUMBER;
                                                                          \nEND sqlloader;CREATE OR REPLACE TRIGGER sqlloader_emp_insert
                                                                          \nBEFORE INSERT ON emp
                                                                          \nFOR EACH ROW
                                                                          \nBEGIN
                                                                          \nIF :new.deptno IS NOT NULL THEN
                                                                          \nsqlloader.last_deptno := :new.deptno;\u00a0\u00a0 — save value for later use
                                                                          \nELSE
                                                                          \n:new.deptno := sqlloader.last_deptno;\u00a0\u00a0 — use last valid value
                                                                          \nEND IF;
                                                                          \nIF :new.job IS NOT NULL THEN
                                                                          \nsqlloader.last_job := :new.job;\u00a0\u00a0 — save value for later use
                                                                          \nELSE
                                                                          \n:new.job := sqlloader.last_job;\u00a0\u00a0 — use last valid value
                                                                          \nEND IF;
                                                                          \nIF :new.mgr IS NOT NULL THEN
                                                                          \nsqlloader.last_mgr := :new.mgr;\u00a0\u00a0 — save value for later use
                                                                          \nELSE
                                                                          \n:new.mgr := sqlloader.last_mgr;\u00a0\u00a0 — use last valid value
                                                                          \nEND IF;
                                                                          \nEND sqlloader_emp_insert;<\/p>\n<\/div>\n
                                                                          — \u63a7\u5236\u6587\u4ef6;<\/div>\n
                                                                          LOAD DATA
                                                                          \nINFILE ‘\/u01\/sqlldrdemo\/demo7.dat’<\/div>\n
                                                                          DISCARDFILE ‘\/u01\/sqlldrdemo\/demo7.dis’<\/div>\n
                                                                          APPEND
                                                                          \nINTO TABLE emp
                                                                          \nWHEN (57)=’.’
                                                                          \nTRAILING NULLCOLS
                                                                          \n(hiredate SYSDATE,
                                                                          \ndeptno\u00a0\u00a0 POSITION(1:2)\u00a0 INTEGER EXTERNAL(3)
                                                                          \nNULLIF deptno=BLANKS,
                                                                          \njob\u00a0\u00a0\u00a0\u00a0\u00a0 POSITION(7:14)\u00a0\u00a0 CHAR\u00a0 TERMINATED BY WHITESPACE
                                                                          \nNULLIF job=BLANKS\u00a0 “UPPER(:job)”,
                                                                          \nmgr\u00a0\u00a0\u00a0\u00a0\u00a0 POSITION(28:31)\u00a0 INTEGER EXTERNAL TERMINATED BY WHITESPACE
                                                                          \nNULLIF mgr=BLANKS,
                                                                          \nename\u00a0\u00a0\u00a0 POSITION (34:41) CHAR\u00a0 TERMINATED BY WHITESPACE
                                                                          \n“UPPER(:ename)”,
                                                                          \nempno\u00a0\u00a0\u00a0 INTEGER EXTERNAL\u00a0 TERMINATED BY WHITESPACE,
                                                                          \nsal\u00a0\u00a0\u00a0\u00a0\u00a0 POSITION(51)\u00a0 CHAR\u00a0 TERMINATED BY WHITESPACE
                                                                          \n“TO_NUMBER(:sal,’$99,999.99′)”,
                                                                          \ncomm\u00a0\u00a0\u00a0\u00a0 INTEGER EXTERNAL\u00a0 ENCLOSED BY ‘(‘ AND ‘%’
                                                                          \n“:comm * 100”
                                                                          \n)<\/div>\n
                                                                          — \u6570\u636e\u6587\u4ef6;<\/div>\n
                                                                          \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Today’s Newly Hired EmployeesDept\u00a0 Job\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Manager\u00a0\u00a0 MgrNo\u00a0 Emp Name\u00a0 EmpNo\u00a0 Salary\/Commission
                                                                          \n—-\u00a0 ——–\u00a0 ——–\u00a0 —–\u00a0 ——–\u00a0 —–\u00a0 —————–
                                                                          \n20\u00a0\u00a0\u00a0 Salesman\u00a0 Blake\u00a0\u00a0\u00a0\u00a0\u00a0 7698\u00a0 Shepard\u00a0\u00a0\u00a0 8061\u00a0 $1,600.00 (3%)
                                                                          \nFalstaff\u00a0\u00a0 8066\u00a0 $1,250.00 (5%)
                                                                          \nMajor\u00a0\u00a0\u00a0\u00a0\u00a0 8064\u00a0 $1,250.00 (14%)<\/p>\n

                                                                          30\u00a0\u00a0\u00a0 Clerk\u00a0\u00a0\u00a0\u00a0 Scott\u00a0\u00a0\u00a0\u00a0\u00a0 7788\u00a0 Conrad\u00a0\u00a0\u00a0\u00a0 8062\u00a0 $1,100.00
                                                                          \nFord\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7369\u00a0 DeSilva\u00a0\u00a0\u00a0 8063\u00a0\u00a0\u00a0 $800.00
                                                                          \nManager\u00a0\u00a0 King\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7839\u00a0 Provo\u00a0\u00a0\u00a0\u00a0\u00a0 8065\u00a0 $2,975.00<\/p>\n<\/div>\n

                                                                          — \u5bfc\u5165\u6570\u636e:sqlldr scott\/tiger control=\/u01\/sqlldrdemo\/demo7.ctl;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          — \u9a8c\u8bc1\u6570\u636e;<\/div>\n
                                                                          \"\"
                                                                          \n— \u67e5\u770b\u4e0d\u6ee1\u8db3\u7684\u8bb0\u5f55;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          — EXAMPLE8:\u52a0\u8f7d\u5206\u533a\u8868;<\/div>\n
                                                                          — \u521b\u5efa\u6d4b\u8bd5\u8868;<\/div>\n
                                                                          CREATE TABLE LINEITEM
                                                                          \n(
                                                                          \nL_ORDERKEY\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER,
                                                                          \nL_PARTKEY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER,
                                                                          \nL_SUPPKEY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER,
                                                                          \nL_LINENUMBER\u00a0\u00a0\u00a0 NUMBER,
                                                                          \nL_QUANTITY\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER,
                                                                          \nL_EXTENDEDPRICE NUMBER,
                                                                          \nL_DISCOUNT\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER,
                                                                          \nL_TAX\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER,
                                                                          \nL_RETURNFLAG\u00a0\u00a0\u00a0 CHAR(1),
                                                                          \nL_LINESTATUS\u00a0\u00a0\u00a0 CHAR(1),
                                                                          \nL_SHIPDATE\u00a0\u00a0\u00a0\u00a0\u00a0 DATE,
                                                                          \nL_COMMITDATE\u00a0\u00a0\u00a0 DATE,
                                                                          \nL_RECEIPTDATE\u00a0\u00a0 DATE,
                                                                          \nL_SHIPINSTRUCT\u00a0 CHAR(17),
                                                                          \nL_SHIPMODE\u00a0\u00a0\u00a0\u00a0\u00a0 CHAR(7),
                                                                          \nL_COMMENT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CHAR(43)
                                                                          \n)
                                                                          \nPARTITION by RANGE (L_SHIPDATE)
                                                                          \n(
                                                                          \nPARTITION SHIP_Q1 VALUES LESS THAN (TO_DATE(‘1996-04-01 00:00:00’, ‘YYYY-MM-DD HH24:MI:SS’)),
                                                                          \nPARTITION SHIP_Q2 VALUES LESS THAN (TO_DATE(‘1996-07-01 00:00:00’, ‘YYYY-MM-DD HH24:MI:SS’)),
                                                                          \nPARTITION SHIP_Q3 VALUES LESS THAN (TO_DATE(‘1996-10-01 00:00:00’, ‘YYYY-MM-DD HH24:MI:SS’)),
                                                                          \nPARTITION SHIP_Q4 VALUES LESS THAN (TO_DATE(‘1997-01-01 00:00:00’, ‘YYYY-MM-DD HH24:MI:SS’))
                                                                          \n);<\/div>\n
                                                                          — \u63a7\u5236\u6587\u4ef6;<\/div>\n
                                                                          LOAD DATA
                                                                          \nINFILE ‘\/u01\/sqlldrdemo\/demo8.dat’ “fix 129”<\/div>\n
                                                                          BADFILE ‘\/u01\/sqlldrdemo\/demo8.bad’<\/div>\n
                                                                          TRUNCATE<\/span>
                                                                          \nINTO TABLE lineitem
                                                                          \nPARTITION (ship_q1)<\/span>
                                                                          \n(l_orderkey\u00a0\u00a0\u00a0\u00a0\u00a0 position\u00a0\u00a0\u00a0 (1:6) char,
                                                                          \nl_partkey\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 position\u00a0\u00a0 (7:11) char,
                                                                          \nl_suppkey\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 position\u00a0 (12:15) char,
                                                                          \nl_linenumber\u00a0\u00a0\u00a0 position\u00a0 (16:16) char,
                                                                          \nl_quantity\u00a0\u00a0\u00a0\u00a0\u00a0 position\u00a0 (17:18) char,
                                                                          \nl_extendedprice position\u00a0 (19:26) char,
                                                                          \nl_discount\u00a0\u00a0\u00a0\u00a0\u00a0 position\u00a0 (27:29) char,
                                                                          \nl_tax\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 position\u00a0 (30:32) char,
                                                                          \nl_returnflag\u00a0\u00a0\u00a0 position\u00a0 (33:33) char,
                                                                          \nl_linestatus\u00a0\u00a0\u00a0 position\u00a0 (34:34) char,
                                                                          \nl_shipdate\u00a0\u00a0\u00a0\u00a0\u00a0 position\u00a0 (35:43) char,
                                                                          \nl_commitdate\u00a0\u00a0\u00a0 position\u00a0 (44:52) char,
                                                                          \nl_receiptdate\u00a0\u00a0 position\u00a0 (53:61) char,
                                                                          \nl_shipinstruct\u00a0 position\u00a0 (62:78) char,
                                                                          \nl_shipmode\u00a0\u00a0\u00a0\u00a0\u00a0 position\u00a0 (79:85) char,
                                                                          \nl_comment\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 position (86:128) char)<\/div>\n
                                                                          — \u6570\u636e\u6587\u4ef6;<\/div>\n
                                                                          \u00a0 \u00a0 \u00a01 151978511724386.60 7.04.0NO09-SEP-6412-FEB-9622-MAR-96DELIVER IN PERSON
                                                                          \nTRUCK\u00a0 iPBw4mMm7w7kQ zNPL i261OPP
                                                                          \n1 2731 73223658958.28.09.06NO12-FEB-9628-FEB-9620-APR-96TAKE BACK RETURN
                                                                          \nMAIL\u00a0\u00a0 5wM04SNyl0AnghCP2nx lAi
                                                                          \n1 3370 3713 810210.96 .1.02NO29-MAR-9605-MAR-9631-JAN-96TAKE BACK RETURN
                                                                          \nREG AIRSQC2C 5PNCy4mM
                                                                          \n1 5214 46542831197.88.09.06NO21-APR-9630-MAR-9616-MAY-96NONE
                                                                          \nAIR\u00a0\u00a0\u00a0 Om0L65CSAwSj5k6k
                                                                          \n1 6564\u00a0 6763246897.92.07.02NO30-MAY-9607-FEB-9603-FEB-96DELIVER IN PERSON
                                                                          \nMAIL\u00a0\u00a0 CB0SnyOL PQ32B70wB75k 6Aw10m0wh
                                                                          \n1 7403 160524 31329.6 .1.04NO30-JUN-9614-MAR-9601 APR-96NONE
                                                                          \nFOB\u00a0\u00a0\u00a0 C2gOQj OB6RLk1BS15 igN
                                                                          \n2 8819 82012441659.44\u00a0 0.08NO05-AUG-9609-FEB-9711-MAR-97COLLECT COD
                                                                          \nAIR\u00a0\u00a0\u00a0 O52M70MRgRNnmm476mNm
                                                                          \n3 9451 721230 41113.5.05.01AF05-SEP-9629-DEC-9318-FEB-94TAKE BACK RETURN
                                                                          \nFOB\u00a0\u00a0\u00a0 6wQnO0Llg6y
                                                                          \n3 9717\u00a0 1834440788.44.07.03RF09-NOV-9623-DEC-9315-FEB-94TAKE BACK RETURN
                                                                          \nSHIP\u00a0\u00a0 LhiA7wygz0k4g4zRhMLBAM
                                                                          \n3 9844 1955 6 8066.64.04.01RF28-DEC-9615-DEC-9314-FEB-94TAKE BACK RETURN
                                                                          \nREG AIR6nmBmjQkgiCyzCQBkxPPOx5j4hB 0lRywgniP1297<\/div>\n
                                                                          — \u5bfc\u5165\u6570\u636e:sqlldr scott\/tiger control=\/u01\/sqlldrdemo\/demo8.ctl;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          — \u9a8c\u8bc1\u6570\u636e;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          <\/div>\n
                                                                          — EXAMPLE9:\u52a0\u8f7dCLOB\u5217,\u4e3a\u6bcf\u4e2aCLOB\u5217\u51c6\u5907\u4e00\u4e2a\u6587\u672c\u6587\u4ef6;<\/div>\n
                                                                          — \u521b\u5efa\u6d4b\u8bd5\u8868;<\/div>\n
                                                                          CREATE TABLE EMP
                                                                          \n(
                                                                          \nEMPNO\u00a0\u00a0\u00a0 NUMBER(4) not null,
                                                                          \nENAME\u00a0\u00a0\u00a0 CHAR(10),
                                                                          \nJOB\u00a0\u00a0\u00a0\u00a0\u00a0 CHAR(9),
                                                                          \nMGR\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER(4),
                                                                          \nHIREDATE DATE,
                                                                          \nSAL\u00a0\u00a0\u00a0\u00a0\u00a0 NUMBER(7,2),
                                                                          \nCOMM\u00a0\u00a0\u00a0\u00a0 NUMBER(7,2),
                                                                          \nDEPTNO\u00a0\u00a0 NUMBER(2),
                                                                          \n\u00a0 RESUME\u00a0\u00a0 CLOB<\/span>
                                                                          \n)<\/div>\n
                                                                          \n
                                                                          — \u63a7\u5236\u6587\u4ef6;<\/div>\n
                                                                          LOAD DATA
                                                                          \nINFILE *
                                                                          \nINTO TABLE EMP
                                                                          \nREPLACE
                                                                          \nFIELDS TERMINATED BY ‘,’
                                                                          \n( EMPNO\u00a0\u00a0\u00a0 INTEGER EXTERNAL,
                                                                          \nENAME\u00a0\u00a0\u00a0 CHAR,
                                                                          \nJOB\u00a0\u00a0\u00a0\u00a0\u00a0 CHAR,
                                                                          \nMGR\u00a0\u00a0\u00a0\u00a0\u00a0 INTEGER EXTERNAL,
                                                                          \nSAL\u00a0\u00a0\u00a0\u00a0\u00a0 DECIMAL EXTERNAL,
                                                                          \nCOMM\u00a0\u00a0\u00a0\u00a0 DECIMAL EXTERNAL,
                                                                          \nDEPTNO\u00a0\u00a0 INTEGER EXTERNAL,
                                                                          \nRES_FILE FILLER CHAR,
                                                                          \n\u00a0 “RESUME” LOBFILE (RES_FILE) TERMINATED BY EOF NULLIF RES_FILE = ‘NONE’<\/span>
                                                                          \n)
                                                                          \nBEGINDATA
                                                                          \n7782,CLARK,MANAGER,7839,2572.50,,10,\/u01\/sqlldrdemo\/demo91.dat<\/span>
                                                                          \n7839,KING,PRESIDENT,,5500.00,,10,\/u01\/sqlldrdemo\/demo92.dat<\/div>\n
                                                                          7934,MILLER,CLERK,7782,920.00,,10,\/u01\/sqlldrdemo\/demo93.dat<\/div>\n
                                                                          7566,JONES,MANAGER,7839,3123.75,,20,\/u01\/sqlldrdemo\/demo94.dat<\/div>\n
                                                                          7499,ALLEN,SALESMAN,7698,1600.00,300.00,30,\/u01\/sqlldrdemo\/demo95.dat<\/div>\n
                                                                          7654,MARTIN,SALESMAN,7698,1312.50,1400.00,30,\/u01\/sqlldrdemo\/demo96.dat<\/div>\n
                                                                          7658,CHAN,ANALYST,7566,3450.00,,20,NONE<\/div>\n
                                                                          — \u5bfc\u5165\u6570\u636e:sqlldr scott\/tiger control=\/u01\/sqlldrdemo\/demo9.ctl;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          — \u9a8c\u8bc1\u6570\u636e;<\/div>\n

                                                                          \"\"<\/p>\n<\/div>\n

                                                                          <\/div>\n
                                                                          — EXAMPLE10:\u52a0\u8f7dREF\u5217\u548cARRAYs\u5217;<\/div>\n
                                                                          — EXAMPLE11:\u8f6c\u6362\u5b57\u7b26\u96c6,\u4f7f\u7528Unicode\u7f16\u7801\u52a0\u8f7d\u6570\u636e;<\/div>\n
                                                                          ————————- SQL*Loader\u7684\u4f8b\u5b50 ————————-<\/div>\n
                                                                          <\/div>\n
                                                                          ————————- \u5916\u90e8\u8868 ORACLE_LOADER\u5f15\u64ce\u7684\u4f8b\u5b50\u00a0————————-
                                                                          \n— \u624b\u52a8\u7f16\u5199\u5916\u90e8\u8868\u8bed\u6cd5;<\/div>\n
                                                                          1.\u521b\u5efaDIRECTORY\u5bf9\u8c61;<\/div>\n
                                                                          CREATE DIRECTORY ext_tab_dir AS ‘\/u01\/datafiles’;
                                                                          \nSELECT * FROM dba_directories WHERE directory_name = ‘EXT_TAB_DIR’;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          2.\u5bf9\u7528\u6237\u6388\u6743;<\/div>\n
                                                                          GRANT READ, WRITE ON DIRECTORY ext_tab_dir TO hr;
                                                                          \nSELECT * FROM dba_tab_privs WHERE table_name = ‘EXT_TAB_DIR’;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          3.\u6d4b\u8bd5\u6570\u636e\/u01\/datafiles\/emp.dat;<\/div>\n
                                                                          “56”,\u00a0\u00a0 “baker”,\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 “mary”, “f”,\u00a0\u00a0\u00a0 “01-09-2004”, “15-11-1980”
                                                                          \n“87”,\u00a0\u00a0 “roper”,\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 “lisa”, “m”,\u00a0\u00a0\u00a0 “01-06-1999”, “20-12-1970”<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          4.\u521b\u5efa\u5916\u90e8\u8868;<\/div>\n
                                                                          CREATE TABLE ext_tab_emp
                                                                          \n(
                                                                          \nID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 INTEGER,
                                                                          \nfirst_name\u00a0\u00a0\u00a0 VARCHAR2(20),
                                                                          \nlast_name\u00a0\u00a0\u00a0\u00a0 VARCHAR2(20),
                                                                          \nmale\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CHAR(1),
                                                                          \nbirthday\u00a0\u00a0\u00a0\u00a0\u00a0 DATE,
                                                                          \nhire_date\u00a0\u00a0\u00a0\u00a0 DATE
                                                                          \n)
                                                                          \nORGANIZATION EXTERNAL
                                                                          \n(
                                                                          \nTYPE ORACLE_LOADER
                                                                          \nDEFAULT DIRECTORY ext_tab_dir
                                                                          \nACCESS PARAMETERS
                                                                          \n(
                                                                          \nRECORDS DELIMITED BY NEWLINE
                                                                          \nBADFILE ‘EXT_TAB_DIR’:’emp.bad’
                                                                          \nDISCARDFILE ‘EXT_TAB_DIR’:’emp.dis’
                                                                          \nLOGFILE ‘EXT_TAB_DIR’:’emp.log’
                                                                          \nFIELDS TERMINATED BY “,” OPTIONALLY ENCLOSED BY ‘”‘<\/span>\u00a0LDRTRIM
                                                                          \nREJECT ROWS WITH ALL NULL FIELDS
                                                                          \n(
                                                                          \nID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CHAR(20) TERMINATED BY “,” OPTIONALLY ENCLOSED BY ‘”‘,
                                                                          \nfirst_name\u00a0\u00a0\u00a0 CHAR(20),
                                                                          \nlast_name\u00a0\u00a0\u00a0\u00a0 CHAR(20),
                                                                          \nmale\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 CHAR(1),
                                                                          \nbirthday\u00a0\u00a0\u00a0\u00a0\u00a0 CHAR(20) date_format DATE mask “DD-MM-YYYY”,
                                                                          \nhire_date\u00a0\u00a0\u00a0\u00a0 CHAR(20) date_format DATE mask “DD-MM-YYYY”
                                                                          \n)
                                                                          \n)
                                                                          \nLOCATION (’emp.dat’, ’emp1.dat’)
                                                                          \n)\u00a0PARALLEL 2<\/span>;
                                                                          \n5.\u67e5\u770b\u6570\u636e;<\/div>\n
                                                                          SELECT * FROM ext_tab_emp;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          6.\u67e5\u770b\u65e5\u5fd7\u53d1\u73b0,\u5982\u679c\u4f7f\u7528\u5e76\u884c\u7684\u8bdd\u4f1a\u6709\u591a\u4e2a\u7ebf\u7a0b\u540c\u65f6\u5de5\u4f5c,\u63d0\u9ad8\u6548\u7387;<\/div>\n
                                                                          <\/div>\n
                                                                          — \u4f7f\u7528SQL*LOADER\u5de5\u5177\u751f\u6210\u521b\u5efa\u5916\u90e8\u8868\u7684\u8bed\u6cd5;<\/div>\n
                                                                          1.\u6d4b\u8bd5\u6570\u636e\/u01\/datafiles\/car.dat;<\/div>\n
                                                                          Talbot,8\/18,4,01-MAR-1923,ohv,8,295.00
                                                                          \nTalbot,10\/23,4,12-MAR-1923,ohv,8.9,375.00
                                                                          \nTalbot,12\/30,6,23-JAN-1924,ohv,13.4,550.00
                                                                          \nSunbeam,14\/40,4,06-MAR-1924,ohv,13.9,895.00
                                                                          \nSunbeam,12\/30,4,08-FEB-1924,ohv,11.5,570.00
                                                                          \nSunbeam,20\/60,6,24-FEB-1924,ohv,20.9,950.00
                                                                          \nSunbeam,Twin Cam,6,11-MAR-1926,ohv,20.9,1125.00
                                                                          \nSunbeam,20,6,15-JUN-1927,ohv,20.9,750.00
                                                                          \nSunbeam,16,6,10-SEP-1927,ohv,16.9,550.00
                                                                          \nPeugeot,172,4,28-SEP-1928,sv,6.4,165.00
                                                                          \nAustin,7,4,29-JAN-1922,sv,7.2,225.00
                                                                          \nAustin,12,4,01-JAN-1922,sv,12.8,550.00
                                                                          \nAustin,20,4,04-JAN-1916,sv,22.4,616.00
                                                                          \nLanchester,40,6,08-JAN-1919,ohv,38.4,1875.00
                                                                          \nLanchester,21,6,16-JAN-1924,ohv,20.6,950.00
                                                                          \nVauxhall,30\/98,4,18-JAN-1919,sv,23.8,1475.00
                                                                          \nVauxhall,23\/60,4,27-JAN-1919,sv,22.4,1300.00<\/div>\n
                                                                          2.hr\u7528\u6237\u4e0b\u7684\u8868\u7ed3\u6784;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          3.\u63a7\u5236\u6587\u4ef6\/u01\/datafiles\/car.ctl;<\/div>\n
                                                                          LOAD DATA
                                                                          \nINFILE ‘\/u01\/datafiles\/car.dat’
                                                                          \nBADFILE ‘\/u01\/datafiles\/car.bad’
                                                                          \nDISCARDFILE ‘\/u01\/datafiles\/car.dsc’
                                                                          \nAPPEND
                                                                          \nINTO TABLE car
                                                                          \nFIELDS TERMINATED BY “,”
                                                                          \nTRAILING NULLCOLS
                                                                          \n(maker,
                                                                          \nmodel,
                                                                          \nno_cyl,
                                                                          \nfirst_built_date,
                                                                          \nengine,
                                                                          \nhp,
                                                                          \nprice)<\/div>\n
                                                                          4.\u751f\u6210\u521b\u5efa\u5916\u90e8\u8868\u7684\u811a\u672c;<\/div>\n
                                                                          sqlldr hr\/hr control=\/u01\/datafiles\/car.ctl\u00a0external_table=GENERATE_ONLY;<\/span><\/div>\n
                                                                          5.\u9002\u5f53\u4fee\u6539\u5373\u53ef;<\/div>\n
                                                                          conn hr\/hr
                                                                          \nCREATE TABLE car_ext
                                                                          \n(
                                                                          \n“MAKER” VARCHAR2(20),
                                                                          \n“MODEL” VARCHAR2(20),
                                                                          \n“NO_CYL” NUMBER,
                                                                          \n“FIRST_BUILT_DATE” DATE,
                                                                          \n“ENGINE” VARCHAR2(20),
                                                                          \n“HP” NUMBER(10,1),
                                                                          \n“PRICE” NUMBER(10,2)
                                                                          \n)
                                                                          \nORGANIZATION external
                                                                          \n(
                                                                          \nTYPE oracle_loader
                                                                          \nDEFAULT DIRECTORY\u00a0EXT_TAB_DIR — \u5fc5\u987b\u5927\u5199<\/span><\/div>\n
                                                                          \u00a0 ACCESS PARAMETERS
                                                                          \n(
                                                                          \nRECORDS DELIMITED BY NEWLINE CHARACTERSET US7ASCII
                                                                          \nBADFILE ‘EXT_TAB_DIR’:’car.bad’<\/div>\n
                                                                          \u00a0\u00a0\u00a0 DISCARDFILE ‘EXT_TAB_DIR’:’car.dsc’<\/div>\n
                                                                          \u00a0\u00a0\u00a0 LOGFILE ‘EXT_TAB_DIR’:’car.log’<\/div>\n
                                                                          \u00a0\u00a0\u00a0 READSIZE 1048576
                                                                          \nFIELDS TERMINATED BY “,” LDRTRIM
                                                                          \nMISSING FIELD VALUES ARE NULL
                                                                          \nREJECT ROWS WITH ALL NULL FIELDS
                                                                          \n(
                                                                          \n“MAKER” CHAR(255)\u00a0TERMINATED BY “,”,
                                                                          \n“MODEL” CHAR(255)\u00a0TERMINATED BY “,”,
                                                                          \n“NO_CYL” CHAR(255)\u00a0TERMINATED BY “,”,
                                                                          \n“FIRST_BUILT_DATE” CHAR(255)\u00a0TERMINATED BY “,”,
                                                                          \n“ENGINE” CHAR(255)\u00a0TERMINATED BY “,”,
                                                                          \n“HP” CHAR(255)\u00a0TERMINATED BY “,”,
                                                                          \n“PRICE” CHAR(255)\u00a0TERMINATED BY “,”
                                                                          \n)
                                                                          \n)
                                                                          \nlocation
                                                                          \n(
                                                                          \n‘car.dat’
                                                                          \n)
                                                                          \n)REJECT LIMIT UNLIMITED;<\/div>\n
                                                                          ————————- \u5916\u90e8\u8868 ORACLE_LOADER\u5f15\u64ce\u7684\u4f8b\u5b50\u00a0————————-<\/div>\n
                                                                          <\/div>\n
                                                                          ————————- \u5916\u90e8\u8868 ORACLE_DATAPUMP\u5f15\u64ce\u7684\u4f8b\u5b50\u00a0————————-<\/div>\n
                                                                          — \u5378\u8f7d\u6570\u636e;<\/div>\n
                                                                          1.\u76ee\u6807:\u5378\u8f7d\u6267\u884c\u67e5\u8be2\u7ed3\u679c\u96c6\u7684\u6570\u636e,\u5e76\u521b\u5efa\u5916\u90e8\u8868;<\/div>\n
                                                                          conn hr\/hr;<\/div>\n
                                                                          SELECT e.first_name, e.last_name, e.email, e.phone_number, d.department_name FROM EMPLOYEES e INNER JOIN DEPARTMENTS d ON e.department_id = d.department_id;<\/div>\n
                                                                          2.\u521b\u5efa\u76ee\u5f55\u5e76\u6388\u6743;<\/div>\n
                                                                          CREATE DIRECTORY\u00a0EXT_TAB_DIR AS ‘\/u01\/datafiles’;<\/div>\n
                                                                          GRANT READ, WRITE ON DIRECTORY\u00a0EXT_TAB_DIR\u00a0TO hr;<\/div>\n
                                                                          3.\u628a\u6570\u636e\u5bfc\u51fa\u4e3aEMP_DEPT.dmp\u6587\u4ef6,\u521b\u5efa\u5916\u90e8\u8868;<\/div>\n
                                                                          conn hr\/hr;<\/div>\n
                                                                          CREATE TABLE emp_dept_ext
                                                                          \nORGANIZATION EXTERNAL
                                                                          \n(
                                                                          \nTYPE ORACLE_DATAPUMP<\/span>
                                                                          \nDEFAULT DIRECTORY EXT_TAB_DIR\u00a0LOCATION (‘EMP_DEPT.dmp’)<\/div>\n
                                                                          )
                                                                          \nAS<\/div>\n
                                                                          SELECT e.first_name, e.last_name, e.email, e.phone_number, d.department_name FROM EMPLOYEES e INNER JOIN DEPARTMENTS d ON e.department_id = d.department_id;<\/div>\n
                                                                          \"\"<\/div>\n
                                                                          <\/div>\n
                                                                          — \u5bfc\u5165\u6570\u636e;<\/div>\n
                                                                          \u76ee\u6807:\u628a\u5bfc\u51fa\u7684\u6570\u636e\u5bfc\u5165\u5230hr\u7528\u6237\u4e0bt1\u8868\u4e2d;<\/div>\n
                                                                          conn hr\/hr;<\/div>\n
                                                                          CREATE TABLE t1
                                                                          \n(
                                                                          \nFIRST_NAME VARCHAR2(20),
                                                                          \nLAST_NAME VARCHAR2(25),
                                                                          \nEMAIL VARCHAR2(25),
                                                                          \nPHONE_NUMBER VARCHAR2(20),
                                                                          \nDEPARTMENT_NAME VARCHAR2(30)
                                                                          \n)
                                                                          \nORGANIZATION EXTERNAL
                                                                          \n(
                                                                          \nTYPE ORACLE_DATAPUMP<\/span>
                                                                          \nDEFAULT DIRECTORY EXT_TAB_DIR
                                                                          \nLOCATION (‘<\/span>EMP_DEPT.dmp’)<\/div>\n
                                                                          );<\/span><\/div>\n
                                                                          \"\"<\/span><\/div>\n
                                                                          ————————- \u5916\u90e8\u8868 ORACLE_DATAPUMP\u5f15\u64ce\u7684\u4f8b\u5b50\u00a0————————-<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                                                                          SQL*Loader\u5de5\u5177\u4e0e\u5916\u90e8\u8868 SQL*Loader: \u6982\u5ff5: \u53ef\u4ee5\u5728\u670d\u52a1\u5668\u7aef\u548c\u5ba2\u6237\u7aef\u64cd\u4f5c,\u6570\u636e\u53ef\u4ee5\u5b58\u653e\u5728\u670d […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[7,34],"class_list":["post-263","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-dw","tag-oracle"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=263"}],"version-history":[{"count":0,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/263\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=263"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}