将partition expdp后impdp

 将partition table中的单个partition expdp之后，impdp到其他的database table中，需要使用到关键字:table_exists_action=append

C:\Users\Admin.LONG1-LI>expdp scott/bruce123 directory=temp_dir dumpfile=part1_p4.dmp tables=(part1:p4)

Export: Release 10.2.0.1.0 - Production on Monday, 19 October, 2015 10:02:51

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "SCOTT"."SYS_EXPORT_TABLE_01":  scott/******** directory=temp_dir dumpfile=part1_p4.dmp tables=(part1:p4)
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 256 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "SCOTT"."PART1":"P4"                        141.8 KB   10001 rows
Master table "SCOTT"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SCOTT.SYS_EXPORT_TABLE_01 is:
  E:\APP\BRUCE\PART1_P4.DMP
Job "SCOTT"."SYS_EXPORT_TABLE_01" successfully completed at 10:02:59

C:\Users\is_long_li>sqlplus scott/bruce123
SQL*Plus: Release 10.2.0.1.0 - Production on 星期一 10月 19 10:05:33 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> alter table part1 add partition p4 values less than(150000);

表已更改。

SQL> exit
从 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options 断开

C:\Users\is_long_li>impdp scott/bruce123 directory=temp_dir dumpfile=part1_p4.dmp table_exists_action=append

Import: Release 10.2.0.1.0 - Production on 星期一, 19 10月, 2015 10:05:59

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

连接到: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
已成功加载/卸载了主表 "SCOTT"."SYS_IMPORT_FULL_01"
启动 "SCOTT"."SYS_IMPORT_FULL_01":  scott/******** directory=temp_dir dumpfile=part1_p4.dmp table_exists_action=append
处理对象类型 TABLE_EXPORT/TABLE/TABLE
ORA-39152: 表 "SCOTT"."PART1" 已存在。由于附加了 table_exists_action, 数据将附加到现有表, 但是将跳过所有相关元数据。
处理对象类型 TABLE_EXPORT/TABLE/TABLE_DATA
. . 导入了 "SCOTT"."PART1":"P4"                        141.8 KB   10001 行
作业 "SCOTT"."SYS_IMPORT_FULL_01" 已经完成, 但是有 1 个错误 (于 10:06:03 完成)

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24237320/viewspace-1814881/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24237320/viewspace-1814881/