oracle39151错误,从dump文件中导入一张表时报 ORA-39151错误

用impdp命令从一个全schema的dump文件中 导入其中一张表的过程： 首先用下面命令实验， -bash-3.2$ impdp system/oracle005@SELADEVS directory=DB_BAK dumpfile=PROD_SELAPRODS_SIEBEL_20130905.dmp tables=SIEBE                                          L.s_per_resp  logfile=s_per_resp.imp.log Import: Release 11.2.0.3.0 - Production on Fri Sep 6 11:23:46 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Master table "SYSTEM"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_TABLE_01":  system/********@SELADEVS directory=DB_BAK dumpfile=PROD_SELAPRODS_SIEBEL_2                                          0130905.dmp tables=SIEBEL.s_per_resp logfile=s_per_resp.imp.log Processing object type SCHEMA_EXPORT/TABLE/TABLE ORA-39151: Table "SIEBEL"."S_PER_RESP" exists. All dependent metadata and data will be skipped due to table_exists_a                                          ction of skip Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Job "SYSTEM"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 11:24:01 结果报ORA-39151错误 网上查了些资料，在后面加上两个参数 SKIP_UNUSABLE_INDEXES=Y TABLE_EXISTS_ACTION=SKIP SKIP_UNUSABLE_INDEXED 是否跳过不可使用的索引 TABLE_EXISTS_ACTION 当表已存在是执行的操作 skip|append|truncate|replace 运行结果如下： -bash-3.2$ impdp system/oracle005@SELADEVS directory=DB_BAK dumpfile=PROD_SELAPRODS_SIEBEL_20130905.dmp tables=SIEBE                                          L.s_per_resp  logfile=s_per_resp.imp.log SKIP_UNUSABLE_INDEXES=Y TABLE_EXISTS_ACTION=SKIP Import: Release 11.2.0.3.0 - Production on Fri Sep 6 11:36:18 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Master table "SYSTEM"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_TABLE_01":  system/********@SELADEVS directory=DB_BAK dumpfile=PROD_SELAPRODS_SIEBEL_2                                          0130905.dmp tables=SIEBEL.s_per_resp logfile=s_per_resp.imp.log SKIP_UNUSABLE_INDEXES=Y TABLE_EXISTS_ACTION=SKIP Processing object type SCHEMA_EXPORT/TABLE/TABLE Table "SIEBEL"."S_PER_RESP" exists. All dependent metadata and data will be skipped due to table_exists_action of sk                                          ip Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Job "SYSTEM"."SYS_IMPORT_TABLE_01" successfully completed at 11:36:26 结果显示，报错是没有了，但到表中查数据，记录根本没导进来， 后来研究了一下加的两个参数，发现把TABLE_EXISTS_ACTION 改成truncate模式，数据就导进来了， -bash-3.2$ impdp system/oracle005@SELADEVS directory=DB_BAK dumpfile=PROD_SELAPRODS_SIEBEL_20130905.dmp tables=SIEBE                                          L.s_per_resp  logfile=s_per_resp.imp.log SKIP_UNUSABLE_INDEXES=Y TABLE_EXISTS_ACTION=TRUNCATE Import: Release 11.2.0.3.0 - Production on Fri Sep 6 11:46:26 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Master table "SYSTEM"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_TABLE_01":  system/********@SELADEVS directory=DB_BAK dumpfile=PROD_SELAPRODS_SIEBEL_2                                          0130905.dmp tables=SIEBEL.s_per_resp logfile=s_per_resp.imp.log SKIP_UNUSABLE_INDEXES=Y TABLE_EXISTS_ACTION=TRUNCATE                                           Processing object type SCHEMA_EXPORT/TABLE/TABLE Table "SIEBEL"."S_PER_RESP" exists and has been truncated. Data will be loaded but all dependent metadata will be sk                                          ipped due to table_exists_action of truncate Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA . . imported "SIEBEL"."S_PER_RESP"                       140.8 KB    1481 rows Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Job "SYSTEM"."SYS_IMPORT_TABLE_01" successfully completed at 11:46:37