我用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错误怎么解决? 谢谢!!!
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错误怎么解决? 谢谢!!!
解决方案 »
- ORA-01126: 数据库必须已装载到此实例并且不在任何实例中打开
- 如何回收lob字段所占用的空间?
- 紧急求助:如何在存储过程中处理CLOB[网上没查到……]
- 请教ado连接Oracle数据库时,日期精度变化的问题
- 如何用php调用oracle存储过程
- Oracle.DataAccess.Client.OracleException ORA-06550: 第 1 行, 第 7 列: PLS-00103: 出现符号 "{"在需要下列之一时: 错误是什么原因?
- oracle xpath 定位 操作xml节点
- 重启ORACLE服务遇到的问题 错误代码183
- Oracle9.01能直接升级到9.2吗?
- redhat 9 安装oracle8.1.7问题!
- oracle 发邮件错误
- 急dataset的问题
把A_ACCT_BAL表删了在导入 .