Oracle Database 10g\u5f15\u5165\u4e86\u6700\u65b0\u7684\u6570\u636e\u6cf5(Data Dump)\u6280\u672f,\u4f7fDBA\u6216\u5f00\u53d1\u4eba\u5458\u53ef\u4ee5\u5c06\u6570\u636e\u5e93\u5143\u6570\u636e(\u5bf9\u8c61\u5b9a\u4e49)\u548c\u6570\u636e\u5feb\u901f\u79fb\u52a8\u5230\u53e6\u4e00\u4e2aoracle\u6570\u636e\u5e93\u4e2d.<\/p>\n
\u6570\u636e\u6cf5\u5bfc\u51fa\u5bfc\u5165(EXPDP\u548cIMPDP)\u7684\u4f5c\u7528<\/p>\n
1\u3001\u5b9e\u73b0\u903b\u8f91\u5907\u4efd\u548c\u903b\u8f91\u6062\u590d.<\/p>\n
2\u3001\u5728\u6570\u636e\u5e93\u7528\u6237\u4e4b\u95f4\u79fb\u52a8\u5bf9\u8c61.<\/p>\n
3\u3001\u5728\u6570\u636e\u5e93\u4e4b\u95f4\u79fb\u52a8\u5bf9\u8c61<\/p>\n
4\u3001\u5b9e\u73b0\u8868\u7a7a\u95f4\u642c\u79fb. \u00a0 \u00a0 \u00a0 \u6570\u636e\u6cf5\u5bfc\u51fa\u5bfc\u5165\u4e0e\u4f20\u7edf\u5bfc\u51fa\u5bfc\u5165\u7684\u533a\u522b\uff1a<\/p>\n
\u572810g\u4e4b\u524d,\u4f20\u7edf\u7684\u5bfc\u51fa\u548c\u5bfc\u5165\u5206\u522b\u4f7f\u7528EXP\u5de5\u5177\u548cIMP\u5de5\u5177,\u4ece10g\u5f00\u59cb,\u4e0d\u4ec5\u4fdd\u7559\u4e86\u539f\u6709\u7684EXP\u548cIMP\u5de5\u5177,\u8fd8\u63d0\u4f9b\u4e86\u6570\u636e\u6cf5\u5bfc\u51fa\u5bfc\u5165\u5de5\u5177EXPDP\u548cIMPDP.\u4f7f\u7528EXPDP\u548cIMPDP\u65f6\u5e94\u8be5\u6ce8\u610f\u7684\u4e8b\u9879;<\/p>\n
EXP\u548cIMP\u662f\u5ba2\u6237\u6bb5\u5de5\u5177\u7a0b\u5e8f,\u5b83\u4eec\u65e2\u53ef\u4ee5\u5728\u5ba2\u6237\u7aef\u4f7f\u7528,\u4e5f\u53ef\u4ee5\u5728\u670d\u52a1\u5668\u6bb5\u4f7f\u7528.<\/p>\n
EXPDP\u548cIMPDP\u662f\u670d\u52a1\u7aef\u7684\u5de5\u5177\u7a0b\u5e8f,\u4ed6\u4eec\u53ea\u80fd\u5728ORACLE\u670d\u52a1\u7aef\u4f7f\u7528,\u4e0d\u80fd\u5728\u5ba2\u6237\u7aef\u4f7f\u7528<\/p>\n
IMP\u53ea\u9002\u7528\u4e8eEXP\u5bfc\u51fa\u6587\u4ef6,\u4e0d\u9002\u7528\u4e8eEXPDP\u5bfc\u51fa\u6587\u4ef6;IMPDP\u53ea\u9002\u7528\u4e8eEXPDP\u5bfc\u51fa\u6587\u4ef6,\u800c\u4e0d\u9002\u7528\u4e8eEXP\u5bfc\u51fa\u6587\u4ef6.<\/p>\n
\u6570\u636e\u6cf5\u5bfc\u51fa\u5305\u62ec\u5bfc\u51fa\u8868,\u5bfc\u51fa\u65b9\u6848,\u5bfc\u51fa\u8868\u7a7a\u95f4,\u5bfc\u51fa\u6570\u636e\u5e934\u79cd\u65b9\u5f0f.<\/p>\n
EXPDP\u547d\u4ee4\u884c\u9009\u9879<\/p>\n
1. ATTACH<\/p>\n
\u8be5\u9009\u9879\u7528\u4e8e\u5728\u5ba2\u6237\u4f1a\u8bdd\u4e0e\u5df2\u5b58\u5728\u5bfc\u51fa\u4f5c\u7528\u4e4b\u95f4\u5efa\u7acb\u5173\u8054.\u8bed\u6cd5\u5982\u4e0b<\/p>\n
ATTACH=[schema_name.]job_name<\/p>\n
Schema_name\u7528\u4e8e\u6307\u5b9a\u65b9\u6848\u540d,job_name\u7528\u4e8e\u6307\u5b9a\u5bfc\u51fa\u4f5c\u4e1a\u540d.\u6ce8\u610f,\u5982\u679c\u4f7f\u7528ATTACH\u9009\u9879,\u5728\u547d\u4ee4\u884c\u9664\u4e86\u8fde\u63a5\u5b57\u7b26\u4e32\u548cATTACH\u9009\u9879\u5916,\u4e0d\u80fd\u6307\u5b9a\u4efb\u4f55\u5176\u4ed6\u9009\u9879,\u793a\u4f8b\u5982\u4e0b:<\/p>\n
Expdp scott\/tiger ATTACH=scott.export_job<\/p>\n
2. CONTENT<\/p>\n
\u8be5\u9009\u9879\u7528\u4e8e\u6307\u5b9a\u8981\u5bfc\u51fa\u7684\u5185\u5bb9.\u9ed8\u8ba4\u503c\u4e3aALL<\/p>\n
CONTENT={ALL | DATA_ONLY | METADATA_ONLY}<\/p>\n
\u5f53\u8bbe\u7f6eCONTENT\u4e3aALL \u65f6,\u5c06\u5bfc\u51fa\u5bf9\u8c61\u5b9a\u4e49\u53ca\u5176\u6240\u6709\u6570\u636e.\u4e3aDATA_ONLY\u65f6,\u53ea\u5bfc\u51fa\u5bf9\u8c61\u6570\u636e,\u4e3aMETADATA_ONLY\u65f6,\u53ea\u5bfc\u51fa\u5bf9\u8c61\u5b9a\u4e49<\/p>\n
Expdp scott\/tiger DIRECTORY=dump DUMPFILE=a.dump<\/p>\n
CONTENT=METADATA_ONLY<\/p>\n
3. DIRECTORY<\/p>\n
\u6307\u5b9a\u8f6c\u50a8\u6587\u4ef6\u548c\u65e5\u5fd7\u6587\u4ef6\u6240\u5728\u7684\u76ee\u5f55<\/p>\n
DIRECTORY=directory_object<\/p>\n
Directory_object\u7528\u4e8e\u6307\u5b9a\u76ee\u5f55\u5bf9\u8c61\u540d\u79f0.\u9700\u8981\u6ce8\u610f,\u76ee\u5f55\u5bf9\u8c61\u662f\u4f7f\u7528CREATE DIRECTORY\u8bed\u53e5\u5efa\u7acb\u7684\u5bf9\u8c61,\u800c\u4e0d\u662fOS \u76ee\u5f55<\/p>\n
Expdp scott\/tiger DIRECTORY=dump DUMPFILE=a.dump<\/p>\n
\u5efa\u7acb\u76ee\u5f55:<\/p>\n
CREATE DIRECTORY dump as \u2018d:dump\u2019;<\/p>\n
\u67e5\u8be2\u521b\u5efa\u4e86\u90a3\u4e9b\u5b50\u76ee\u5f55:<\/p>\n
SELECT * FROM dba_directories;<\/p>\n
4. DUMPFILE<\/p>\n
\u7528\u4e8e\u6307\u5b9a\u8f6c\u50a8\u6587\u4ef6\u7684\u540d\u79f0,\u9ed8\u8ba4\u540d\u79f0\u4e3aexpdat.dmp<\/p>\n
DUMPFILE=[directory_object:]file_name [,\u2026.]<\/p>\n
Directory_object\u7528\u4e8e\u6307\u5b9a\u76ee\u5f55\u5bf9\u8c61\u540d,file_name\u7528\u4e8e\u6307\u5b9a\u8f6c\u50a8\u6587\u4ef6\u540d.\u9700\u8981\u6ce8\u610f,\u5982\u679c\u4e0d\u6307\u5b9adirectory_object,\u5bfc\u51fa\u5de5\u5177\u4f1a\u81ea\u52a8\u4f7f\u7528DIRECTORY\u9009\u9879\u6307\u5b9a\u7684\u76ee\u5f55\u5bf9\u8c61<\/p>\n
Expdp scott\/tiger DIRECTORY=dump1 DUMPFILE=dump2:a.dmp<\/p>\n
5. ESTIMATE<\/p>\n
\u6307\u5b9a\u4f30\u7b97\u88ab\u5bfc\u51fa\u8868\u6240\u5360\u7528\u78c1\u76d8\u7a7a\u95f4\u5206\u65b9\u6cd5.\u9ed8\u8ba4\u503c\u662fBLOCKS<\/p>\n
EXTIMATE={BLOCKS | STATISTICS}<\/p>\n
\u8bbe\u7f6e\u4e3aBLOCKS\u65f6,oracle\u4f1a\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,\u8bbe\u7f6e\u4e3aSTATISTICS\u65f6,\u6839\u636e\u6700\u8fd1\u7edf\u8ba1\u503c\u4f30\u7b97\u5bf9\u8c61\u5360\u7528\u7a7a\u95f4<\/p>\n
Expdp scott\/tiger TABLES=emp ESTIMATE=STATISTICS<\/p>\n
DIRECTORY=dump DUMPFILE=a.dump<\/p>\n
6. EXTIMATE_ONLY<\/p>\n
\u6307\u5b9a\u662f\u5426\u53ea\u4f30\u7b97\u5bfc\u51fa\u4f5c\u4e1a\u6240\u5360\u7528\u7684\u78c1\u76d8\u7a7a\u95f4,\u9ed8\u8ba4\u503c\u4e3aN<\/p>\n
EXTIMATE_ONLY={Y | N}<\/p>\n
\u8bbe\u7f6e\u4e3aY\u65f6,\u5bfc\u51fa\u4f5c\u7528\u53ea\u4f30\u7b97\u5bf9\u8c61\u6240\u5360\u7528\u7684\u78c1\u76d8\u7a7a\u95f4,\u800c\u4e0d\u4f1a\u6267\u884c\u5bfc\u51fa\u4f5c\u4e1a,\u4e3aN\u65f6,\u4e0d\u4ec5\u4f30\u7b97\u5bf9\u8c61\u6240\u5360\u7528\u7684\u78c1\u76d8\u7a7a\u95f4,\u8fd8\u4f1a\u6267\u884c\u5bfc\u51fa\u64cd\u4f5c.<\/p>\n
Expdp scott\/tiger ESTIMATE_ONLY=y NOLOGFILE=y<\/p>\n
7. EXCLUDE<\/p>\n
\u8be5\u9009\u9879\u7528\u4e8e\u6307\u5b9a\u6267\u884c\u64cd\u4f5c\u65f6\u91ca\u653e\u8981\u6392\u9664\u5bf9\u8c61\u7c7b\u578b\u6216\u76f8\u5173\u5bf9\u8c61<\/p>\n
EXCLUDE=object_type[:name_clause] [,\u2026.]<\/p>\n
Object_type\u7528\u4e8e\u6307\u5b9a\u8981\u6392\u9664\u7684\u5bf9\u8c61\u7c7b\u578b,name_clause\u7528\u4e8e\u6307\u5b9a\u8981\u6392\u9664\u7684\u5177\u4f53\u5bf9\u8c61.EXCLUDE\u548cINCLUDE\u4e0d\u80fd\u540c\u65f6\u4f7f\u7528<\/p>\n
Expdp scott\/tiger DIRECTORY=dump DUMPFILE=a.dup EXCLUDE=VIEW<\/p>\n
8. FILESIZE<\/p>\n
\u6307\u5b9a\u5bfc\u51fa\u6587\u4ef6\u7684\u6700\u5927\u5c3a\u5bf8,\u9ed8\u8ba4\u4e3a0,(\u8868\u793a\u6587\u4ef6\u5c3a\u5bf8\u6ca1\u6709\u9650\u5236)<\/p>\n
9. FLASHBACK_SCN<\/p>\n
\u6307\u5b9a\u5bfc\u51fa\u7279\u5b9aSCN\u65f6\u523b\u7684\u8868\u6570\u636e<\/p>\n
FLASHBACK_SCN=scn_value<\/p>\n
Scn_value\u7528\u4e8e\u6807\u8bc6SCN\u503c.FLASHBACK_SCN\u548cFLASHBACK_TIME\u4e0d\u80fd\u540c\u65f6\u4f7f\u7528<\/p>\n
Expdp scott\/tiger DIRECTORY=dump DUMPFILE=a.dmp<\/p>\n
FLASHBACK_SCN=358523<\/p>\n
10. FLASHBACK_TIME<\/p>\n
\u6307\u5b9a\u5bfc\u51fa\u7279\u5b9a\u65f6\u95f4\u70b9\u7684\u8868\u6570\u636e<\/p>\n
FLASHBACK_TIME=\u201dTO_TIMESTAMP(time_value)\u201d<\/p>\n
Expdp scott\/tiger DIRECTORY=dump DUMPFILE=a.dmp FLASHBACK_TIME=<\/p>\n
\u201cTO_TIMESTAMP(\u201925-08-2004 14:35:00\u2019,\u2019DD-MM-YYYY HH24:MI:SS\u2019)\u201d<\/p>\n
11. FULL<\/p>\n
\u6307\u5b9a\u6570\u636e\u5e93\u6a21\u5f0f\u5bfc\u51fa,\u9ed8\u8ba4\u4e3aN<\/p>\n
FULL={Y | N}<\/p>\n
\u4e3aY\u65f6,\u6807\u8bc6\u6267\u884c\u6570\u636e\u5e93\u5bfc\u51fa.<\/p>\n
12. HELP<\/p>\n
\u6307\u5b9a\u662f\u5426\u663e\u793aEXPDP\u547d\u4ee4\u884c\u9009\u9879\u7684\u5e2e\u52a9\u4fe1\u606f,\u9ed8\u8ba4\u4e3aN<\/p>\n
\u5f53\u8bbe\u7f6e\u4e3aY\u65f6,\u4f1a\u663e\u793a\u5bfc\u51fa\u9009\u9879\u7684\u5e2e\u52a9\u4fe1\u606f.<\/p>\n
Expdp help=y<\/p>\n
13. INCLUDE<\/p>\n
\u6307\u5b9a\u5bfc\u51fa\u65f6\u8981\u5305\u542b\u7684\u5bf9\u8c61\u7c7b\u578b\u53ca\u76f8\u5173\u5bf9\u8c61<\/p>\n
INCLUDE = object_type[:name_clause] [,\u2026 ]<\/p>\n
14. JOB_NAME<\/p>\n
\u6307\u5b9a\u8981\u5bfc\u51fa\u4f5c\u7528\u7684\u540d\u79f0,\u9ed8\u8ba4\u4e3aSYS_XXX<\/p>\n
JOB_NAME=jobname_string<\/p>\n
15. LOGFILE<\/p>\n
\u6307\u5b9a\u5bfc\u51fa\u65e5\u5fd7\u6587\u4ef6\u6587\u4ef6\u7684\u540d\u79f0,\u9ed8\u8ba4\u540d\u79f0\u4e3aexport.log<\/p>\n
LOGFILE=[directory_object:]file_name<\/p>\n
Directory_object\u7528\u4e8e\u6307\u5b9a\u76ee\u5f55\u5bf9\u8c61\u540d\u79f0,file_name\u7528\u4e8e\u6307\u5b9a\u5bfc\u51fa\u65e5\u5fd7\u6587\u4ef6\u540d.\u5982\u679c\u4e0d\u6307\u5b9adirectory_object.\u5bfc\u51fa\u4f5c\u7528\u4f1a\u81ea\u52a8\u4f7f\u7528DIRECTORY\u7684\u76f8\u5e94\u9009\u9879\u503c.<\/p>\n
Expdp scott\/tiger DIRECTORY=dump DUMPFILE=a.dmp logfile=a.log<\/p>\n
16. NETWORK_LINK<\/p>\n
\u6307\u5b9a\u6570\u636e\u5e93\u94fe\u540d,\u5982\u679c\u8981\u5c06\u8fdc\u7a0b\u6570\u636e\u5e93\u5bf9\u8c61\u5bfc\u51fa\u5230\u672c\u5730\u4f8b\u7a0b\u7684\u8f6c\u50a8\u6587\u4ef6\u4e2d,\u5fc5\u987b\u8bbe\u7f6e\u8be5\u9009\u9879.<\/p>\n
17. NOLOGFILE<\/p>\n
\u8be5\u9009\u9879\u7528\u4e8e\u6307\u5b9a\u7981\u6b62\u751f\u6210\u5bfc\u51fa\u65e5\u5fd7\u6587\u4ef6,\u9ed8\u8ba4\u503c\u4e3aN.<\/p>\n
18. PARALLEL<\/p>\n
\u6307\u5b9a\u6267\u884c\u5bfc\u51fa\u64cd\u4f5c\u7684\u5e76\u884c\u8fdb\u7a0b\u4e2a\u6570,\u9ed8\u8ba4\u503c\u4e3a1<\/p>\n
19. PARFILE<\/p>\n
\u6307\u5b9a\u5bfc\u51fa\u53c2\u6570\u6587\u4ef6\u7684\u540d\u79f0<\/p>\n
PARFILE=[directory_path] file_name<\/p>\n
20. QUERY<\/p>\n
\u7528\u4e8e\u6307\u5b9a\u8fc7\u6ee4\u5bfc\u51fa\u6570\u636e\u7684where\u6761\u4ef6<\/p>\n
QUERY=[schema.] [table_name:] query_clause<\/p>\n
Schema\u7528\u4e8e\u6307\u5b9a\u65b9\u6848\u540d,table_name\u7528\u4e8e\u6307\u5b9a\u8868\u540d,query_clause\u7528\u4e8e\u6307\u5b9a\u6761\u4ef6\u9650\u5236\u5b50\u53e5.QUERY\u9009\u9879\u4e0d\u80fd\u4e0eCONNECT=METADATA_ONLY,EXTIMATE_ONLY,TRANSPORT_TABLESPACES\u7b49\u9009\u9879\u540c\u65f6\u4f7f\u7528.<\/p>\n
Expdp scott\/tiger directory=dump dumpfiel=a.dmp<\/p>\n
Tables=emp query=\u2019WHERE deptno=20\u2019<\/p>\n
21. SCHEMAS<\/p>\n
\u8be5\u65b9\u6848\u7528\u4e8e\u6307\u5b9a\u6267\u884c\u65b9\u6848\u6a21\u5f0f\u5bfc\u51fa,\u9ed8\u8ba4\u4e3a\u5f53\u524d\u7528\u6237\u65b9\u6848.<\/p>\n
22. STATUS<\/p>\n
\u6307\u5b9a\u663e\u793a\u5bfc\u51fa\u4f5c\u7528\u8fdb\u7a0b\u7684\u8be6\u7ec6\u72b6\u6001,\u9ed8\u8ba4\u503c\u4e3a0<\/p>\n
23. TABLES<\/p>\n
\u6307\u5b9a\u8868\u6a21\u5f0f\u5bfc\u51fa<\/p>\n
TABLES=[schema_name.]table_name[:partition_name][,\u2026]<\/p>\n
Schema_name\u7528\u4e8e\u6307\u5b9a\u65b9\u6848\u540d,table_name\u7528\u4e8e\u6307\u5b9a\u5bfc\u51fa\u7684\u8868\u540d,partition_name\u7528\u4e8e\u6307\u5b9a\u8981\u5bfc\u51fa\u7684\u5206\u533a\u540d.<\/p>\n
24. TABLESPACES<\/p>\n
\u6307\u5b9a\u8981\u5bfc\u51fa\u8868\u7a7a\u95f4\u5217\u8868<\/p>\n
25. TRANSPORT_FULL_CHECK<\/p>\n
\u8be5\u9009\u9879\u7528\u4e8e\u6307\u5b9a\u88ab\u642c\u79fb\u8868\u7a7a\u95f4\u548c\u672a\u642c\u79fb\u8868\u7a7a\u95f4\u5173\u8054\u5173\u7cfb\u7684\u68c0\u67e5\u65b9\u5f0f,\u9ed8\u8ba4\u4e3aN.<\/p>\n
\u5f53\u8bbe\u7f6e\u4e3aY\u65f6,\u5bfc\u51fa\u4f5c\u7528\u4f1a\u68c0\u67e5\u8868\u7a7a\u95f4\u76f4\u63a5\u7684\u5b8c\u6574\u5173\u8054\u5173\u7cfb,\u5982\u679c\u8868\u7a7a\u95f4\u6240\u5728\u8868\u7a7a\u95f4\u6216\u5176\u7d22\u5f15\u6240\u5728\u7684\u8868\u7a7a\u95f4\u53ea\u6709\u4e00\u4e2a\u8868\u7a7a\u95f4\u88ab\u642c\u79fb,\u5c06\u663e\u793a\u9519\u8bef\u4fe1\u606f.\u5f53\u8bbe\u7f6e\u4e3aN\u65f6,\u5bfc\u51fa\u4f5c\u7528\u53ea\u68c0\u67e5\u5355\u7aef\u4f9d\u8d56,\u5982\u679c\u642c\u79fb\u7d22\u5f15\u6240\u5728\u8868\u7a7a\u95f4,\u4f46\u672a\u642c\u79fb\u8868\u6240\u5728\u8868\u7a7a\u95f4,\u5c06\u663e\u793a\u51fa\u9519\u4fe1\u606f,\u5982\u679c\u642c\u79fb\u8868\u6240\u5728\u8868\u7a7a\u95f4,\u672a\u642c\u79fb\u7d22\u5f15\u6240\u5728\u8868\u7a7a\u95f4,\u5219\u4e0d\u4f1a\u663e\u793a\u9519\u8bef\u4fe1\u606f.<\/p>\n
26. TRANSPORT_TABLESPACES<\/p>\n
\u6307\u5b9a\u6267\u884c\u8868\u7a7a\u95f4\u6a21\u5f0f\u5bfc\u51fa<\/p>\n
27. VERSION<\/p>\n
\u6307\u5b9a\u88ab\u5bfc\u51fa\u5bf9\u8c61\u7684\u6570\u636e\u5e93\u7248\u672c,\u9ed8\u8ba4\u503c\u4e3aCOMPATIBLE.<\/p>\n
VERSION={COMPATIBLE | LATEST | version_string}<\/p>\n
\u4e3aCOMPATIBLE\u65f6,\u4f1a\u6839\u636e\u521d\u59cb\u5316\u53c2\u6570COMPATIBLE\u751f\u6210\u5bf9\u8c61\u5143\u6570\u636e;\u4e3aLATEST\u65f6,\u4f1a\u6839\u636e\u6570\u636e\u5e93\u7684\u5b9e\u9645\u7248\u672c\u751f\u6210\u5bf9\u8c61\u5143\u6570\u636e.version_string\u7528\u4e8e\u6307\u5b9a\u6570\u636e\u5e93\u7248\u672c\u5b57\u7b26\u4e32.\u8c03\u7528EXPDP<\/p>\n
\u4f7f\u7528EXPDP\u5de5\u5177\u65f6,\u5176\u8f6c\u50a8\u6587\u4ef6\u53ea\u80fd\u88ab\u5b58\u653e\u5728DIRECTORY\u5bf9\u8c61\u5bf9\u5e94\u7684OS\u76ee\u5f55\u4e2d,\u800c\u4e0d\u80fd\u76f4\u63a5\u6307\u5b9a\u8f6c\u50a8\u6587\u4ef6\u6240\u5728\u7684OS\u76ee\u5f55.\u56e0\u6b64,\u4f7f\u7528EXPDP\u5de5\u5177\u65f6,\u5fc5\u987b\u9996\u5148\u5efa\u7acbDIRECTORY\u5bf9\u8c61.\u5e76\u4e14\u9700\u8981\u4e3a\u6570\u636e\u5e93\u7528\u6237\u6388\u4e88\u4f7f\u7528DIRECTORY\u5bf9\u8c61\u6743\u9650.<\/p>\n
CREATE DIRECTORY dump dir AS \u2018D:DUMP\u2019;<\/p>\n
GRANT READ, WIRTE ON DIRECTORY dump_dir TO scott;<\/p>\n
1\u3001\u5bfc\u51fa\u8868<\/p>\n
Expdp scott\/tiger DIRECTORY=dump_dir DUMPFILE=tab.dmp TABLES=dept,emp<\/p>\n
2\u3001\u5bfc\u51fa\u65b9\u6848<\/p>\n
Expdp scott\/tiger DIRECTORY=dump_dir DUMPFILE=schema.dmp<\/p>\n
SCHEMAS=system,scott<\/p>\n
3\u3001\u5bfc\u51fa\u8868\u7a7a\u95f4<\/p>\n
Expdp system\/manager DIRECTORY=dump_dir DUMPFILE=tablespace.dmp<\/p>\n
TABLESPACES=user01,user02<\/p>\n
4\u3001\u5bfc\u51fa\u6570\u636e\u5e93<\/p>\n
Expdp system\/manager DIRECTORY=dump_dir DUMPFILE=full.dmp FULL=Y<\/p>\n
\u4f7f\u7528IMPDP<\/p>\n
IMPDP\u547d\u4ee4\u884c\u9009\u9879\u4e0eEXPDP\u6709\u5f88\u591a\u76f8\u540c\u7684,\u4e0d\u540c\u7684\u6709:<\/p>\n
1\u3001REMAP_DATAFILE<\/p>\n
\u8be5\u9009\u9879\u7528\u4e8e\u5c06\u6e90\u6570\u636e\u6587\u4ef6\u540d\u8f6c\u53d8\u4e3a\u76ee\u6807\u6570\u636e\u6587\u4ef6\u540d,\u5728\u4e0d\u540c\u5e73\u53f0\u4e4b\u95f4\u642c\u79fb\u8868\u7a7a\u95f4\u65f6\u53ef\u80fd\u9700\u8981\u8be5\u9009\u9879.<\/p>\n
REMAP_DATAFIEL=source_datafie:target_datafile<\/p>\n
2\u3001REMAP_SCHEMA<\/p>\n
\u8be5\u9009\u9879\u7528\u4e8e\u5c06\u6e90\u65b9\u6848\u7684\u6240\u6709\u5bf9\u8c61\u88c5\u8f7d\u5230\u76ee\u6807\u65b9\u6848\u4e2d.<\/p>\n
REMAP_SCHEMA=source_schema:target_schema<\/p>\n
3\u3001REMAP_TABLESPACE<\/p>\n
\u5c06\u6e90\u8868\u7a7a\u95f4\u7684\u6240\u6709\u5bf9\u8c61\u5bfc\u5165\u5230\u76ee\u6807\u8868\u7a7a\u95f4\u4e2d<\/p>\n
REMAP_TABLESPACE=source_tablespace:target:tablespace<\/p>\n
4\u3001REUSE_DATAFILES<\/p>\n
\u8be5\u9009\u9879\u6307\u5b9a\u5efa\u7acb\u8868\u7a7a\u95f4\u65f6\u662f\u5426\u8986\u76d6\u5df2\u5b58\u5728\u7684\u6570\u636e\u6587\u4ef6.\u9ed8\u8ba4\u4e3aN<\/p>\n
REUSE_DATAFIELS={Y | N}<\/p>\n
5\u3001SKIP_UNUSABLE_INDEXES<\/p>\n
\u6307\u5b9a\u5bfc\u5165\u662f\u662f\u5426\u8df3\u8fc7\u4e0d\u53ef\u4f7f\u7528\u7684\u7d22\u5f15,\u9ed8\u8ba4\u4e3aN<\/p>\n
6\u3001SQLFILE<\/p>\n
\u6307\u5b9a\u5c06\u5bfc\u5165\u8981\u6307\u5b9a\u7684\u7d22\u5f15DDL\u64cd\u4f5c\u5199\u5165\u5230SQL\u811a\u672c\u4e2d<\/p>\n
SQLFILE=[directory_object:]file_name<\/p>\n
Impdp scott\/tiger DIRECTORY=dump DUMPFILE=tab.dmp SQLFILE=a.sql<\/p>\n
7\u3001STREAMS_CONFIGURATION<\/p>\n
\u6307\u5b9a\u662f\u5426\u5bfc\u5165\u6d41\u5143\u6570\u636e(Stream Matadata),\u9ed8\u8ba4\u503c\u4e3aY.<\/p>\n
8\u3001TABLE_EXISTS_ACTION<\/p>\n
\u8be5\u9009\u9879\u7528\u4e8e\u6307\u5b9a\u5f53\u8868\u5df2\u7ecf\u5b58\u5728\u65f6\u5bfc\u5165\u4f5c\u4e1a\u8981\u6267\u884c\u7684\u64cd\u4f5c,\u9ed8\u8ba4\u4e3aSKIP<\/p>\n
TABBLE_EXISTS_ACTION={SKIP | APPEND | TRUNCATE | FRPLACE }<\/p>\n
\u5f53\u8bbe\u7f6e\u8be5\u9009\u9879\u4e3aSKIP\u65f6,\u5bfc\u5165\u4f5c\u4e1a\u4f1a\u8df3\u8fc7\u5df2\u5b58\u5728\u8868\u5904\u7406\u4e0b\u4e00\u4e2a\u5bf9\u8c61;\u5f53\u8bbe\u7f6e\u4e3aAPPEND\u65f6,\u4f1a\u8ffd\u52a0\u6570\u636e,\u4e3aTRUNCATE\u65f6,\u5bfc\u5165\u4f5c\u4e1a\u4f1a\u622a\u65ad\u8868,\u7136\u540e\u4e3a\u5176\u8ffd\u52a0\u65b0\u6570\u636e;\u5f53\u8bbe\u7f6e\u4e3aREPLACE\u65f6,\u5bfc\u5165\u4f5c\u4e1a\u4f1a\u5220\u9664\u5df2\u5b58\u5728\u8868,\u91cd\u5efa\u8868\u75c5\u8ffd\u52a0\u6570\u636e,\u6ce8\u610f,TRUNCATE\u9009\u9879\u4e0d\u9002\u7528\u4e0e\u7c07\u8868\u548cNETWORK_LINK\u9009\u9879<\/p>\n
9\u3001TRANSFORM<\/p>\n
\u8be5\u9009\u9879\u7528\u4e8e\u6307\u5b9a\u662f\u5426\u4fee\u6539\u5efa\u7acb\u5bf9\u8c61\u7684DDL\u8bed\u53e5<\/p>\n
TRANSFORM=transform_name:value[:object_type]<\/p>\n
Transform_name\u7528\u4e8e\u6307\u5b9a\u8f6c\u6362\u540d,\u5176\u4e2dSEGMENT_ATTRIBUTES\u7528\u4e8e\u6807\u8bc6\u6bb5\u5c5e\u6027(\u7269\u7406\u5c5e\u6027,\u5b58\u50a8\u5c5e\u6027,\u8868\u7a7a\u95f4,\u65e5\u5fd7\u7b49\u4fe1\u606f),STORAGE\u7528\u4e8e\u6807\u8bc6\u6bb5\u5b58\u50a8\u5c5e\u6027,VALUE\u7528\u4e8e\u6307\u5b9a\u662f\u5426\u5305\u542b\u6bb5\u5c5e\u6027\u6216\u6bb5\u5b58\u50a8\u5c5e\u6027,object_type\u7528\u4e8e\u6307\u5b9a\u5bf9\u8c61\u7c7b\u578b.<\/p>\n
Impdp scott\/tiger directory=dump dumpfile=tab.dmp<\/p>\n
Transform=segment_attributes:n:table<\/p>\n
10\u3001TRANSPORT_DATAFILES<\/p>\n
\u8be5\u9009\u9879\u7528\u4e8e\u6307\u5b9a\u642c\u79fb\u7a7a\u95f4\u65f6\u8981\u88ab\u5bfc\u5165\u5230\u76ee\u6807\u6570\u636e\u5e93\u7684\u6570\u636e\u6587\u4ef6<\/p>\n
TRANSPORT_DATAFILE=datafile_name<\/p>\n
Datafile_name\u7528\u4e8e\u6307\u5b9a\u88ab\u590d\u5236\u5230\u76ee\u6807\u6570\u636e\u5e93\u7684\u6570\u636e\u6587\u4ef6<\/p>\n
Impdp system\/manager DIRECTORY=dump DUMPFILE=tts.dmp<\/p>\n
TRANSPORT_DATAFILES=\u2019\/user01\/data\/tbs1.f\u2019\u8c03\u7528IMPDP<\/p>\n
1\u3001\u5bfc\u5165\u8868<\/p>\n
Impdp scott\/tiger DIRECTORY=dump_dir DUMPFILE=tab.dmp TABLES=dept,emp<\/p>\n
Impdp system\/manage DIRECTORY=dump_dir DUMPFILE=tab.dmp TABLES=scott.dept,scott.emp<\/p>\n
REMAP_SCHEMA=SCOTT:SYSTEM<\/p>\n
\u7b2c\u4e00\u79cd\u65b9\u6cd5\u8868\u793a\u5c06DEPT\u548cEMP\u8868\u5bfc\u5165\u5230SCOTT\u65b9\u6848\u4e2d,\u7b2c\u4e8c\u79cd\u65b9\u6cd5\u8868\u793a\u5c06DEPT\u548cEMP\u8868\u5bfc\u5165\u7684SYSTEM<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Oracle Database 10g\u5f15\u5165\u4e86\u6700\u65b0\u7684\u6570\u636e\u6cf5(Data Dump)\u6280\u672f,\u4f7fDBA\u6216\u5f00\u53d1\u4eba\u5458\u53ef\u4ee5\u5c06\u6570\u636e\u5e93\u5143\u6570\u636e(\u5bf9\u8c61\u5b9a\u4e49)\u548c\u6570\u636e\u5feb\u901f\u79fb\u52a8\u5230\u53e6\u4e00\u4e2aoracle\u6570\u636e\u5e93\u4e2d. \u6570\u636e\u6cf5\u5bfc\u51fa\u5bfc\u5165(EXPDP\u548cIMPDP)\u7684\u4f5c\u7528 1\u3001\u5b9e\u73b0\u903b\u8f91\u5907\u4efd\u548c\u903b\u8f91\u6062\u590d. 2\u3001\u5728\u6570\u636e\u5e93\u7528\u6237\u4e4b\u95f4\u79fb\u52a8\u5bf9\u8c61. 3\u3001\u5728\u6570\u636e\u5e93\u4e4b\u95f4\u79fb\u52a8\u5bf9\u8c61 4\u3001\u5b9e\u73b0\u8868\u7a7a\u95f4\u642c\u79fb. \u00a0 \u00a0 \u00a0 \u6570\u636e\u6cf5\u5bfc\u51fa\u5bfc\u5165\u4e0e\u4f20\u7edf\u5bfc\u51fa\u5bfc\u5165\u7684\u533a\u522b\uff1a \u572810g\u4e4b\u524d,\u4f20\u7edf\u7684\u5bfc\u51fa\u548c\u5bfc\u5165\u5206\u522b\u4f7f\u7528EXP\u5de5\u5177\u548cIMP\u5de5\u5177,\u4ece10g\u5f00\u59cb,\u4e0d\u4ec5\u4fdd\u7559\u4e86\u539f\u6709\u7684EXP\u548cIMP\u5de5\u5177,\u8fd8\u63d0\u4f9b\u4e86\u6570\u636e\u6cf5\u5bfc\u51fa\u5bfc\u5165\u5de5\u5177EXPDP\u548cIMPDP.\u4f7f\u7528EXPDP\u548cIMPDP\u65f6\u5e94\u8be5\u6ce8\u610f\u7684\u4e8b\u9879; EXP\u548cIMP\u662f\u5ba2\u6237\u6bb5\u5de5\u5177\u7a0b\u5e8f,\u5b83\u4eec\u65e2\u53ef\u4ee5\u5728\u5ba2\u6237\u7aef\u4f7f\u7528,\u4e5f\u53ef\u4ee5\u5728\u670d\u52a1\u5668\u6bb5\u4f7f\u7528. EXPDP\u548cIMPDP\u662f\u670d\u52a1\u7aef\u7684\u5de5\u5177\u7a0b\u5e8f,\u4ed6\u4eec\u53ea\u80fd\u5728ORACLE\u670d\u52a1\u7aef\u4f7f\u7528,\u4e0d\u80fd\u5728\u5ba2\u6237\u7aef\u4f7f\u7528 IMP\u53ea\u9002\u7528\u4e8eEXP\u5bfc\u51fa\u6587\u4ef6,\u4e0d\u9002\u7528\u4e8eEXPDP\u5bfc\u51fa\u6587\u4ef6;IMPDP\u53ea\u9002\u7528\u4e8eEXPDP\u5bfc\u51fa\u6587\u4ef6,\u800c\u4e0d\u9002\u7528\u4e8eEXP\u5bfc\u51fa\u6587\u4ef6. \u6570\u636e\u6cf5\u5bfc\u51fa\u5305\u62ec\u5bfc\u51fa\u8868,\u5bfc\u51fa\u65b9\u6848,\u5bfc\u51fa\u8868\u7a7a\u95f4,\u5bfc\u51fa\u6570\u636e\u5e934\u79cd\u65b9\u5f0f. EXPDP\u547d\u4ee4\u884c\u9009\u9879 1. ATTACH \u8be5\u9009\u9879\u7528\u4e8e\u5728\u5ba2\u6237\u4f1a\u8bdd\u4e0e\u5df2\u5b58\u5728\u5bfc\u51fa\u4f5c\u7528\u4e4b\u95f4\u5efa\u7acb\u5173\u8054.\u8bed\u6cd5\u5982\u4e0b ATTACH=[schema_name.]job_name Schema_name\u7528\u4e8e\u6307\u5b9a\u65b9\u6848\u540d,job_name\u7528\u4e8e\u6307\u5b9a\u5bfc\u51fa\u4f5c\u4e1a\u540d.\u6ce8\u610f,\u5982\u679c\u4f7f\u7528ATTACH\u9009\u9879,\u5728\u547d\u4ee4\u884c\u9664\u4e86\u8fde\u63a5\u5b57\u7b26\u4e32\u548cATTACH\u9009\u9879\u5916,\u4e0d\u80fd\u6307\u5b9a\u4efb\u4f55\u5176\u4ed6\u9009\u9879,\u793a\u4f8b\u5982\u4e0b: Expdp scott\/tiger ATTACH=scott.export_job 2. CONTENT \u8be5\u9009\u9879\u7528\u4e8e\u6307\u5b9a\u8981\u5bfc\u51fa\u7684\u5185\u5bb9.\u9ed8\u8ba4\u503c\u4e3aALL CONTENT={ALL | DATA_ONLY | METADATA_ONLY} \u5f53\u8bbe\u7f6eCONTENT\u4e3aALL \u65f6,\u5c06\u5bfc\u51fa\u5bf9\u8c61\u5b9a\u4e49\u53ca\u5176\u6240\u6709\u6570\u636e.\u4e3aDATA_ONLY\u65f6,\u53ea\u5bfc\u51fa\u5bf9\u8c61\u6570\u636e,\u4e3aMETADATA_ONLY\u65f6,\u53ea\u5bfc\u51fa\u5bf9\u8c61\u5b9a\u4e49 Expdp scott\/tiger DIRECTORY=dump DUMPFILE=a.dump CONTENT=METADATA_ONLY 3. DIRECTORY \u6307\u5b9a\u8f6c\u50a8\u6587\u4ef6\u548c\u65e5\u5fd7\u6587\u4ef6\u6240\u5728\u7684\u76ee\u5f55 DIRECTORY=directory_object Directory_object\u7528\u4e8e\u6307\u5b9a\u76ee\u5f55\u5bf9\u8c61\u540d\u79f0.\u9700\u8981\u6ce8\u610f,\u76ee\u5f55\u5bf9\u8c61\u662f\u4f7f\u7528CREATE DIRECTORY\u8bed\u53e5\u5efa\u7acb\u7684\u5bf9\u8c61,\u800c\u4e0d\u662fOS \u76ee\u5f55 Expdp scott\/tiger DIRECTORY=dump DUMPFILE=a.dump \u5efa\u7acb\u76ee\u5f55: CREATE … Continue reading ORACLE:EXPDP\u548cIMPDP\u4f7f\u7528\u8bf4\u660e<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-587","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts\/587","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=587"}],"version-history":[{"count":1,"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts\/587\/revisions"}],"predecessor-version":[{"id":588,"href":"https:\/\/www.strongd.net\/index.php?rest_route=\/wp\/v2\/posts\/587\/revisions\/588"}],"wp:attachment":[{"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=587"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=587"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.strongd.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=587"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}