{"id":591,"date":"2013-01-14T13:05:13","date_gmt":"2013-01-14T05:05:13","guid":{"rendered":"http:\/\/www.yallonking.com\/?p=591"},"modified":"2013-01-22T23:17:16","modified_gmt":"2013-01-22T15:17:16","slug":"data-pump-export%e4%bd%bf%e7%94%a8%e5%ae%9e%e4%be%8b","status":"publish","type":"post","link":"http:\/\/www.yallonking.com\/?p=591","title":{"rendered":"Data Pump Export\/Impdp\u64cd\u4f5c\u5b9e\u4f8b"},"content":{"rendered":"<p>Data Pump Export\/Impdp\u64cd\u4f5c\u5b9e\u4f8b<br \/>\n\uff08\u4e00\uff09Expdp\u76f8\u5173\u00a0\u00a0 \u00a0expdp\u662f\u5c06\u6570\u636e\u6216\u8005\u5143\u6570\u636e\u4ece\u6570\u636e\u5e93\u5378\u8f7d\u5230dump\u6587\u4ef6\u96c6\u7684\u4e00\u4e2a\u5de5\u5177\uff0c\u800c\u8fd9\u79cddump\u6587\u4ef6\u96c6\u4e5f\u53ea\u80fd\u7531impdp\u5de5\u5177\u4f7f\u7528\uff0c\u5728\u76f8\u540c\u7684\u7cfb\u7edf\u6216\u8005\u5c06\u5979\u79fb\u52a8\u5230\u522b\u7684\u7cfb\u7edf\u8fdb\u884c\u5bfc\u5165\u64cd\u4f5c\u3002<br \/>\ndump\u6587\u4ef6\u96c6\u662f\u7531\u4e00\u4e2a\u6216\u591a\u4e2a\u78c1\u76d8\u6587\u4ef6\u7ec4\u6210\uff0c\u91cc\u8fb9\u5305\u542b\u6570\u636e\u5e93\u5bf9\u8c61\u5143\u6570\u636e\u548c\u63a7\u5236\u4fe1\u606f\u3002\u8fd9\u4e9b\u6587\u4ef6\u6709\u81ea\u5df1\u81ea\u7531\u7684\u683c\u5f0f\u7684\u4e8c\u8fdb\u5236\u6587\u4ef6\u3002\u5728\u4e00\u4e2aimpdp\u5bfc\u5165\u64cd\u4f5c\u4e2d\uff0c\u5c06\u4f1a\u4f7f\u7528\u5230\u8fd9\u8c22\u6587\u4ef6\u96c6\u3002<br \/>\n\u7531\u4e8edump\u6587\u4ef6\u96c6\u662f\u7531\u670d\u52a1\u5668\u7aef\u6765\u5199\u7684\uff0c\u800c\u4e0d\u662f\u7528\u5ba2\u6237\u7aef\u6765\u5199\u7684\uff0c\u6240\u4ee5\u9700\u8981dba\u521b\u5efa\u4e00\u4e2a\u76ee\u5f55\u5bf9\u8c61\u3002<br \/>\n\u8981\u6267\u884c\u4e00\u4e2a\u5bfc\u51fa\u64cd\u4f5c\uff0c\u53ef\u4ee5\u7528\u5e26\u53c2\u6570\u7684expdp\u547d\u4ee4\u884c\uff0c\u6216\u8005\u5c06\u53c2\u6570\u5199\u5230\u4e00\u4e2a\u53c2\u6570\u6587\u4ef6\uff0c\u518d\u7528expdp\u547d\u4ee4\u8c03\u7528\uff0c\u6216\u8005\u4f7f\u7528\u547d\u4ee4\u884c\u4ea4\u4e92\u5f0f\u7684\u4f7f\u7528\u3002<br \/>\n\u6ce8\u610f\uff1a\u7531\u4e8esysdba\u62e5\u6709\u81ea\u5df1\u7279\u6709\u7684\u5185\u90e8\u51fd\u6570\uff0c\u5e76\u4e14\u5176\u5c06\u4ea7\u751f\u7684\u884c\u4e3a\u4e5f\u548c\u4e00\u822c\u7684\u7528\u6237\u4e0d\u540c\uff0c\u6240\u4ee5\u4e0d\u8981\u4ee5sysdba\u7684\u89d2\u8272\u6267\u884cexpdp\u3002<\/p>\n<p>expdp\u7684\u53c2\u6570\u8bf4\u660e<br \/>\n\u5728\u547d\u4ee4\u884c\u548c\u53c2\u6570\u6587\u4ef6\u4e2d\u53ef\u4ee5\u7528\u4ee5\u4e0b\u53c2\u6570<br \/>\n\u6ce8\uff1auserid\u5fc5\u987b\u5728\u6240\u6709\u53c2\u6570\u524d\u8fb9<br \/>\nCOMPRESSION\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u538b\u7f29dump\u6587\u4ef6\u5927\u5c0f<br \/>\nCONTENT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6307\u5b9a\u5378\u8f7d\u65b9\u5f0f:\u9ed8\u8ba4\u5168\u90e8(ALL)\uff0c\u53ea\u5bfc\u51fa\u6570\u636e\uff08DATA_ONLY\uff09,\u53ea\u5bfc\u51fa\u5143\u6570\u636e\uff08METADATA_ONLY\uff09.<br \/>\nDIRECTORY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6307\u5b9a\u76ee\u5f55<br \/>\nDUMPFILE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6307\u5b9adump\u6587\u4ef6\u540d<br \/>\nENCRYPTION_PASSWORD\u00a0\u00a0 \u6307\u5b9a\u5bc6\u94a5<br \/>\nESTIMATE_ONLY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u53ea\u4f30\u7b97\u8f93\u51fa\u6587\u4ef6\u7684\u5927\u5c0f.<br \/>\nEXCLUDE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6392\u9664\u6307\u5b9a\u7684\u5bf9\u8c61 e.g. EXCLUDE=TABLE:EMP.<br \/>\nFILESIZE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6307\u5b9a\u6bcf\u4e2adump\u6587\u4ef6\u7684\u5927\u5c0f<br \/>\nFULL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u5bfc\u51fa\u6574\u4e2a\u6570\u636e\u5e93\u5e93(N).<br \/>\nHELP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u67e5\u770b\u5e2e\u52a9\u4fe1\u606f (N).<br \/>\nINCLUDE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u5305\u62ec\u6307\u5b9a\u7684\u5bf9\u8c61 e.g. INCLUDE=TABLE_DATA.<br \/>\nJOB_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u521b\u5efajob\u540d\u5b57.<br \/>\nLOGFILE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6307\u5b9a\u65e5\u5fd7\u6587\u4ef6\u540d<br \/>\nNOLOGFILE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u4e0d\u6307\u5b9a\u65e5\u5fd7\u6587\u4ef6 (N).<br \/>\nPARALLEL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u8bbe\u7f6e\u5e76\u884c\u5ea6.<br \/>\nPARFILE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6307\u5b9a\u53c2\u6570\u6587\u4ef6.<br \/>\nQUERY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u4f7f\u7528\u67e5\u8be2\u5b50\u53e5\u5bfc\u51fa\u8868\u7684\u90e8\u5206\u6570\u636e.<br \/>\nSAMPLE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u5bfc\u51fa\u8868\u7684\u6837\u672c\u6570\u636e;<br \/>\nSCHEMAS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u5bfc\u51fa\u6307\u5b9a\u7684schema(login schema).<br \/>\nSTATUS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u591a\u957f\u65f6\u95f4\u663e\u793a\u4e00\u6b21job\u7684\u72b6\u6001default (0).<br \/>\nTABLES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6307\u5b9a\u8868<br \/>\nTABLESPACES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6307\u5b9a\u8868\u7a7a\u95f4<br \/>\nTRANSPORT_TABLESPACES \u6307\u5b9a\u8868\u7a7a\u95f4\u7684\u5143\u6570\u636e\u9700\u8981\u5bfc\u51fa.<\/p>\n<p>\u5e38\u7528\u5bfc\u51fa\u5b9e\u4f8b<br \/>\n<span style=\"color: #ff0000;\">\u00a01.\u5173\u4e8e\u76ee\u5f55<\/span><br \/>\n<span style=\"color: #ff0000;\">\u00a0\u67e5\u770b\u5f53\u524d\u76ee\u5f55\u8bbe\u7f6e<\/span><br \/>\nSQL&gt; SELECT directory_name, directory_path FROM dba_directories WHERE directory_name='DATA_PUMP_DIR';<\/p>\n<p>DIRECTORY_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DIRECTORY_PATH<br \/>\n------------------------------ --------------------------------------------------<br \/>\nDATA_PUMP_DIR\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/app\/oracle\/product\/10.2.0\/db_1\/rdbms\/log\/<\/p>\n<p><span style=\"color: #ff0000;\">\u00a0\u521b\u5efa\u81ea\u5b9a\u4e49\u7684\u76ee\u5f55<\/span><br \/>\n[oracle@ora10gr2 \/]$ cd $ORACLE_BASE<br \/>\n[oracle@ora10gr2 oracle]$ pwd<br \/>\n\/u01\/app\/oracle<br \/>\n[oracle@ora10gr2 oracle]$ cd<br \/>\n[oracle@ora10gr2 ~]$ mkdir $ORACLE_BASE\/dump_dir1<br \/>\n[oracle@ora10gr2 ~]$ exit<br \/>\nexit<\/p>\n<p>SQL&gt; CREATE DIRECTORY DUMP_FILES1 AS '\/u01\/app\/oracle\/dump_dir1';<\/p>\n<p>Directory created.<br \/>\nSQL&gt; SELECT directory_name, directory_path FROM dba_directories WHERE directory_name='DUMP_FILES1';<\/p>\n<p>DIRECTORY_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DIRECTORY_PATH<br \/>\n------------------------------ --------------------------------------------------<br \/>\nDUMP_FILES1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/app\/oracle\/dump_dir1<\/p>\n<p>\u6ce8\uff1a\u5728\u4ee5\u4e0b\u7684\u5b9e\u9a8c\u4e2d\uff0c\u5c06\u4f7f\u7528\u81ea\u5b9a\u4e49\u7684\u76ee\u5f55dump_files1<\/p>\n<p><span style=\"color: #ff0000;\">2.\u9884\u4f30\u5168\u5e93\u5bfc\u51fa\u6587\u4ef6\u7684\u5927\u5c0f<\/span><br \/>\n[oracle@ora10gr2 ~]$ expdp system\/oracle ESTIMATE_ONLY=y full=y<\/p>\n<p>Export: Release 10.2.0.1.0 - Production on Sunday, 13 January, 2013 20:26:01<\/p>\n<p>Copyright (c) 2003, 2005, Oracle.\u00a0 All rights reserved.<\/p>\n<p>Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<br \/>\nWith the Partitioning, OLAP and Data Mining options<br \/>\nFLASHBACK automatically enabled to preserve database integrity.<br \/>\nStarting \"SYSTEM\".\"SYS_EXPORT_FULL_01\":\u00a0 system\/******** ESTIMATE_ONLY=y full=y<br \/>\nEstimate in progress using BLOCKS method...<br \/>\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/TABLE_DATA<br \/>\n.\u00a0 estimated \"OGG\".\"GGS_DDL_HIST\"\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 5 MB<br \/>\n\u7701\u7565\u90e8\u5206\u8f93\u51fa...<br \/>\nTotal estimation using BLOCKS method: 19.18 MB<br \/>\nJob \"SYSTEM\".\"SYS_EXPORT_FULL_01\" successfully completed at 20:26:28<\/p>\n<p><span style=\"color: #ff0000;\">3.\u5168\u5e93\u5bfc\u51fa<\/span><br \/>\n\u6ce8\u610f\uff1a\u5168\u5e93\u5bfc\u51fa\u4e0d\u4f1a\u5305\u542b\u7cfb\u7edf\u7528\u6237\u7684\u5bf9\u8c61\u3002<br \/>\n[oracle@ora10gr2 ~]$ expdp system\/oracle directory=dump_files1 dumpfile=full_exp.dump full=y logfile=full_exp.log<\/p>\n<p>Export: Release 10.2.0.1.0 - Production on Sunday, 13 January, 2013 20:05:53<\/p>\n<p>Copyright (c) 2003, 2005, Oracle.\u00a0 All rights reserved.<\/p>\n<p>Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<br \/>\nWith the Partitioning, OLAP and Data Mining options<br \/>\nFLASHBACK automatically enabled to preserve database integrity.<br \/>\nStarting \"SYSTEM\".\"SYS_EXPORT_FULL_01\":\u00a0 system\/******** directory=dump_files1 dumpfile=full_exp.dump full=y logfile=full_exp.log<br \/>\nEstimate in progress using BLOCKS method...<br \/>\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/TABLE_DATA<br \/>\nTotal estimation using BLOCKS method: 15.68 MB<br \/>\nProcessing object type DATABASE_EXPORT\/TABLESPACE<br \/>\n\u7701\u7565\u90e8\u5206\u8f93\u51fa...<br \/>\nProcessing object type DATABASE_EXPORT\/SCHEMA\/POST_SCHEMA\/PROCACT_SCHEMA<br \/>\n. . exported \"OGG\".\"GGS_DDL_HIST\"\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 558.4 KB\u00a0\u00a0\u00a0\u00a0 206 rows<br \/>\n. . exported \"SYSMAN\".\"MGMT_METRICS\"\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 553.3 KB\u00a0\u00a0\u00a0 2578 rows<br \/>\n. . exported \"SYSMAN\".\"MGMT_HC_OS_COMPONENTS\"\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 202.5 KB\u00a0\u00a0\u00a0\u00a0 720 rows<br \/>\n. . exported \"SYSMAN\".\"MGMT_HC_VENDOR_SW_COMPONENTS\"\u00a0\u00a0\u00a0\u00a0 202.5 KB\u00a0\u00a0\u00a0\u00a0 720 rows<br \/>\n\u7701\u7565\u90e8\u5206\u8f93\u51fa...<br \/>\n. . exported \"TEST\".\"TEST\"\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 5.546 KB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 rows<br \/>\n\u7701\u7565\u90e8\u5206\u8f93\u51fa...<br \/>\n. . exported \"SYSTEM\".\"SQLPLUS_PRODUCT_PROFILE\"\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 KB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 rows<br \/>\n. . exported \"TSMSYS\".\"SRS$\"\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 0 KB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 rows<br \/>\nMaster table \"SYSTEM\".\"SYS_EXPORT_FULL_01\" successfully loaded\/unloaded<br \/>\n******************************************************************************<br \/>\nDump file set for SYSTEM.SYS_EXPORT_FULL_01 is:<br \/>\n\/u01\/app\/oracle\/dump_dir1\/full_exp.dump<br \/>\nJob \"SYSTEM\".\"SYS_EXPORT_FULL_01\" successfully completed at 20:08:45<\/p>\n<p>\u67e5\u770b\u5b9e\u9645\u5bfc\u51fa\u6587\u4ef6\u5927\u5c0f<br \/>\n[oracle@ora10gr2 ~]$ du -sm \/u01\/app\/oracle\/dump_dir1\/full_exp.dump<br \/>\n16\u00a0\u00a0\u00a0\u00a0\u00a0 \/u01\/app\/oracle\/dump_dir1\/full_exp.dump<\/p>\n<p><span style=\"color: #ff0000;\">4.\u5bfc\u51fa\u6307\u5b9a\u7528\u6237\u7684\u6240\u6709\u6570\u636e<\/span><br \/>\n[oracle@ora10gr2 ~]$ expdp system\/oracle directory=dump_files1 dumpfile=schema_exp.dump schemas=test logfile=schema_exp.log<\/p>\n<p>Export: Release 10.2.0.1.0 - Production on Sunday, 13 January, 2013 20:15:04<\/p>\n<p>Copyright (c) 2003, 2005, Oracle.\u00a0 All rights reserved.<\/p>\n<p>Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<br \/>\nWith the Partitioning, OLAP and Data Mining options<br \/>\nFLASHBACK automatically enabled to preserve database integrity.<br \/>\nStarting \"SYSTEM\".\"SYS_EXPORT_SCHEMA_01\":\u00a0 system\/******** directory=dump_files1 dumpfile=schema_exp.dump schemas=test logfile=schema_exp.log<br \/>\nEstimate in progress using BLOCKS method...<br \/>\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE_DATA<br \/>\nTotal estimation using BLOCKS method: 64 KB<br \/>\nProcessing object type SCHEMA_EXPORT\/USER<br \/>\nProcessing object type SCHEMA_EXPORT\/SYSTEM_GRANT<br \/>\nProcessing object type SCHEMA_EXPORT\/ROLE_GRANT<br \/>\nProcessing object type SCHEMA_EXPORT\/DEFAULT_ROLE<br \/>\nProcessing object type SCHEMA_EXPORT\/TABLESPACE_QUOTA<br \/>\nProcessing object type SCHEMA_EXPORT\/PRE_SCHEMA\/PROCACT_SCHEMA<br \/>\nProcessing object type SCHEMA_EXPORT\/TABLE\/TABLE<br \/>\n. . exported \"TEST\".\"TEST\"\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 5.546 KB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 rows<br \/>\nMaster table \"SYSTEM\".\"SYS_EXPORT_SCHEMA_01\" successfully loaded\/unloaded<br \/>\n******************************************************************************<br \/>\nDump file set for SYSTEM.SYS_EXPORT_SCHEMA_01 is:<br \/>\n\/u01\/app\/oracle\/dump_dir1\/schema_exp.dump<br \/>\nJob \"SYSTEM\".\"SYS_EXPORT_SCHEMA_01\" successfully completed at 20:15:23<\/p>\n<p><span style=\"color: #ff0000;\">5.\u5bfc\u51fa\u6307\u5b9a\u7528\u6237\u8868<\/span><br \/>\n[oracle@ora10gr2 ~]$ expdp system\/oracle directory=dump_files1 dumpfile=table_exp.dump tables=test.test logfile=table_exp.log<\/p>\n<p>Export: Release 10.2.0.1.0 - Production on Sunday, 13 January, 2013 20:16:53<\/p>\n<p>Copyright (c) 2003, 2005, Oracle.\u00a0 All rights reserved.<\/p>\n<p>Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<br \/>\nWith the Partitioning, OLAP and Data Mining options<br \/>\nStarting \"SYSTEM\".\"SYS_EXPORT_TABLE_01\":\u00a0 system\/******** directory=dump_files1 dumpfile=table_exp.dump tables=test.test logfile=table_exp.log<br \/>\nEstimate in progress using BLOCKS method...<br \/>\nProcessing object type TABLE_EXPORT\/TABLE\/TABLE_DATA<br \/>\nTotal estimation using BLOCKS method: 64 KB<br \/>\nProcessing object type TABLE_EXPORT\/TABLE\/TABLE<br \/>\n. . exported \"TEST\".\"TEST\"\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 5.546 KB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 rows<br \/>\nMaster table \"SYSTEM\".\"SYS_EXPORT_TABLE_01\" successfully loaded\/unloaded<br \/>\n******************************************************************************<br \/>\nDump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:<br \/>\n\/u01\/app\/oracle\/dump_dir1\/table_exp.dump<br \/>\nJob \"SYSTEM\".\"SYS_EXPORT_TABLE_01\" successfully completed at 20:17:03<\/p>\n<p><span style=\"color: #ff0000;\"> \u00a06.\u5bfc\u51fa\u8868\u7a7a\u95f4<\/span><br \/>\n[oracle@ora10gr2 ~]$ expdp system\/oracle directory=dump_files1 dumpfile=tablespace_exp.dump tablespaces=test logfile=tablespce_exp.log<\/p>\n<p>Export: Release 10.2.0.1.0 - Production on Sunday, 13 January, 2013 20:23:05<\/p>\n<p>Copyright (c) 2003, 2005, Oracle.\u00a0 All rights reserved.<\/p>\n<p>Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<br \/>\nWith the Partitioning, OLAP and Data Mining options<br \/>\nStarting \"SYSTEM\".\"SYS_EXPORT_TABLESPACE_01\":\u00a0 system\/******** directory=dump_files1 dumpfile=tablespace_exp.dump tablespaces=test logfile=tablespce_exp.log<br \/>\nEstimate in progress using BLOCKS method...<br \/>\nProcessing object type TABLE_EXPORT\/TABLE\/TABLE_DATA<br \/>\nTotal estimation using BLOCKS method: 64 KB<br \/>\nProcessing object type TABLE_EXPORT\/TABLE\/TABLE<br \/>\n. . exported \"TEST\".\"TEST\"\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 5.546 KB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 rows<br \/>\nMaster table \"SYSTEM\".\"SYS_EXPORT_TABLESPACE_01\" successfully loaded\/unloaded<br \/>\n******************************************************************************<br \/>\nDump file set for SYSTEM.SYS_EXPORT_TABLESPACE_01 is:<br \/>\n\/u01\/app\/oracle\/dump_dir1\/tablespace_exp.dump<br \/>\nJob \"SYSTEM\".\"SYS_EXPORT_TABLESPACE_01\" successfully completed at 20:23:18<\/p>\n<p><span style=\"color: #ff0000;\">\u00a0\u00a0 \u00a07.\u4f7f\u7528\u53c2\u6570\u6587\u4ef6\u5bfc\u51fa\u7528\u6237\u6307\u5b9a\u8868<\/span><br \/>\n[oracle@ora10gr2 ~]$ cat par.txt<br \/>\ndirectory=dump_files1<br \/>\ndumpfile=table_exp_1.dmp<br \/>\nlogfile=table_exp_1.log<br \/>\ntables=test.test<br \/>\n[oracle@ora10gr2 ~]$ pwd<br \/>\n\/home\/oracle<br \/>\n[oracle@ora10gr2 ~]$ expdp system\/oracle parfile='\/home\/oracle\/par.txt'<\/p>\n<p>Export: Release 10.2.0.1.0 - Production on Sunday, 13 January, 2013 20:40:50<\/p>\n<p>Copyright (c) 2003, 2005, Oracle.\u00a0 All rights reserved.<\/p>\n<p>Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<br \/>\nWith the Partitioning, OLAP and Data Mining options<br \/>\nStarting \"SYSTEM\".\"SYS_EXPORT_TABLE_01\":\u00a0 system\/******** parfile=\/home\/oracle\/par.txt<br \/>\nEstimate in progress using BLOCKS method...<br \/>\nProcessing object type TABLE_EXPORT\/TABLE\/TABLE_DATA<br \/>\nTotal estimation using BLOCKS method: 64 KB<br \/>\nProcessing object type TABLE_EXPORT\/TABLE\/TABLE<br \/>\n. . exported \"TEST\".\"TEST\"\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 5.546 KB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 rows<br \/>\nMaster table \"SYSTEM\".\"SYS_EXPORT_TABLE_01\" successfully loaded\/unloaded<br \/>\n******************************************************************************<br \/>\nDump file set for SYSTEM.SYS_EXPORT_TABLE_01 is:<br \/>\n\/u01\/app\/oracle\/dump_dir1\/table_exp_1.dmp<br \/>\nJob \"SYSTEM\".\"SYS_EXPORT_TABLE_01\" successfully completed at 20:41:00<\/p>\n<p>\uff08\u4e8c\uff09Impdp\u76f8\u5173<br \/>\n1.impdp\u548cexpdp\u7c7b\u4f3c\uff0c\u5177\u4f53\u89c1expdp\u89e3\u91ca<br \/>\nimppdp\u7684\u53c2\u6570\u8bf4\u660e<br \/>\n\u5927\u591a\u6570\u53c2\u6570\u548cexpdp\u4e00\u81f4\uff0c\u4e0b\u8fb9\u5217\u51fa\u4e0d\u4e00\u81f4\u7684\u6bd4\u8f83\u6709\u7279\u70b9\u5e38\u7528\u7684\u53c2\u6570<br \/>\n\u5728\u547d\u4ee4\u884c\u548c\u53c2\u6570\u6587\u4ef6\u4e2d\u53ef\u4ee5\u7528\u4ee5\u4e0b\u53c2\u6570<br \/>\n\u6ce8\uff1auserid\u5fc5\u987b\u5728\u6240\u6709\u53c2\u6570\u524d\u8fb9<br \/>\nCONTENT\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6307\u5b9a\u52a0\u8f7d\u65b9\u5f0f:\u9ed8\u8ba4\u5168\u90e8(ALL)\uff0c\u53ea\u5bfc\u51fa\u6570\u636e\uff08DATA_ONLY\uff09,\u53ea\u5bfc\u51fa\u5143\u6570\u636e\uff08METADATA_ONLY\uff09.<br \/>\nDIRECTORY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6307\u5b9a\u76ee\u5f55<br \/>\nDUMPFILE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6307\u5b9adump\u6587\u4ef6\u540d<br \/>\nENCRYPTION_PASSWORD\u00a0\u00a0 \u6307\u5b9a\u5bc6\u94a5<br \/>\nEXCLUDE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6392\u9664\u6307\u5b9a\u7684\u5bf9\u8c61 e.g. EXCLUDE=TABLE:EMP.<br \/>\nFULL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u5bfc\u51fa\u6574\u4e2a\u6570\u636e\u5e93\u5e93(N).<br \/>\nHELP\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u67e5\u770b\u5e2e\u52a9\u4fe1\u606f (N).<br \/>\nINCLUDE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u5305\u62ec\u6307\u5b9a\u7684\u5bf9\u8c61 e.g. INCLUDE=TABLE_DATA.<br \/>\nJOB_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u521b\u5efajob\u540d\u5b57.<br \/>\nLOGFILE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6307\u5b9a\u65e5\u5fd7\u6587\u4ef6\u540d<br \/>\nNOLOGFILE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u4e0d\u6307\u5b9a\u65e5\u5fd7\u6587\u4ef6 (N).<br \/>\nPARALLEL\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u8bbe\u7f6e\u5e76\u884c\u5ea6.<br \/>\nPARFILE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6307\u5b9a\u53c2\u6570\u6587\u4ef6.<br \/>\nQUERY\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u4f7f\u7528\u67e5\u8be2\u5b50\u53e5\u5bfc\u51fa\u8868\u7684\u90e8\u5206\u6570\u636e.<br \/>\nREMAP_DATAFILE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u4ee5ddl\u91cd\u65b0\u5b9a\u4e49\u6570\u636e\u6587\u4ef6.<br \/>\nREMAP_SCHEMA\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u5c06\u4e00\u4e2aschema\u7684\u6570\u636e\u5bfc\u5165\u5230\u53e6\u4e00\u4e2aschema\u4e2d.<br \/>\nREMAP_TABLESPACE\u00a0\u00a0\u00a0\u00a0\u00a0 \u5c06\u8868\u7a7a\u95f4\u5bf9\u8c61\u52a0\u8f7d\u5230\u5176\u4ed6\u8868\u7a7a\u95f4.<br \/>\nREUSE_DATAFILES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u91cd\u65b0\u521d\u59cb\u5316\u5df2\u5b58\u5728\u7684\u6570\u636e\u6587\u4ef6 (N).<br \/>\nSKIP_UNUSABLE_INDEXES \u8df3\u8fc7\u4e0d\u53ef\u7528\u7684\u7d22\u5f15.<br \/>\nSQLFILE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u5c06\u6240\u6709\u7684ddl\u7684sql\u5199\u5165\u5230\u6307\u5b9a\u6587\u4ef6.<br \/>\nTABLE_EXISTS_ACTION\u00a0\u00a0 \u8868\u5df2\u5b58\u5728\u53ef\u4ee5\u91c7\u53d6\u7684\u63aa\u65bd:(SKIP), APPEND, REPLACE and TRUNCATE.<br \/>\nSTATUS\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u591a\u957f\u65f6\u95f4\u663e\u793a\u4e00\u6b21job\u7684\u72b6\u6001default (0).<br \/>\nTABLES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6307\u5b9a\u8868<br \/>\nTABLESPACES\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u6307\u5b9a\u8868\u7a7a\u95f4<br \/>\nTRANSPORT_TABLESPACES \u6307\u5b9a\u8868\u7a7a\u95f4\u7684\u5143\u6570\u636e\u9700\u8981\u5bfc\u5165.<\/p>\n<p>\u5e38\u7528\u5bfc\u5165\u5b9e\u4f8b<\/p>\n<p><span style=\"color: #ff0000;\">\u00a02.\u5168\u5e93\u5bfc\u5165<\/span><br \/>\n\u6a21\u62df\u5220\u9664\u7528\u6237<br \/>\nSQL&gt; select a.*,to_char(inserttime,'yyyy\/mm\/dd hh24:mi:ss') from test.test a;<\/p>\n<p>ID NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 INSERTTIM TO_CHAR(INSERTTIME,<br \/>\n---------- -------------------- --------- -------------------<br \/>\n1 yallonking\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13-JAN-13 2013\/01\/13 19:56:39<\/p>\n<p>SQL&gt; drop user test cascade;<\/p>\n<p>User dropped.<br \/>\n[oracle@ora10gr2 ~]$ impdp system\/oracle dumpfile=dump_files1:full_exp.dump full=y logfile=full_imp.log<\/p>\n<p>Import: Release 10.2.0.1.0 - Production on Sunday, 13 January, 2013 22:59:40<\/p>\n<p>Copyright (c) 2003, 2005, Oracle.\u00a0 All rights reserved.<\/p>\n<p>Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<br \/>\nWith the Partitioning, OLAP and Data Mining options<br \/>\nMaster table \"SYSTEM\".\"SYS_IMPORT_FULL_01\" successfully loaded\/unloaded<br \/>\nStarting \"SYSTEM\".\"SYS_IMPORT_FULL_01\":\u00a0 system\/******** directory=dump_files1 dumpfile=full_exp.dump full=y logfile=full_imp.log<br \/>\nProcessing object type DATABASE_EXPORT\/TABLESPACE<br \/>\nORA-31684: Object type TABLESPACE:\"UNDOTBS1\" already exists<br \/>\nORA-31684: Object type TABLESPACE:\"SYSAUX\" already exists<br \/>\nORA-31684: Object type TABLESPACE:\"TEMP\" already exists<br \/>\nORA-31684: Object type TABLESPACE:\"USERS\" already exists<br \/>\nORA-31684: Object type TABLESPACE:\"TEST\" already exists<br \/>\n\u7701\u7565\u90e8\u5206\u8f93\u51fa...<br \/>\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/POST_INSTANCE\/PROCACT_INSTANCE<br \/>\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/POST_INSTANCE\/PROCDEPOBJ<br \/>\nProcessing object type DATABASE_EXPORT\/SCHEMA\/POST_SCHEMA\/PROCOBJ<br \/>\nProcessing object type DATABASE_EXPORT\/SCHEMA\/POST_SCHEMA\/PROCACT_SCHEMA<br \/>\nJob \"SYSTEM\".\"SYS_IMPORT_FULL_01\" completed with 2744 error(s) at 23:05:40<\/p>\n<p>[oracle@ora10gr2 ~]$ sqlplus \"\/as sysdba\"<\/p>\n<p>SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jan 13 23:12:08 2013<\/p>\n<p>Copyright (c) 1982, 2005, Oracle.\u00a0 All rights reserved.<\/p>\n<p>Connected to:<br \/>\nOracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<br \/>\nWith the Partitioning, OLAP and Data Mining options<\/p>\n<p>SQL&gt; select a.*,to_char(inserttime,'yyyy\/mm\/dd hh24:mi:ss') from test.test a;<\/p>\n<p>ID NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 INSERTTIM TO_CHAR(INSERTTIME,<br \/>\n---------- -------------------- --------- -------------------<br \/>\n1 yallonking\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13-JAN-13 2013\/01\/13 19:56:39<\/p>\n<p><span style=\"color: #ff0000;\">\u00a0\u00a0 \u00a03.\u5c06\u7528\u6237\u8868\u5bfc\u5165\u5230\u5176\u4ed6\u7528\u6237\u4e0b<\/span><br \/>\nSQL&gt; conn \/as sysdba<br \/>\nConnected.<br \/>\nSQL&gt; select a.*,to_char(inserttime,'yyyy\/mm\/dd hh24:mi:ss') from test.test a;<\/p>\n<p>ID NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 INSERTTIM TO_CHAR(INSERTTIME,<br \/>\n---------- -------------------- --------- -------------------<br \/>\n1 yallonking\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13-JAN-13 2013\/01\/13 19:56:39<\/p>\n<p>SQL&gt; select a.*,to_char(inserttime,'yyyy\/mm\/dd hh24:mi:ss') from test1.test a;<br \/>\nselect a.*,to_char(inserttime,'yyyy\/mm\/dd hh24:mi:ss') from test1.test<br \/>\n*<br \/>\nERROR at line 1:<br \/>\nORA-00942: table or view does not exist<br \/>\n\u6b64\u5904\u5c06\u8868test\u7684\u6570\u636e\u5bfc\u5165\u5230\u7528\u6237test\u4e0b<br \/>\n[oracle@ora10gr2 ~]$ impdp system\/oracle dumpfile=dump_files1:full_exp.dump REMAP_SCHEMA=test:test1 logfile=user_imp1.log<br \/>\n\u6216\u8005\u4ece\u5bfc\u51fa\u7684\u7528\u6237\u6570\u636e\u7684dump\u5bfc\u5165<br \/>\n[oracle@ora10gr2 ~]$ impdp system\/oracle dumpfile=dump_files1:schema_exp.dump REMAP_SCHEMA=test:test1 logfile=schema_imp.log<br \/>\n\u6216\u8005\u4ece\u5bfc\u51fa\u7684\u8868\u6570\u636e\u7684dump\u5bfc\u5165<br \/>\n[oracle@ora10gr2 ~]$ impdp system\/oracle dumpfile=dump_files1:table_exp.dump REMAP_SCHEMA=test:test1 logfile=table_imp.log<br \/>\nImport: Release 10.2.0.1.0 - Production on Monday, 14 January, 2013 0:56:19<\/p>\n<p>Copyright (c) 2003, 2005, Oracle.\u00a0 All rights reserved.<\/p>\n<p>Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<br \/>\nWith the Partitioning, OLAP and Data Mining options<br \/>\nMaster table \"SYSTEM\".\"SYS_IMPORT_FULL_01\" successfully loaded\/unloaded<br \/>\nStarting \"SYSTEM\".\"SYS_IMPORT_FULL_01\":\u00a0 system\/******** dumpfile=dump_files1:table_exp.dump REMAP_SCHEMA=test:test1 logfile=table_imp.log<br \/>\nProcessing object type TABLE_EXPORT\/TABLE\/TABLE<br \/>\nProcessing object type TABLE_EXPORT\/TABLE\/TABLE_DATA<br \/>\n. . imported \"TEST1\".\"TEST\"\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 5.546 KB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 rows<br \/>\nJob \"SYSTEM\".\"SYS_IMPORT_FULL_01\" successfully completed at 00:56:24<\/p>\n<p>SQL&gt; select a.*,to_char(inserttime,'yyyy\/mm\/dd hh24:mi:ss') from test1.test a;<\/p>\n<p>ID NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 INSERTTIM TO_CHAR(INSERTTIME,<br \/>\n---------- -------------------- --------- -------------------<br \/>\n1 yallonking\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 13-JAN-13 2013\/01\/13 19:56:39<\/p>\n<p><span style=\"color: #ff0000;\">\u00a0 4.\u5bfc\u5165\u7528\u6237\u8868\u5230\u522b\u7684\u8868\u7a7a\u95f4<\/span><br \/>\n\u9996\u5148\u67e5\u770btest\u8868\u5728\u90a3\u4e2a\u8868\u7a7a\u95f4\uff0c\u5e76\u65b0\u5efa\u4e00\u4e2a\u8868\u7a7a\u95f4test1<br \/>\nSQL&gt; select OWNER,TABLE_NAME,TABLESPACE_NAME from dba_tables where TABLE_NAME='TEST';<\/p>\n<p>OWNER\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 TABLE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TABLESPACE_NAME<br \/>\n------------------------------ ------------------------------ ------------------------------<br \/>\nTEST\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 TEST\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 TEST<\/p>\n<p>SQL&gt; create tablespace test1 datafile '\/tmp\/test1.dbf' size 10m;<\/p>\n<p>Tablespace created.<br \/>\nSQL&gt; conn test\/test<br \/>\nConnected.<br \/>\nSQL&gt; drop table test;<\/p>\n<p>Table dropped.<br \/>\nSQL&gt; select OWNER,TABLE_NAME,TABLESPACE_NAME from dba_tables where TABLE_NAME='TEST';<\/p>\n<p>no rows selected<br \/>\n[oracle@ora10gr2 ~]$ impdp system\/oracle directory=dump_files1 dumpfile=tablespace_exp.dump REMAP_TABLESPACE=test:test1<\/p>\n<p>Import: Release 10.2.0.1.0 - Production on Monday, 14 January, 2013 1:10:15<\/p>\n<p>Copyright (c) 2003, 2005, Oracle.\u00a0 All rights reserved.<\/p>\n<p>Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production<br \/>\nWith the Partitioning, OLAP and Data Mining options<br \/>\nMaster table \"SYSTEM\".\"SYS_IMPORT_FULL_01\" successfully loaded\/unloaded<br \/>\nStarting \"SYSTEM\".\"SYS_IMPORT_FULL_01\":\u00a0 system\/******** directory=dump_files1 dumpfile=tablespace_exp.dump REMAP_TABLESPACE=test:test1<br \/>\nProcessing object type TABLE_EXPORT\/TABLE\/TABLE<br \/>\nProcessing object type TABLE_EXPORT\/TABLE\/TABLE_DATA<br \/>\n. . imported \"TEST\".\"TEST\"\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 5.546 KB\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 rows<br \/>\nJob \"SYSTEM\".\"SYS_IMPORT_FULL_01\" successfully completed at 01:10:36<\/p>\n<p>SQL&gt; select OWNER,TABLE_NAME,TABLESPACE_NAME from dba_tables where TABLE_NAME='TEST';<\/p>\n<p>OWNER\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 TABLE_NAME\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 TABLESPACE_NAME<br \/>\n------------------------------ ------------------------------ ------------------------------<br \/>\nTEST\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 TEST\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 TEST1<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data Pump Export\/Impdp\u64cd\u4f5c\u5b9e\u4f8b \uff08\u4e00\uff09Expdp\u76f8\u5173\u00a0\u00a0 \u00a0expdp\u662f\u5c06\u6570\u636e\u6216\u8005\u5143\u6570\u636e [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[40,32],"tags":[54,53,52,50,51,49],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/591"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=591"}],"version-history":[{"count":7,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/591\/revisions"}],"predecessor-version":[{"id":597,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/591\/revisions\/597"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=591"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=591"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=591"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}