oracle impdp问题

sunnyxjl 2009-10-21 02:06:01

我用impdp 导入数据时报下面错误:
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "EPMA"."A_ACCT_BAL":"A_ACCT_SZ" 108.7 MB 2837822 out of 2837929 rows
. . imported "EPMA"."A_ACCT_BAL":"A_ACCT_NJ" 70.66 MB 1883142 out of 1883217 rows
. . imported "EPMA"."A_ACCT_BAL":"A_ACCT_WX" 74.40 MB 1931233 out of 1931339 rows
ORA-31693: Table data object "EPMA"."A_ACCT_BAL":"A_ACCT_NT" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-14400: inserted partition key does not map to any partition
. . imported "EPMA"."A_ACCT_BAL":"A_ACCT_TZ" 62.30 MB 1609448 out of 1609473 rows
ORA-31693: Table data object "EPMA"."A_ACCT_BAL":"A_ACCT_YC" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-14400: inserted partition key does not map to any partition
. . imported "EPMA"."A_ACCT_BAL":"A_ACCT_HA" 55.13 MB 1427215 out of 1427223 rows...
.......
不知道ORA-29913错误怎么解决? 谢谢!!!

...全文

375 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

shuiqingtinglin 2009-10-21

打赏
举报

应该是你导入的表中数据有不符合表的分区条件的非法数据吧

Dave 2009-10-21

打赏
举报

ORA-14400: inserted partition key does not map to any partition

ORA-31693: Table data object "EPMA"."A_ACCT_BAL":"A_ACCT_NT" failed to load/unload and is being skipped due to error:

数据库中存在分区表A_ACCT_BAL，导入的数据库也有同名的表，但结构不一样. 有冲突..
把A_ACCT_BAL表删了在导入 .

sunnyxjl 2009-10-21