{"id":15,"date":"2011-12-27T16:38:01","date_gmt":"2011-12-27T08:38:01","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=15"},"modified":"2013-12-31T15:38:05","modified_gmt":"2013-12-31T07:38:05","slug":"expimp%e5%92%8cexpdpimpdp%e5%b7%a5%e5%85%b7%e7%9a%84%e4%bd%bf%e7%94%a8","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=15","title":{"rendered":"\u5bfc\u5165\u5bfc\u51fa\u5de5\u517701–EXP\/IMP\u548cEXPDP\/IMPDP\u5de5\u5177\u7684\u4f7f\u7528"},"content":{"rendered":"
\n
EXP\/IMP\u548cEXPDP\/IMPDP\u5de5\u5177\u7684\u4f7f\u7528<\/div>\n
\n
    \n
  1. exp\/imp:\n
      \n
    1. \u6982\u5ff5:\n
        \n
      1. \u65e9\u671f\u7684oracle\u6570\u636e\u5bfc\u5165\u5bfc\u51fa\u5de5\u5177,\u6548\u7387\u6bd4\u8f83\u4f4e,\u53ef\u4ee5\u7528\u5728\u5c0f\u6570\u636e\u91cf\u7684\u60c5\u51b5\u4e0b;<\/li>\n
      2. \u53ef\u4ee5\u5728\u670d\u52a1\u5668\u7aef\u6216\u8005\u5ba2\u6237\u7aef\u64cd\u4f5c,\u6570\u636e\u53ef\u4ee5\u5b58\u653e\u5728\u670d\u52a1\u5668\u7aef\u6216\u8005\u5ba2\u6237\u7aef;<\/li>\n
      3. \u53ea\u80fd\u5bfc\u51fa\u5bfc\u51fa\u4e8c\u8fdb\u5236\u7684dump\u6587\u4ef6;<\/li>\n<\/ol>\n<\/li>\n
      4. \u4f7f\u7528exp\/imp\u5de5\u5177\u7684\u524d\u63d0:\n
          \n
        1. \u8fd0\u884ccatexp.sql\u6216\u8005catalog.sql\u811a\u672c;<\/li>\n
        2. \u4fdd\u8bc1\u6709\u8db3\u591f\u7684\u7a7a\u95f4;<\/li>\n
        3. \u4fdd\u8bc1\u6709\u8db3\u591f\u7684\u6743\u9650;\n
            \n
          1. \u5bf9\u4e8eexp:\u5fc5\u987b\u6709CREATE SESSION\u6743\u9650,\u5982\u679c\u8981\u5bfc\u51fa\u5176\u5b83\u7528\u6237\u4e0b\u7684\u8868,\u8fd8\u9700\u8981\u6709EXP_FULL_DATABASE\u89d2\u8272;<\/li>\n
          2. \u5bf9\u4e8eimp:\u5fc5\u987b\u6709CREATE SESSION\u6743\u9650,\u5982\u679c\u8981\u5bfc\u5165\u5176\u5b83\u7528\u6237\u521b\u5efa\u7684dump\u6587\u4ef6,\u8fd8\u9700\u8981\u6709IMP_FULL_DATABASE\u89d2\u8272;<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
          3. \u8c03\u7528exp\/imp\u7684\u65b9\u6cd5:\n
              \n
            1. \u547d\u4ee4\u884c\u63a5\u53e3,\u5e38\u7528;<\/span><\/li>\n
            2. \u4ea4\u4e92\u6a21\u5f0f;<\/li>\n
            3. \u4f7f\u7528\u53c2\u6570\u6587\u4ef6\u65b9\u5f0f,\u5e38\u7528;<\/span><\/li>\n
            4. \u4f7f\u7528OEM\u8c03\u7528;<\/li>\n<\/ol>\n<\/li>\n
            5. EXP\u5de5\u5177:\n
                \n
              1. \u7528\u9014:\n
                  \n
                1. \u5f52\u6863\u5386\u53f2\u6570\u636e;<\/li>\n
                2. \u4fdd\u5b58\u8868\u7684\u7ed3\u6784\u4fe1\u606f;<\/li>\n
                3. \u53ef\u4ee5\u5728\u4e0d\u540c\u7684\u670d\u52a1\u5668,\u4e0d\u540c\u7684\u5e73\u53f0\u4e0a\u4f20\u8f93\u6570\u636e;<\/li>\n
                4. \u4f20\u8f93\u8868\u7a7a\u95f4\u65f6\u4f7f\u7528;<\/li>\n<\/ol>\n<\/li>\n
                5. \u5bfc\u51fa\u7684\u56db\u79cd\u6a21\u5f0f:\n
                    \n
                  1. Table Mode:\u5305\u62ec\u8868\u7684\u5b9a\u4e49,\u6570\u636e,\u7528\u6237\u62e5\u6709\u7684\u8868\u548c\u7d22\u5f15,\u8868\u4e0a\u7684\u7ea6\u675f;<\/li>\n
                  2. User Mode:\u7528\u6237\u4e0b\u6240\u6709\u7684\u5bf9\u8c61;<\/li>\n
                  3. Tablespace Mode:\u67d0\u4e00\u4e2a\u8868\u7a7a\u95f4\u4e2d\u6240\u6709\u7684\u5bf9\u8c61,\u4e3b\u8981\u7528\u4e8e\u4f20\u8f93\u8868\u7a7a\u95f4<\/span>;<\/li>\n
                  4. Full Database Mode:\u4e0d\u63a8\u8350\u7684\u65b9\u5f0f,\u53ef\u4ee5\u4f7f\u7528rman\u66ff\u4ee3;<\/li>\n<\/ol>\n<\/li>\n
                  5. \u8bed\u6cd5:exp keyword=value1,value2,…,valuen;\n
                      \n
                    1. USERID=user\/pwd:\u7528\u6237\u540d\u548c\u5bc6\u7801;<\/li>\n
                    2. BUFFER:\u6307\u5b9a\u6570\u636e\u7f13\u51b2\u533a\u7684\u5927\u5c0f;<\/li>\n
                    3. FILE:\u5bfc\u51fa\u6587\u4ef6\u7684\u540d\u79f0;<\/li>\n
                    4. FILESIZE:\u6bcf\u4e2a\u5bfc\u51fa\u6587\u4ef6\u7684\u6700\u5927\u5927\u5c0f,\u5982\u679c\u5bfc\u51fa\u6587\u4ef6\u5f88\u5927,\u53ef\u4ee5\u9650\u5236\u6bcf\u4e2a\u6587\u4ef6\u7684\u5927\u5c0f,\u4f7f\u7528\u591a\u4e2a\u6587\u4ef6\u6765\u4fdd\u5b58\u6570\u636e;<\/li>\n
                    5. COMPRESS:\u662f\u5426\u4f7f\u7528\u538b\u7f29,\u9ed8\u8ba4\u4e3aY;<\/li>\n
                    6. GRANTS:\u662f\u5426\u5bfc\u51fa\u7528\u6237\u7684\u6743\u9650,\u9ed8\u8ba4\u4e3aY;<\/li>\n
                    7. ROWS:\u662f\u5426\u5bfc\u51fa\u8868\u7684\u8bb0\u5f55,\u9ed8\u8ba4\u4e3aY;<\/li>\n
                    8. INDEXES:\u662f\u5426\u5bfc\u51fa\u7d22\u5f15,\u9ed8\u8ba4\u4e3aY;<\/li>\n
                    9. TRIGGERS:\u662f\u5426\u5bfc\u51fa\u89e6\u53d1\u5668,\u9ed8\u8ba4\u4e3aY;<\/li>\n
                    10. CONSTRAINTS:\u662f\u5426\u5bfc\u51fa\u8868\u4e0a\u7684\u7ea6\u675f,\u9ed8\u8ba4\u4e3aY;<\/li>\n
                    11. DIRECT:\u662f\u5426\u4f7f\u7528\u76f4\u63a5\u8def\u5f84\u5bfc\u51fa,\u9ed8\u8ba4\u4e3aN,\u53ea\u80fd\u4f7f\u7528\u547d\u4ee4\u884c\u65b9\u5f0f,BUFFER\u53c2\u6570\u65e0\u6548;<\/li>\n
                    12. LOG:\u6307\u5b9a\u65e5\u5fd7\u6587\u4ef6;<\/li>\n
                    13. PARFILE:\u6307\u5b9a\u53c2\u6570\u6587\u4ef6;<\/li>\n
                    14. FULL:\u5bfc\u51fa\u6574\u4e2a\u6570\u636e\u5e93,\u5168\u5e93\u5bfc\u51fa\u65f6\u4f7f\u7528,\u4e0d\u5e38\u7528;<\/span><\/li>\n
                    15. OWNER:\u5217\u51fa\u8981\u5bfc\u51fa\u7684\u7528\u6237,\u5bfc\u51fa\u7528\u6237\u6a21\u5f0f;<\/span><\/li>\n
                    16. TABLES:\u5217\u51fa\u8981\u5bfc\u51fa\u7684\u8868\u7684\u540d\u79f0(schema.table:partition),\u652f\u6301\u901a\u914d\u7b26,\u5bfc\u51fa\u8868\u6a21\u5f0f;<\/span><\/li>\n
                    17. TABLESPACES:\u5217\u51fa\u8981\u5bfc\u51fa\u7684\u8868\u7a7a\u95f4,\u5bfc\u51fa\u8868\u7a7a\u95f4\u6a21\u5f0f;<\/span><\/li>\n
                    18. TRANSPORT_TABLESPACE:\u662f\u5426\u5bfc\u51fa\u8868\u7a7a\u95f4\u7684\u5143\u4fe1\u606f,\u9ed8\u8ba4\u4e3aN,\u4f20\u8f93\u8868\u7a7a\u95f4\u65f6\u4f7f\u7528;<\/span><\/li>\n
                    19. FEEDBACK=n:\u663e\u793a\u5bfc\u51fa\u7684\u8fdb\u5ea6,n\u6761\u8bb0\u5f55\u6253\u4e00\u4e2a\u70b9;<\/span><\/li>\n
                    20. QUERY:\u4f7f\u7528\u67e5\u8be2\u8bed\u53e5\u6765\u8fc7\u6ee4\u8981\u5bfc\u51fa\u7684\u8bb0\u5f55,eg:exp scott\/tiger TABLES=emp QUERY=\\”WHERE job=\\’SALESMAN\\’ and sal \\<1600\\”;<\/li>\n
                    21. CONSISTENT:\u662f\u5426\u5728\u5bfc\u51fa\u5f00\u59cb\u65f6\u8bbe\u7f6eSET TRANSACTION READ ONLY\u8bed\u53e5\u6765\u4fdd\u8bc1\u6574\u4e2a\u5bfc\u51fa\u671f\u95f4\u7684\u6570\u636e\u4e00\u81f4\u6027,\u9ed8\u8ba4\u4e3aN,\u63a8\u8350\u4e3aY;<\/span><\/li>\n
                    22. OBJECT_CONSISTENT:\u4fdd\u8bc1\u5bfc\u51fa\u67d0\u4e2a\u5bf9\u8c61\u671f\u95f4,\u8fd9\u4e2a\u5bf9\u8c61\u662f\u53ea\u8bfb\u7684,\u9ed8\u8ba4\u4e3aN,\u63a8\u8350\u4e3aY;<\/span><\/li>\n
                    23. FLASHBACK_SCN:\u4ece\u6307\u5b9a\u7684SCN\u5f00\u59cb\u5bfc\u51fa\u6570\u636e;<\/li>\n
                    24. FLASHBACK_TIME:\u4ece\u6307\u5b9a\u7684\u65f6\u95f4\u5f00\u59cb\u5bfc\u51fa\u6570\u636e,\u5185\u90e8\u4f1a\u8f6c\u5316\u4e3aSCN\u53f7\u7801,\u53ef\u4ee5\u4f7f\u7528TO_TIMESTAMP\u51fd\u6570\u6765\u8f6c\u5316\u5b57\u7b26\u4e32\u683c\u5f0f\u7684\u65f6\u95f4;<\/li>\n
                    25. STATISTICS:\u5f53\u5bfc\u51fa\u7684\u5bf9\u8c61\u88ab\u5bfc\u5165\u65f6,\u662f\u5426\u5206\u6790\u5bf9\u8c61,\u9ed8\u8ba4\u4e3aESTIMATE;<\/li>\n
                    26. RESUMABLE:\u5f53\u7a7a\u95f4\u4e0d\u8db3\u65f6\u662f\u5426\u4f1a\u6302\u8d77,\u7b49\u5f85\u5206\u914d\u7a7a\u95f4\u540e\u7ee7\u7eed\u5bfc\u51fa,\u9ed8\u8ba4\u662fN;<\/li>\n
                    27. RESUMABLE_NAME:\u6307\u5b9a\u6302\u8d77\u8bed\u53e5\u7684\u6807\u8bc6\u7b26;<\/li>\n
                    28. RESUMABLE_TIMEOUT:\u7b49\u5f85\u7684\u65f6\u95f4;<\/li>\n
                    29. RECORDLENGTH:\u8bb0\u5f55\u7684\u957f\u5ea6;<\/li>\n
                    30. INCTYPE:\u589e\u91cf\u5bfc\u51fa\u7c7b\u578b;<\/li>\n
                    31. RECORD:\u8ddf\u8e2a\u589e\u91cf\u5bfc\u51fa,\u9ed8\u8ba4\u4e3aY;<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
                    32. IMP\u5de5\u5177:\n
                        \n
                      1. \u7528\u9014:\n
                          \n
                        1. \u53ef\u4ee5\u6267\u884c\u5b8c\u5168\u5bfc\u5165\u6216\u8005\u7d2f\u8ba1\u5bfc\u5165;<\/li>\n
                        2. \u4e3b\u8981\u7528\u4e8e\u6062\u590d\u7528\u6237\u9519\u8bef;<\/li>\n<\/ol>\n<\/li>\n
                        3. \u5bfc\u5165\u4ecb\u7ecd:\n
                            \n
                          1. \u5148\u521b\u5efa\u8868\u7684\u5b9a\u4e49;<\/li>\n
                          2. \u7136\u540e\u4eceexp\u7684dmp\u6587\u4ef6\u4e2d\u62bd\u53d6\u6570\u636e;<\/li>\n
                          3. \u521b\u5efa\u7d22\u5f15;<\/li>\n
                          4. \u5bfc\u5165\u89e6\u53d1\u5668;<\/li>\n
                          5. \u5f00\u542f\u6570\u636e\u5b8c\u6574\u6027\u7ea6\u675f\u68c0\u67e5;<\/li>\n
                          6. \u521b\u5efa\u4f4d\u56fe\u7d22\u5f15,\u5e8f\u5217\u7b49\u5bf9\u8c61;<\/li>\n<\/ol>\n<\/li>\n
                          7. \u5bfc\u5165\u7684\u6a21\u5f0f:\n
                              \n
                            1. \u8868\u6a21\u5f0f;<\/li>\n
                            2. \u7528\u6237\u6a21\u5f0f;<\/li>\n
                            3. \u8868\u7a7a\u95f4\u6a21\u5f0f,\u7528\u6237\u53ef\u4f20\u8f93\u8868\u7a7a\u95f4;<\/li>\n
                            4. \u5168\u5e93\u6a21\u5f0f,\u4e0d\u5e38\u7528;<\/li>\n<\/ol>\n<\/li>\n
                            5. \u8bed\u6cd5:imp\u00a0keyword=value1,value2,…,valuen;\n
                              \n
                                \n
                              1. USERID=user\/pwd:\u7528\u6237\u540d\u548c\u5bc6\u7801;<\/li>\n
                              2. BUFFER:\u6307\u5b9a\u6570\u636e\u7f13\u51b2\u533a\u7684\u5927\u5c0f;<\/li>\n
                              3. FILE:\u8981\u5bfc\u5165\u7684\u6587\u4ef6\u7684\u540d\u79f0;<\/li>\n
                              4. FILESIZE:\u6bcf\u4e2a\u5bfc\u5165\u6587\u4ef6\u7684\u6700\u5927\u5927\u5c0f;<\/li>\n
                              5. SHOW:\u67e5\u770b\u8981\u5bfc\u5165\u7684dmp\u6587\u4ef6\u4e2d\u7684\u5185\u5bb9,\u5e76\u4e0d\u8fdb\u884c\u5bfc\u5165\u64cd\u4f5c;<\/span><\/li>\n
                              6. IGNORE:\u662f\u5426\u5ffd\u7565\u521b\u5efa\u5bf9\u8c61\u65f6\u7684\u9519\u8bef,\u9ed8\u8ba4\u4e3aN,\u8868\u793a\u51fa\u9519\u65f6\u8f93\u51fa\u9519\u8bef\u65e5\u5fd7;<\/span><\/li>\n
                              7. GRANTS:\u662f\u5426\u5bfc\u5165\u7528\u6237\u7684\u6743\u9650,\u9ed8\u8ba4\u4e3aY;<\/li>\n
                              8. ROWS:\u662f\u5426\u5bfc\u5165\u8868\u7684\u8bb0\u5f55,\u9ed8\u8ba4\u4e3aY;<\/li>\n
                              9. INDEXES:\u662f\u5426\u5bfc\u5165\u7d22\u5f15,\u9ed8\u8ba4\u4e3aY;<\/li>\n
                              10. TRIGGERS:\u662f\u5426\u5bfc\u5165\u89e6\u53d1\u5668,\u9ed8\u8ba4\u4e3aY;<\/li>\n
                              11. CONSTRAINTS:\u662f\u5426\u5bfc\u5165\u8868\u4e0a\u7684\u7ea6\u675f,\u9ed8\u8ba4\u4e3aY;<\/li>\n
                              12. LOG:\u6307\u5b9a\u65e5\u5fd7\u6587\u4ef6;<\/li>\n
                              13. PARFILE:\u6307\u5b9a\u53c2\u6570\u6587\u4ef6;<\/li>\n
                              14. FULL:\u5bfc\u51fa\u6574\u4e2a\u6570\u636e\u5e93,\u5168\u5e93\u5bfc\u51fa\u65f6\u4f7f\u7528,\u4e0d\u5e38\u7528;<\/span><\/li>\n
                              15. FROMUSER:\u5728\u7528\u6237\u6a21\u5f0f\u4e0b\u4f7f\u7528,\u6307\u5b9a\u8981\u5bfc\u5165\u7684\u7528\u6237;<\/span><\/li>\n
                              16. \n
                                TOUSER:\u4e0eFROMUSER\u8fde\u7528,\u6307\u5b9a\u8981\u8f6c\u53d8\u7684\u7528\u6237\u5217\u8868,\u5982fromuser=u1 touser=u2,\u5373\u628au1\u4e0b\u7684\u5bf9\u8c61\u521b\u5efa\u5728u2\u4e0b;\u8fd9\u4e2a\u7528\u6237\u5fc5\u987b\u9884\u5148\u5b58\u5728,\u5426\u5219\u4f1a\u62a5\u9519;<\/div>\n<\/li>\n
                              17. TABLES:\u5217\u51fa\u8981\u5bfc\u5165\u7684\u8868\u7684\u540d\u79f0(schema.table:partition);<\/span><\/li>\n
                              18. TABLESPACES:\u5217\u51fa\u8981\u5bfc\u5165\u7684\u8868\u7a7a\u95f4,\u5bfc\u51fa\u8868\u7a7a\u95f4\u6a21\u5f0f;<\/span><\/li>\n
                              19. TRANSPORT_TABLESPACE:\u662f\u5426\u5bfc\u5165\u8868\u7a7a\u95f4\u7684\u5143\u4fe1\u606f,\u9ed8\u8ba4\u4e3aN,\u4f20\u8f93\u8868\u7a7a\u95f4\u65f6\u4f7f\u7528;<\/span><\/li>\n
                              20. FEEDBACK=n:\u663e\u793a\u5bfc\u5165\u7684\u8fdb\u5ea6,n\u6761\u8bb0\u5f55\u6253\u4e00\u4e2a\u70b9;<\/span><\/li>\n
                              21. STATISTICS:\u5bfc\u5165\u5bf9\u8c61\u65f6,\u662f\u5426\u5206\u6790\u5bf9\u8c61,\u9ed8\u8ba4\u4e3aAWAYS;<\/li>\n
                              22. RESUMABLE:\u5f53\u7a7a\u95f4\u4e0d\u8db3\u65f6\u662f\u5426\u4f1a\u6302\u8d77,\u7b49\u5f85\u5206\u914d\u7a7a\u95f4\u540e\u7ee7\u7eed\u5bfc\u51fa,\u9ed8\u8ba4\u662fN;<\/li>\n
                              23. RESUMABLE_NAME:\u6307\u5b9a\u6302\u8d77\u8bed\u53e5\u7684\u6807\u8bc6\u7b26;<\/li>\n
                              24. RESUMABLE_TIMEOUT:\u7b49\u5f85\u7684\u65f6\u95f4;<\/li>\n
                              25. RECORDLENGTH:\u8bb0\u5f55\u7684\u957f\u5ea6;<\/li>\n
                              26. INCTYPE:\u589e\u91cf\u5bfc\u5165\u7c7b\u578b;<\/li>\n
                              27. COMMIT:\u6307\u5b9a\u662f\u5426\u5bfc\u5165\u4e00\u7ec4\u6570\u636e\u540e\u5c31\u63d0\u4ea4,\u9ed8\u8ba4\u4e3aN,\u8868\u793a\u6bcf\u5bfc\u5165\u4e00\u4e2a\u8868\u63d0\u4ea4\u4e00\u6b21;<\/span><\/li>\n
                              28. DESTROY:\u662f\u5426\u8986\u76d6\u8868\u7a7a\u95f4\u7684\u6570\u636e\u6587\u4ef6,\u9ed8\u8ba4\u4e3aN;<\/li>\n
                              29. INDEXFILE:\u628a\u8868\u548c\u7d22\u5f15\u5199\u5165\u6307\u5b9a\u7684\u6587\u4ef6\u4e2d;<\/li>\n
                              30. SKIP_UNUSABLE_INDEXES:\u8df3\u8fc7\u4e0d\u53ef\u7528\u7d22\u5f15\u7ef4\u62a4;<\/li>\n
                              31. TOID_NOVALIDATE:\u8df3\u8fc7\u6307\u5b9a\u7c7b\u578bID\u7684\u9a8c\u8bc1;<\/li>\n
                              32. COMPILE:\u662f\u5426\u9a6c\u4e0a\u7f16\u8bd1\u5bfc\u5165\u7684\u5305,\u5b58\u50a8\u8fc7\u7a0b\u548c\u51fd\u6570,\u9ed8\u8ba4\u4e3aY;\u5982\u679c\u4e3aN,\u8868\u793a\u7b2c\u4e00\u6b21\u4f7f\u7528\u65f6\u7f16\u8bd1;<\/li>\n
                              33. STREAMS_CONFIGURATION:\u5bfc\u5165stream\u7684\u4e00\u822c\u5143\u6570\u636e,\u9ed8\u8ba4\u4e3aY;<\/li>\n
                              34. STREAMS_INSTANTIATION:\u5bfc\u5165stream\u7684\u5b9e\u4f8b\u5143\u6570\u636e,\u9ed8\u8ba4\u4e3aN;<\/li>\n
                              35. DATAFILES:\u5f53TRANSPORT_TABLESPACE=Y\u65f6,\u4f7f\u7528\u6b64\u53c2\u6570\u4f20\u8f93\u5bfc\u5165\u4e0e\u6570\u636e\u5e93\u7684\u6570\u636e\u6587\u4ef6;<\/span><\/li>\n<\/ol>\n<\/div>\n<\/li>\n<\/ol>\n<\/li>\n
                              36. \u5b57\u7b26\u96c6\u8f6c\u6362:\n
                                  \n
                                1. \u6570\u636e\u4ece\u6e90\u6570\u636e\u5e93\u5bfc\u51fa,\u4f20\u8f93\u5230\u76ee\u6807\u670d\u52a1\u5668(ftp\/scp\/tape),\u7136\u540e\u5bfc\u5165\u5230\u76ee\u6807\u6570\u636e\u5e93\u4e00\u5171\u6709\u56db\u4e2a\u73af\u5883\u7684\u5b57\u7b26\u96c6:\n
                                    \n
                                  1. \u6e90\u6570\u636e\u5e93\u7684\u5b57\u7b26\u96c6\u548cNCHAR\u5b57\u7b26\u96c6;<\/li>\n
                                  2. \u6e90\u6570\u636e\u5e93\u670d\u52a1\u5668\u5bfc\u51fa\u65f6\u7684\u5b57\u7b26\u96c6(\u901a\u8fc7NLS_LANG\u73af\u5883\u53d8\u91cf\u8bbe\u7f6e);<\/li>\n
                                  3. \u76ee\u6807\u6570\u636e\u5e93\u670d\u52a1\u5668\u5bfc\u5165\u65f6\u7684\u5b57\u7b26\u96c6(\u901a\u8fc7NLS_LANG\u73af\u5883\u53d8\u91cf\u8bbe\u7f6e);<\/li>\n
                                  4. \u76ee\u6807\u6570\u636e\u5e93\u7684\u5b57\u7b26\u96c6\u548cNCHAR\u5b57\u7b26\u96c6;<\/li>\n
                                  5. \u6e90\u6570\u636e\u5e93\u548c\u76ee\u6807\u6570\u636e\u5e93\u7684\u5b57\u7b26\u96c6\u76f8\u540c,\u53ef\u80fd\u4f1a\u53d1\u751f3\u6b21\u5b57\u7b26\u96c6\u8f6c\u6362(\u5bfc\u51fa,\u4f20\u8f93,\u5bfc\u5165),\u5982\u679c\u4e0d\u76f8\u540c,\u4e00\u5b9a\u4f1a\u53d1\u751f\u8f6c\u6362\u6216\u8005\u5bfc\u5165\u9519\u8bef;<\/span><\/li>\n<\/ol>\n<\/li>\n
                                  6. \u67e5\u770b\u6570\u636e\u5e93\u7684\u5b57\u7b26\u96c6:select * from nls_database_parameters,\u53ef\u4ee5\u770b\u5f97\u51fa\u8bed\u8a00\u662fAMERICAN,\u533a\u57df\u662fAMERICA,\u5b57\u7b26\u96c6\u662fWE8ISO8859P1,NCHAR\u662fAL16UTF16; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\"\"<\/li>\n
                                  7. \u8bbe\u7f6e\u670d\u52a1\u5668\u7684\u73af\u5883\u53d8\u91cf:export NLS_LANG=NLS_LANGUAGE_NLS_TERRITORY.NLS_CHARACTERSET; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0<\/span>\"\"<\/li>\n
                                  8. \u67e5\u770b\u73b0\u6709\u7684dmp\u6587\u4ef6\u7684\u5b57\u7b26\u96c6:\u9996\u5148\u8bbe\u7f6e\u5f53\u524d\u670d\u52a1\u5668\u7684\u5b57\u7b26\u96c6\u4e0e\u6570\u636e\u5e93\u5b57\u7b26\u96c6\u4e00\u81f4,\u7136\u540e\u4f7f\u7528imp show=y\u547d\u4ee4,\u53ef\u4ee5\u67e5\u770b\u5230\u5bfc\u51fa\u65f6\u7684\u5b57\u7b26\u96c6; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\"\"<\/li>\n
                                  9. \u5b57\u7b26\u96c6\u6362\u6362\u7684\u62d3\u6251\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\"\"<\/li>\n<\/ol>\n<\/li>\n
                                  10. \u4f20\u8f93\u8868\u7a7a\u95f4\u7684\u539f\u7406:\n
                                      \n
                                    1. \u5982\u679c\u628a\u6570\u636e\u5bfc\u51fa\u518d\u5bfc\u51fa\u6548\u7387\u592a\u4f4e;<\/li>\n
                                    2. \u4f20\u8f93\u8868\u7a7a\u95f4\u7684\u505a\u6cd5\u662f:\u53ea\u5bfc\u51fa\u8868\u7a7a\u95f4\u7684\u5143\u4fe1\u606f,\u5e94\u7528\u5230\u76ee\u6807\u6570\u636e\u5e93,\u8868\u7a7a\u95f4\u7684\u6570\u636e\u4f7f\u7528\u6570\u636e\u5757\u62f7\u8d1d\u7684\u65b9\u5f0f;<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
                                    3. expdp\/impdp:\n
                                        \n
                                      1. \u6982\u5ff5:\n
                                          \n
                                        1. \u5e26\u6709\u6570\u636e\u6cf5\u7684oracle\u6570\u636e\u5bfc\u5165\u5bfc\u51fa\u5de5\u5177,\u6bd4\u8f83\u9ad8\u6548;<\/li>\n
                                        2. \u53ea\u80fd\u5728\u670d\u52a1\u5668\u7aef\u64cd\u4f5c,\u56e0\u4e3a\u9700\u8981\u4f7f\u7528DIRECTORY,\u6570\u636e\u53ea\u80fd\u5b58\u653e\u5728\u670d\u52a1\u5668;<\/li>\n
                                        3. \u53ea\u80fd\u5bfc\u51fa\u5bfc\u51fa\u4e8c\u8fdb\u5236\u7684dump\u6587\u4ef6;<\/li>\n
                                        4. \u4e3b\u8981\u662f\u8c03\u7528DBMS_DATAPUMP\u7684\u5305;<\/li>\n<\/ol>\n<\/li>\n
                                        5. expdp:\n
                                            \n
                                          1. \u8bed\u6cd5:expdp user\/pwd key=value;\n
                                              \n
                                            1. COMPRESSION:\u538b\u7f29\u6570\u636e;\n
                                                \n
                                              1. METADATA_ONLY:\u9ed8\u8ba4\u503c,\u53ea\u538b\u7f29\u5143\u6570\u636e;<\/li>\n
                                              2. NONE:\u4e0d\u538b\u7f29;<\/li>\n<\/ol>\n<\/li>\n
                                              3. CONTENT:\u6307\u5b9a\u8981\u5bfc\u51fa\u7684\u5185\u5bb9;<\/span>\n
                                                  \n
                                                1. ALL:\u5bfc\u51fa\u5bf9\u8c61\u7684\u5b9a\u4e49\u548c\u6570\u636e;<\/span><\/li>\n
                                                2. DATA_ONLY:\u5bfc\u51fa\u5bf9\u8c61\u7684\u6570\u636e;<\/span><\/li>\n
                                                3. METADATA_ONLY:\u5bfc\u51fa\u5bf9\u8c61\u7684\u5b9a\u4e49;<\/span><\/li>\n<\/ol>\n<\/li>\n
                                                4. DIRECTORY:\u7528\u4e8e\u5b58\u653edump\u6587\u4ef6\u548c\u65e5\u5fd7\u6587\u4ef6\u7684\u76ee\u5f55\u5bf9\u8c61;<\/span><\/li>\n
                                                5. DUMPFILE:\u5bfc\u51fa\u5230dump\u6587\u4ef6\u7684\u5217\u8868,\u683c\u5f0f\u4e3a:[DIRECTORY:]file_name,\u5982\u679c\u4e0d\u6307\u5b9a\u76ee\u5f55,\u5219\u4f7f\u7528DIRECTORY\u53c2\u6570\u6307\u5b9a\u7684\u76ee\u5f55\u5bf9\u8c61;<\/span><\/li>\n
                                                6. FILESIZE:\u5bfc\u51fa\u6587\u4ef6\u7684\u6700\u5927\u5927\u5c0f,\u5982\u679c\u5bfc\u51fa\u5bf9\u8c61\u6bd4\u8f83\u5927,\u53ef\u4ee5\u5206\u6210\u591a\u4e2a\u6587\u4ef6\u4fdd\u5b58;<\/span><\/li>\n
                                                7. LOGFILE:\u6307\u5b9a\u65e5\u5fd7\u6587\u4ef6\u7684\u540d\u79f0;<\/span><\/li>\n
                                                8. NOLOGFILE:\u9ed8\u8ba4\u4e3aN,\u7981\u6b62\u751f\u6210\u65e5\u5fd7\u6587\u4ef6;<\/li>\n
                                                9. PARFILE:\u6307\u5b9a\u53c2\u6570\u6587\u4ef6;<\/li>\n
                                                10. ENCRYPTION_PASSWORD:\u6307\u5b9a\u52a0\u5bc6\u5217\u7684\u5bc6\u7801;<\/li>\n
                                                11. ESTIMATE:\u6307\u5b9a\u4f30\u7b97\u88ab\u5bfc\u51fa\u8868\u6240\u5360\u78c1\u76d8\u7a7a\u95f4\u7684\u65b9\u6cd5;\n
                                                    \n
                                                  1. BLOCKS:\u9ed8\u8ba4\u503c,\u6309\u7167\u76ee\u6807\u5bf9\u8c61\u6240\u5360\u7528\u7684\u6570\u636e\u5757\u4e2a\u6570\u4e58\u4ee5\u6570\u636e\u5757\u5c3a\u5bf8\u4f30\u7b97\u5bf9\u8c61\u5360\u7528\u7684\u7a7a\u95f4;<\/li>\n
                                                  2. STATISTICS:\u636e\u6700\u8fd1\u7edf\u8ba1\u503c\u4f30\u7b97\u5bf9\u8c61\u5360\u7528\u7a7a\u95f4;<\/li>\n<\/ol>\n<\/li>\n
                                                  3. ESTIMATE_ONLY:\u9ed8\u8ba4\u503c\u4e3aN,\u5982\u679c\u4e3aY,\u5219\u53ea\u4f30\u7b97\u5bfc\u51fa\u4f5c\u4e1a\u5360\u7528\u7684\u78c1\u76d8\u7a7a\u95f4\u800c\u4e0d\u4f1a\u6267\u884c;<\/li>\n
                                                  4. INCLUDE:\u6307\u5b9a\u8981\u5305\u542b\u7684\u5bf9\u8c61\u7c7b\u578b\u548c\u5bf9\u8c61,\u683c\u5f0f:object_type[:name_clause];\n
                                                      \n
                                                    1. name_clause:\u5fc5\u987b\u662f\u7528\u53cc\u5f15\u53f7\u5f15\u8d77\u6765\u7684,\u56e0\u4e3a\u91cc\u9762\u7684\u6bcf\u4e2a\u5bf9\u8c61\u9700\u8981\u4f7f\u7528\u5355\u5f15\u53f7;<\/li>\n
                                                    2. \u4f7f\u7528LIKE\u5b50\u53e5:include=TABLE:”LIKE ‘B%'”,\u4f46\u662f\u4e0d\u80fd\u4f7f\u7528NOT LIKE;<\/li>\n
                                                    3. \u4f7f\u7528IN\u5b50\u53e5:include=TABLE:”IN (‘T1’, ‘T2’)”;<\/li>\n
                                                    4. \u4f7f\u7528<>\u5b50\u53e5:include=TABLE:”<> (‘T1’)”,\u4f46\u662f\u4e0d\u80fd\u4f7f\u7528[=];<\/li>\n
                                                    5. \u53ea\u5bfc\u51fa\u5b58\u50a8\u8fc7\u7a0b:indlude=PROCEDURE;<\/li>\n<\/ol>\n<\/li>\n
                                                    6. EXCLUDE:\u6392\u9664\u6307\u5b9a\u7684\u5bf9\u8c61\u7c7b\u578b\u6216\u8005\u5bf9\u8c61,\u683c\u5f0f\u4e0eINCLUDE\u76f8\u4f3c;<\/li>\n
                                                    7. FLASHBACK_SCN:\u6307\u5b9aSCN\u4ee5\u540e\u7684\u6570\u636e;<\/li>\n
                                                    8. FLASHBACK_TIME:\u6307\u5b9a\u67d0\u4e2a\u65f6\u95f4\u4ee5\u540e\u7684\u6570\u636e,\u5185\u90e8\u8f6c\u5316\u4e3a\u6700\u8fd1\u7684SCN\u53f7;<\/li>\n
                                                    9. JOB_NAME:\u628a\u5bfc\u51fa\u7684\u4efb\u52a1\u521b\u5efa\u4e00\u4e2aJOB,\u6307\u5b9a\u4f5c\u4e1a\u7684\u540d\u79f0;<\/span><\/li>\n
                                                    10. ATTACH:\u4f7f\u5f53\u524d\u4f1a\u8bdd\u4e0e\u5df2\u5b58\u5728\u7684\u5bfc\u51fa\u4f5c\u4e1a\u5efa\u7acb\u8054\u7cfb,\u7136\u540e\u6267\u884c\u4ea4\u4e92\u547d\u4ee4,eg:expdp user\/pwd ATTACH=[schema_name.]job_name;<\/span><\/li>\n
                                                    11. NETWORK_LINK:\u6307\u5b9a\u76ee\u6807\u6570\u636e\u5e93\u5230\u6e90\u6570\u636e\u5e93\u7684Database Link,\u7528\u4e8e\u5c06\u8fdc\u7a0b\u6570\u636e\u5bf9\u8c61\u5bfc\u51fa\u5230\u672c\u5730\u7684\u60c5\u51b5;<\/span>\n
                                                        \n
                                                      1. \u56e0\u4e3aexpdp\u662f\u670d\u52a1\u5668\u7aef\u5de5\u5177,\u5982\u679cexpdp user\/pwd@net_name\u7684\u8bdd\u5bfc\u51fa\u7684\u6587\u4ef6\u5b58\u653e\u5728\u670d\u52a1\u5668\u7aef;<\/span><\/li>\n
                                                      2. \u5982\u679cexpdp user\/pwd NETWORK_LINK=dblink_name\u7684\u8bdd,\u5219\u6570\u636e\u5bfc\u51fa\u5230\u672c\u5730;<\/span><\/li>\n
                                                      3. \u5bfc\u51fa\u7684\u65e5\u5fd7\u6587\u4ef6\u4e0d\u80fd\u653e\u5230ASM\u4e0a,\u53ea\u80fd\u5b58\u653e\u6570\u636e\u6587\u4ef6;<\/span><\/li>\n<\/ol>\n<\/li>\n
                                                      4. PARALLEL:\u6307\u5b9a\u5bfc\u51fa\u7684\u5e76\u884c\u5ea6,\u9ed8\u8ba4\u4e3a1,\u63a8\u8350\u5e76\u884c\u5ea6\u7b49\u4e8e\u7ed9\u5b9a\u7684\u6587\u4ef6\u4e2a\u6570\u7684\u6574\u6570\u500d,\u800c\u4e14\u8981\u5c0f\u4e8eCPU\u4e2a\u6570*2;<\/li>\n
                                                      5. QUERY:\u6307\u5b9a\u8fc7\u6ee4\u5bfc\u51fa\u6570\u636e\u7684\u6761\u4ef6,\u683c\u5f0f:[schmea].[table_name:]query_clause;<\/li>\n
                                                      6. SAMPLE:\u5bfc\u51fa\u6570\u636e\u7684\u767e\u5206\u6bd4;<\/li>\n
                                                      7. FULL:\u9ed8\u8ba4\u4e3aN,\u6570\u636e\u5e93\u5168\u5e93\u5bfc\u51fa;<\/span><\/li>\n
                                                      8. SCHEMAS:\u5bfc\u51fa\u6570\u636e\u7684schema\u5217\u8868,\u9ed8\u8ba4\u4e3a\u5f53\u524dschema;<\/span><\/li>\n
                                                      9. TABLES:\u6307\u5b9a\u8981\u5bfc\u51fa\u7684\u8868\u7684\u5217\u8868,\u683c\u5f0f\u4e3a:[schema_name.]table_name[:partition_name];<\/span><\/li>\n
                                                      10. TABLESPACES:\u6307\u5b9a\u8981\u5bfc\u51fa\u7684\u8868\u7a7a\u95f4;<\/span><\/li>\n
                                                      11. TRANSPORT_FULL_CHECK:\u9ed8\u8ba4\u4e3aY,\u68c0\u67e5\u8981\u4f20\u8f93\u7684\u8868\u7a7a\u95f4\u662f\u5426\u662f\u81ea\u5305\u542b\u7684;<\/span><\/li>\n
                                                      12. TRANSPORT_TABLESPACES:\u6307\u5b9a\u8981\u8981\u5bfc\u51fa\u5143\u6570\u636e\u7684\u8868\u7a7a\u95f4\u7684\u5217\u8868,\u4e3b\u8981\u7528\u4e8e\u4f20\u8f93\u8868\u7a7a\u95f4\u7684\u60c5\u51b5;<\/span><\/li>\n
                                                      13. VERSION:\u6307\u5b9a\u5bfc\u51fa\u5bf9\u8c61\u7684\u6570\u636e\u5e93\u7684\u7248\u672c;\n
                                                          \n
                                                        1. COMPATIBLE:\u9ed8\u8ba4\u503c;<\/li>\n
                                                        2. LATEST:\u4f1a\u6839\u636e\u6570\u636e\u5e93\u7684\u5b9e\u9645\u7248\u672c\u751f\u6210\u5bf9\u8c61\u5143\u6570\u636e;<\/li>\n
                                                        3. version_string\u7528\u4e8e\u6307\u5b9a\u6570\u636e\u5e93\u7248\u672c\u5b57\u7b26\u4e32;<\/li>\n<\/ol>\n<\/li>\n
                                                        4. STATUS:\u7528\u4e8e\u6307\u5b9a\u663e\u793a\u5f53\u524d\u5bfc\u51fa\u4f5c\u4e1a\u6267\u884c\u72b6\u6001\u7684\u95f4\u9694,eg:STATUS[=interval],\u9ed8\u8ba4\u4e3a0;<\/li>\n<\/ol>\n<\/li>\n
                                                        5. \u4ea4\u4e92\u5f0f\u547d\u4ee4:\n
                                                            \n
                                                          1. ADD_FILE:\u6dfb\u52a0\u4e00\u4e2a\u5bfc\u51fa\u6587\u4ef6;<\/li>\n
                                                          2. FILESIZE:\u6307\u5b9a\u6dfb\u52a0\u6587\u4ef6\u7684\u6587\u4ef6\u5927\u5c0f;<\/li>\n
                                                          3. HELP:\u5e2e\u52a9;<\/li>\n
                                                          4. PARALLEL:\u6539\u53d8\u5bfc\u51fa\u4f5c\u4e1a\u7684\u5e76\u884c\u5ea6,PARALLEL=<number of workers>;<\/li>\n
                                                          5. \u8fdb\u5165expdp\u7684\u4f5c\u4e1a\u4f1a\u8bdd:expdp user\/pwd attch=schema.job_name;<\/li>\n
                                                          6. START_JOB:\u5f00\u59cb\/\u6062\u590d\u4f5c\u4e1a\u7684\u6267\u884c;<\/li>\n
                                                          7. STOP_JOB:\u6682\u505c\u4f5c\u4e1a,\u4f7f\u7528STOP_JOB=IMMEDIATE\u8868\u793a\u7acb\u5373\u505c\u6b62;<\/li>\n
                                                          8. EXIT_CLIENT(CTRL+C):\u9000\u51fa\u5f53\u524dsession,\u8ba9\u4f5c\u4e1a\u7ee7\u7eed\u8fd0\u884c;<\/li>\n
                                                          9. CONTINUE_CLIENT:\u5207\u6362\u5230\u65e5\u5fd7\u6a21\u5f0f,\u4f5c\u4e1a\u5728\u7a7a\u95f2\u65f6\u4f1a\u91cd\u65b0\u8fd0\u884c;<\/li>\n
                                                          10. KILL_JOB:\u65ad\u5f00\u4e0e\u4f5c\u4e1a\u7684\u8fde\u63a5,\u5e76\u505c\u6b62\u4f5c\u4e1a,\u540c\u65f6\u5220\u9664dmp\u6587\u4ef6;<\/li>\n
                                                          11. STATUS:\u7528\u4e8e\u6307\u5b9a\u663e\u793a\u5f53\u524d\u5bfc\u51fa\u4f5c\u4e1a\u6267\u884c\u72b6\u6001\u7684\u95f4\u9694,eg:STATUS[=interval],\u9ed8\u8ba4\u4e3a0;<\/li>\n<\/ol>\n<\/li>\n
                                                          12. \u5bfc\u51fa\u7684\u6b65\u9aa4:\n
                                                              \n
                                                            1. \u521b\u5efa\u76ee\u5f55\u5bf9\u8c61:CREATE DIRECTORY ext_tab_dir as ‘\/u01\/datafiles\/’; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\"\"<\/li>\n
                                                            2. \u6388\u6743:GRANT READ, WRITE ON DIRECTORY ext_tab_dir TO hr; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\"\"\"\"<\/li>\n
                                                            3. \u6267\u884c\u5bfc\u51fa:expdp hr\/hr directory=ext_tab_dir schemas=hr dumpfile=expdp_hr1.dmp,expdp_hr2.dmp logfile=expdp_hr.log parallel=2 job_name=’job_expdp_hr’;(\u5982\u679c\u4e0d\u6307\u5b9aJOB_NAME\u7684\u8bdd,\u4f1a\u751f\u6210\u4e00\u4e2a\u7cfb\u7edf\u7684\u540d\u79f0,\u63a8\u8350\u6307\u5b9a;) \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0\"\"<\/li>\n<\/ol>\n<\/li>\n
                                                            4. \u5bfc\u51fa\u7684\u5404\u79cd\u573a\u666f:\n
                                                                \n
                                                              1. \u6309\u8868\u6a21\u5f0f\u5bfc\u51fa:expdp hr\/hr\u00a0directory=ext_tab_dir\u00a0tables=jobs,countries<\/span>\u00a0dumpfile=expdp_table1.dmp,expdp_table2.dmp\u00a0logfile=expdp_table.log\u00a0parallel=2\u00a0job_name=’job_expdp_table’;<\/li>\n
                                                              2. \u6309\u67e5\u8be2\u6761\u4ef6\u5bfc\u51fa:expdp\u00a0hr\/hr\u00a0directory=ext_tab_dir\u00a0tables=jobs query='”where rownum<11″<\/span>‘\u00a0dumpfile=expdp_hr_jobs.dmp logfile=expdp_hr_jobs.log job_name=’job_expdp_hr_jobs’;<\/li>\n
                                                              3. \u6309\u8868\u7a7a\u95f4\u5bfc\u51fa:expdp system\/oracle directory=ext_tab_dir\u00a0tablespaces=USERS<\/span>\u00a0dumpfile=expdp_ts_users1.dmp,expdp_ts_users2.dmp logfile=expdp_ts_users.log\u00a0parallel=2\u00a0job_name=’job_expdp_ts_users’;<\/li>\n
                                                              4. \u5bfc\u51fa\u65b9\u6848:expdp hr\/hr directory=ext_tab_dir\u00a0schemas=hr<\/span>\u00a0dumpfile=expdp_hr1.dmp,expdp_hr2.dmp logfile=expdp_hr.log parallel=2 job_name=’job_expdp_hr’;<\/li>\n
                                                              5. \u5bfc\u51fa\u6574\u4e2a\u6570\u636e\u5e93:expdp\u00a0hr\/hr\u00a0directory=ext_tab_dir\u00a0dumpfile=full.dmp\u00a0full=y<\/span>\u00a0logfile=full.log job_name=’job_expdp_full’;<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
                                                              6. impdp:\n
                                                                  \n
                                                                1. \u8bed\u6cd5:impdp user\/pwd key=value;\n
                                                                    \n
                                                                  1. REMAP_DATAFILE:\u91cd\u65b0\u5b9a\u4e49DDL\u8bed\u53e5\u4e2d\u5f15\u7528\u7684\u6570\u636e\u6587\u4ef6,\u7528\u4e8e\u5c06\u6e90\u6570\u636e\u6587\u4ef6\u8f6c\u53d8\u4e3a\u76ee\u6807\u6570\u636e\u6587\u4ef6\u540d,\u5728\u4e0d\u540c\u5e73\u53f0\u4e4b\u95f4\u642c\u79fb\u8868\u7a7a\u95f4\u65f6\u4f7f\u7528,eg:REMAP_DATAFIEL=source_datafie:target_datafile;<\/li>\n
                                                                  2. REUSE_DATAFILES:\u9ed8\u8ba4\u662fN,\u6307\u5b9a\u662f\u5426\u8986\u76d6\u5df2\u5b58\u5728\u7684\u6570\u636e\u6587\u4ef6;<\/li>\n
                                                                  3. REMAP_SCHEMA:\u5c06\u6e90schema\u7684\u5bf9\u8c61\u8f6c\u6362\u5230\u76ee\u6807schema\u4e2d,eg:REMAP_SCHEMA=source_schema:target_schema;<\/li>\n
                                                                  4. REMAP_TABLESPACE:\u5c06\u6e90\u8868\u7a7a\u95f4\u7684\u5bf9\u8c61\u5bfc\u5165\u5230\u76ee\u6807\u8868\u7a7a\u95f4\u4e2d,eg:REMAP_TABLESPACE=source_tablespace:target_tablespace;<\/li>\n
                                                                  5. SKIP_UNUSABLE_INDEXES:\u8df3\u8fc7\u4e0d\u53ef\u4f7f\u7528\u7684\u7d22\u5f15,\u9ed8\u8ba4\u4e3aN;<\/li>\n
                                                                  6. SQLFILE:\u628a\u5bfc\u51fa\u7684dump\u6587\u4ef6\u4e2d\u6240\u6709\u5bf9\u8c61\u7684DDL\u8bed\u53e5\u5199\u5230sql\u811a\u672c\u4e2d,eg:SQLFILE=[directory_object:]file_name;<\/span><\/li>\n
                                                                  7. STREAMS_CONFIGURATION:\u662f\u5426\u5bfc\u5165\u6d41\u5143\u6570\u636e\u5e93,\u9ed8\u8ba4\u662fY;<\/li>\n
                                                                  8. TABLE_EXISTS_ACTION:\u5f53\u8868\u5df2\u7ecf\u5b58\u5728\u65f6,\u5bfc\u5165\u4f5c\u4e1a\u8981\u6267\u884c\u7684\u64cd\u4f5c;\n
                                                                      \n
                                                                    1. SKIP:\u9ed8\u8ba4\u8df3\u8fc7;<\/li>\n
                                                                    2. APPEND:\u8ffd\u52a0\u6570\u636e;<\/li>\n
                                                                    3. REPLACE:\u5220\u9664\u8868\u91cd\u5efa,\u7136\u540e\u518d\u63d2\u5165;<\/li>\n
                                                                    4. TRUNCATE:\u622a\u65ad;<\/li>\n<\/ol>\n<\/li>\n
                                                                    5. TRANSFORM:\u6307\u5b9a\u662f\u5426\u4fee\u6539\u5efa\u7acb\u5bf9\u8c61\u7684DDL\u8bed\u53e5,eg:TRANSFORM=transform_name:value[:object_type];\n
                                                                        \n
                                                                      1. Transform_name:\u7528\u4e8e\u6307\u5b9a\u8f6c\u6362\u540d:\n
                                                                          \n
                                                                        1. SEGMENT_ATTRIBUTES\u7528\u4e8e\u6807\u8bc6\u6bb5\u5c5e\u6027(\u7269\u7406\u5c5e\u6027,\u5b58\u50a8\u5c5e\u6027,\u8868\u7a7a\u95f4,\u65e5\u5fd7\u7b49\u4fe1\u606f);<\/li>\n
                                                                        2. STORAGE\u7528\u4e8e\u6807\u8bc6\u6bb5\u5b58\u50a8\u5c5e\u6027;<\/li>\n
                                                                        3. OID;<\/li>\n
                                                                        4. PCTSPACE;<\/li>\n<\/ol>\n<\/li>\n
                                                                        5. value:\u7528\u4e8e\u6307\u5b9a\u662f\u5426\u5305\u542b\u6bb5\u5c5e\u6027\u6216\u6bb5\u5b58\u50a8\u5c5e\u6027;<\/li>\n
                                                                        6. object_type\u7528\u4e8e\u6307\u5b9a\u5bf9\u8c61\u7c7b\u578b;<\/li>\n<\/ol>\n<\/li>\n
                                                                        7. TRANSPORT_DATAFILES:\u7528\u6237\u6307\u5b9a\u4f20\u8f93\u8868\u7a7a\u95f4\u65f6\u88ab\u5bfc\u5165\u8868\u7a7a\u95f4\u5bf9\u5e94\u7684\u6570\u636e\u6587\u4ef6;<\/li>\n
                                                                        8. TRANSPORT_TABLESPACES:\u5217\u51fa\u4f20\u8f93\u8868\u7a7a\u95f4\u7684\u5143\u6570\u636e\u7684\u8868\u7a7a\u95f4\u7684\u5217\u8868,\u53ea\u662f\u5728NETWORK_LINK\u6a21\u5f0f\u4e0b\u64cd\u4f5c;<\/li>\n<\/ol>\n<\/li>\n
                                                                        9. \u4ea4\u4e92\u5f0f\u547d\u4ee4:\u4e0eexpdp\u4e00\u81f4;<\/li>\n<\/ol>\n<\/li>\n
                                                                        10. \u5bfc\u5165\u7684\u5404\u79cd\u573a\u666f:\n
                                                                            \n
                                                                          1. \u6309\u8868\u5bfc\u5165,\u5c06hr\u7528\u6237\u4e0b\u4fe9\u4e2a\u8868\u5bfc\u5165\u5230scott\u7528\u6237\u4e0b:impdp hr\/hr directory=ext_tab_dir\u00a0tables=jobs,countries<\/span>\u00a0dumpfile=expdp_table1.dmp,expdp_table2.dmp\u00a0remap_schema=hr:scott<\/span>\u00a0logfile=impdp_table.log\u00a0parallel=2\u00a0job_name=’job_impdp_table’;<\/li>\n
                                                                          2. \u6309\u7528\u6237\u5bfc\u5165(\u5982\u679c\u7528\u6237\u5b58\u5728\u5219\u76f4\u63a5\u5bfc\u5165,\u8981\u6709\u76ee\u5f55\u5bf9\u8c61\u7684\u6743\u9650,\u5982\u679c\u4e0d\u5b58\u5728\u4f7f\u7528dba\u5bfc\u5165):impdp system\/oracle\u00a0directory=ext_tab_dir\u00a0schemas=hr dumpfile=expdp_hr1.dmp,expdp_hr2.dmp logfile=impdp_hr.log parallel=2\u00a0job_name=’job_impdp_hr’;<\/li>\n
                                                                          3. \u5728\u5ba2\u6237\u7aef\u6267\u884cexpdp\u547d\u4ee4\u628a\u5bfc\u51fa\u6587\u4ef6\u5b58\u653e\u5728\u670d\u52a1\u5668\u7aef;<\/li>\n
                                                                          4. \u5728\u5ba2\u6237\u7aef\u6267\u884cexpdp\u547d\u4ee4\u628a\u5bfc\u5165\u6587\u4ef6\u5b58\u653e\u5728\u5ba2\u6237\u7aef;<\/li>\n
                                                                          5. \u6e90\u6570\u636e\u5e93\u7684\u6570\u636e\u76f4\u63a5\u5bfc\u5165\u5230\u76ee\u6807\u6570\u636e\u5e93,\u4e2d\u95f4\u4e0d\u4ea7\u751f\u4efb\u4f55\u7684dump\u6587\u4ef6;<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/div>\n
                                                                            <\/div>\n
                                                                            ——————————— \u67e5\u770bDIRECTORY\u5bf9\u8c61\u7684\u6743\u9650 ———————————<\/div>\n
                                                                            SELECT d.directory_name, d.directory_path, p.grantee, p.privilege
                                                                            \nFROM user_tab_privs p
                                                                            \nINNER JOIN dba_directories d ON p.table_name = d.directory_name AND
                                                                            \nd.directory_name = ‘EXT_TAB_DIR’;<\/div>\n
                                                                            ——————————— \u67e5\u770bDIRECTORY\u5bf9\u8c61\u7684\u6743\u9650 ———————————<\/div>\n
                                                                            <\/div>\n
                                                                            ——————————— exp\u7684\u4f8b\u5b50\u00a0———————————<\/div>\n
                                                                            — \u5bfc\u51fascott\u7528\u6237\u4e0b\u7684\u6240\u6709\u5bf9\u8c61:exp scott\/tiger owner=scott file=\/u01\/exp\/exp_scott.dmp log=exp_scott.log feedback=1000;(\u5bfc\u51fa\u7684\u5b57\u7b26\u96c6\u548c\u5f53\u524d\u73af\u5883\u7684\u5b57\u7b26\u96c6\u4e0d\u540c,\u53ef\u80fd\u53d1\u751f\u5b57\u7b26\u96c6\u8f6c\u6362;)<\/div>\n
                                                                            \"\"<\/div>\n
                                                                            <\/div>\n
                                                                            — \u5bfc\u51fahr\u7528\u6237\u4e0b\u7684jobs,countries\u8868:exp hr\/hr tables=jobs,countries\u00a0file=\/u01\/exp\/exp_hr_tables.dmp log=\/u01\/exp\/exp_hr_tables.log feedback=100;(\u5bfc\u51fa\u7684\u8fc7\u7a0b\u4e2d\u51fa\u73b0\u8b66\u544a,\u5176\u5b9e\u662f\u56e0\u4e3a\u5b57\u7b26\u96c6\u7684\u95ee\u9898;)<\/div>\n
                                                                            \"\"<\/div>\n
                                                                            <\/div>\n
                                                                            — \u8bbe\u7f6e\u5b57\u7b26\u96c6\u5bfc\u51fa,\u6ca1\u6709\u63d0\u793a\u5b57\u7b26\u96c6\u53ef\u80fd\u53d1\u9001\u8f6c\u6362,\u4e5f\u6ca1\u6709\u8b66\u544a;<\/div>\n
                                                                            \"\"<\/div>\n
                                                                            ——————————— exp\u7684\u4f8b\u5b50\u00a0———————————<\/div>\n
                                                                            <\/div>\n
                                                                            ——————————— imp\u7684\u4f8b\u5b50\u00a0———————————<\/div>\n
                                                                            — \u628a\u67d0\u4e2a\u7528\u6237\u4e0b\u7684\u6570\u636e\u5bfc\u5165;<\/div>\n
                                                                            — \u9996\u5148\u5220\u9664\u7528\u6237\u4e0b\u6240\u6709\u7684\u5bf9\u8c61,\u7136\u540e\u521b\u5efa\u7528\u6237(\u5bfc\u5165\u65f6\u6b64\u7528\u6237\u5fc5\u987b\u5b58\u5728):drop user scott cascade;;<\/div>\n
                                                                            \"\"<\/div>\n
                                                                            — \u5bfc\u5165\u6570\u636e:imp scott\/tiger file=\/u01\/exp\/exp_scott.dmp fromuser=scott touser=scott;<\/div>\n
                                                                            \"\"<\/div>\n
                                                                            <\/div>\n
                                                                            — \u628ahr\u7528\u6237\u4e0b\u7684exp_jobs\u8868\u5bfc\u5165\u5230scott\u7528\u6237\u4e0b(\u5fc5\u987b\u4f7f\u7528dba\u7528\u6237\u624d\u53ef\u4ee5\u5b8c\u6210):imp system\/oracle file=\/u01\/exp\/exp_jobs.dmp fromuser=hr touser=scott tables=exp_jobs feedback=100;<\/div>\n
                                                                            \"\"<\/div>\n
                                                                            ——————————— imp\u7684\u4f8b\u5b50\u00a0———————————<\/div>\n
                                                                            <\/div>\n
                                                                            ——————————— NETWORK_LINK\u53c2\u6570\u7684\u6d4b\u8bd5 ———————————<\/div>\n
                                                                            — 1.\u914d\u7f6e\u4e24\u53f0\u6570\u636e\u5e93\u7684tnsnames.ora,\u5176\u4e2dorcl_source\u6307\u5411\u6e90\u6570\u636e\u5e93,orcl_target\u6307\u5411\u76ee\u6807\u6570\u636e\u5e93;<\/div>\n
                                                                            — 2.\u5728\u6e90\u6570\u636e\u5e93\u6dfb\u52a0\u4e00\u4e2a\u76ee\u5f55\u5bf9\u8c61dir_source,\u5e76\u6388\u6743\u7ed9hr\u7528\u6237;<\/div>\n
                                                                            CREATE DIRECTORY dir_source AS ‘\/u01\/dump_source’;<\/div>\n
                                                                            GRANT READ, WRITE ON DIRECTORY dir_source TO hr;<\/div>\n
                                                                            \"\"<\/div>\n
                                                                            — 3.\u4f7f\u7528\u7f51\u7edc\u540d\u5728\u5ba2\u6237\u7aef\u8c03\u7528expdp\u547d\u4ee4,\u5bfc\u51fa\u7684\u6587\u4ef6\u5b58\u653e\u5728\u670d\u52a1\u5668\u7aef(\u7528\u6237\u5fc5\u987b\u8981\u6709CONNECT, RESOURCE, EXP_FULL_DATABASE\u89d2\u8272\u548c\u76ee\u5f55\u5bf9\u8c61\u7684\u8bfb\u5199\u6743\u9650\u5373\u53ef)<\/span>;<\/div>\n
                                                                            expdp hr\/hr@orcl_source directory=dir_source\u00a0schemas=hr\u00a0dumpfile=expdp_hr1.dmp,expdp_hr2.dmp logfile=expdp_hr.log parallel=2 job_name=’job_expdp_hr’;<\/div>\n
                                                                            \"\"<\/div>\n
                                                                            — 4.\u5728\u6e90\u6570\u636e\u5e93\u6dfb\u52a0\u4e00\u4e2a\u76ee\u5f55\u5bf9\u8c61dir_target,\u5e76\u6388\u6743\u7ed9hr\u7528\u6237;<\/div>\n
                                                                            CREATE DIRECTORY dir_target AS ‘\/u01\/dump_target’;
                                                                            \nGRANT READ, WRITE ON DIRECTORY dir_target TO hr;<\/div>\n
                                                                            \"\"<\/div>\n
                                                                            — 6.\u5728\u76ee\u6807\u7aef\u521b\u5efa\u670d\u52a1\u5668\u7aef\u7684Database Link;<\/div>\n
                                                                            CREATE PUBLIC DATABASE LINK dblink_source CONNECT TO hr identified by hr USING ‘ORCL_SOURCE’;<\/div>\n
                                                                            \"\"<\/div>\n
                                                                            — 5.\u5728\u76ee\u6807\u670d\u52a1\u5668\u4f7f\u7528expdp\u547d\u4ee4,\u628a\u5bfc\u51fa\u7684\u6570\u636e\u653e\u5230\u76ee\u6807\u7aef;<\/div>\n
                                                                            expdp hr\/hr\u00a0network_link=<\/span>dblink_source\u00a0directory=dir_target<\/span>\u00a0schemas=hr\u00a0dumpfile=expdp_hr1.dmp,expdp_hr2.dmp logfile=expdp_hr.log parallel=2 job_name=’job_expdp_hr’;<\/div>\n
                                                                            <\/div>\n
                                                                            — \u76f4\u63a5\u4ece\u6e90\u6570\u636e\u5e93\u5bfc\u5165\u5230\u76ee\u6807\u6570\u636e\u5e93,\u4e2d\u95f4\u4e0d\u751f\u6210\u4efb\u4f55\u7684dump\u6587\u4ef6;<\/div>\n
                                                                            impdp system\/oracle\u00a0network_link=<\/span>dblink_source\u00a0directory=dir_target<\/span>\u00a0schemas=hr logfile=exp2imp.log parallel=2 job_name=’job_exp2imp’<\/div>\n
                                                                            ——————————— NETWORK_LINK\u53c2\u6570\u7684\u6d4b\u8bd5 ———————————<\/div>\n
                                                                            <\/div>\n
                                                                            ——————————— INCLUDE\/SQLFILE\u53c2\u6570\u7684\u6d4b\u8bd5 ———————————<\/div>\n
                                                                            — \u5bfc\u51faHR\u7528\u6237\u4e0b\u6240\u6709\u7684PROCEDURE,SEQUENCE,TABLE\u5bf9\u8c61;<\/div>\n
                                                                            expdp hr\/hr directory=dir_source schemas=hr\u00a0include=PROCEDURE,SEQUENCE,TABLE<\/span>\u00a0dumpfile=expdp_hr_part_objects.dmp logfile=expdp_hr_part_objects.log job_name=’job_expdp_hr_objects’;<\/div>\n
                                                                            \"\"<\/div>\n
                                                                            <\/div>\n
                                                                            — \u5bfc\u51fadump\u6587\u4ef6\u4e2d\u5305\u542b\u5bf9\u8c61\u7684DDL\u8bed\u53e5;<\/div>\n
                                                                            impdp system\/oracle directory=dir_source dumpfile=expdp_hr_part_objects.dmp\u00a0sqlfile=hr_objects.sql<\/span>;<\/div>\n
                                                                            \"\"<\/div>\n
                                                                            \n
                                                                            <\/div>\n
                                                                            — \u67e5\u770bDDL\u8bed\u53e5:less \/u01\/dump_source\/hr_objects.sql;<\/div>\n
                                                                            ———————————\u00a0INCLUDE\/SQLFILE\u53c2\u6570\u7684\u6d4b\u8bd5 ———————————<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

                                                                            EXP\/IMP\u548cEXPDP\/IMPDP\u5de5\u5177\u7684\u4f7f\u7528 exp\/imp: \u6982\u5ff5: \u65e9\u671f\u7684oracle\u6570\u636e\u5bfc\u5165\u5bfc\u51fa\u5de5\u5177 […]<\/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-15","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\/15","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=15"}],"version-history":[{"count":0,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/15\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}