Oracle11gR2 11.2.0.1 + AIX6.1 + RAC

   将一张表从RAC导出，导入另一单点数据库，导入的过程中出错：

cargo03:oracle$ impdp system/cdasdf parfile='/oracle/dp/t_shark_agent.prm'

Import: Release 11.2.0.1.0 - Production on Wed Aug 24 16:38:46 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning and Real Application Testing options
Master table "SYSTEM"."T_SHARK_AGENT" successfully loaded/unloaded
Starting "SYSTEM"."T_SHARK_AGENT":  system/******** parfile=/oracle/dp/t_shark_agent.prm
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39152: Table "MUHIS"."T_SHARK_AGENT" exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-31693: Table data object "MUHIS"."T_SHARK_AGENT" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYSTEM"."T_SHARK_AGENT" completed with 2 error(s) at 16:38:52

参数文件内容：

DIRECTORY=DUMP_DIR
DUMPFILE=t_shark_agent.dmp
TABLES=mu.t_shark_agent
logfile=IMP_t_shark_agent.log
REMAP_SCHEMA=MU:MUHIS
QUERY=t_shark_flt:"where flight_date <= '2010-04-31'" 
PARALLEL=4
JOB_NAME=t_shark_agent
table_exists_action=APPEND

解决方案：

将并行度设为1，PARALLEL=1

然后执行导入：

cargo03:oracle$ impdp system/cdasdf parfile='/oracle/dp/t_shark_agent.prm'

Import: Release 11.2.0.1.0 - Production on Wed Aug 24 16:43:35 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning and Real Application Testing options
Master table "SYSTEM"."T_SHARK_AGENT" successfully loaded/unloaded
Starting "SYSTEM"."T_SHARK_AGENT":  system/******** parfile=/oracle/dp/t_shark_agent.prm
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39152: Table "MUHIS"."T_SHARK_AGENT" exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "MUHIS"."T_SHARK_AGENT"                     541.4 MB 6983537 rows
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SYSTEM"."T_SHARK_AGENT" completed with 1 error(s) at 16:43:55

导入成功。。。

有一点，这个是从RAC中导出，导入到单点的情况，出现这样的错误。之前在RAC中导出，然后再导入RAC的另一Schema中并没有上述错误，并行度设置也是为4，这里还不确定具体原因，需要进一步研究。