Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]: ORA-31693, ORA-29913, ORA-29400, ORA-26010 During IMPDP
这个语句就报错: ORA-29913 ORA-31693 ORA-01861 查看了一下METALINK 发现没有相关的文章。一般都是parallel在RAC中的问题。 抓狂了一段时候后发现我们的raw_add_time是timestamp类型, 随后修改导入语句如下: impdp secdata/gelc123 job_name=sec_dmp tables=seccore.syn_event remap_schema=seccore:secdata du...
外键约束导致impdp报错。取消外键约束,导入后添加外键约束。 ORA-31693: Table data object "TEST"."T_ITE" failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-02291: integrity constraint (TEST.FK_ITE_REF_PSR) violated - parent ke...
(2) 主外键关联 ORA-31693: Table data object "TEST"."T_ITE" failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-02291: integrity constraint (TEST.FK_ITE_REF_PSR) violated - parent key not found 由于有些表之间是存在主外...
分别有ORA-31693,ORA-29913,ORA-02291三个错误 2. 原因查找 2.1 查看错误代码 首先我们分别查看该报错的内容 通过ORA-02291错误内容我们可以看到是由子该表外键的值和主表的不栏位不匹配 建议的动作为删除子表外键或者主表新增相关的值 问题是为什么主表会找不到匹配的呢?
oracle impdp导入数据报ora-29913、ora-31640 环境:aix6.1、oracleRAC11.2.4 impdp导入报 ORA-29913: 执行 ODCIEXTTABLEPOPULATE 调出时出错 impdp XSFX/XSFX DIRECTORY=DIR_IMPDP DUMPFILE=tb_uu%U.dmp PARALLEL=5 REMAP_SCHEMA=EIC_XSJS:XSF X remap_tablespace=TSP_XSJS:USERS Import: Release 11.2.0.1.0 ...
ORA-31693: Table data object "TEST"."T_ITE" failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-02291: integrity constraint (TEST.FK_ITE_REF_PSR) violated - parent key not found ...
ORA-31693:Table data object "TEST"."T_ITE" failed to load/unload and is being skipped due to error: ORA-29913:error in executing ODCIEXTTABLEFETCH callout ORA-02291:integrity constraint (TEST.FK_ITE_REF_PSR) violated parent key not found ...
ORA-31693: Table data object “TEST”.“T_ITE” failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-02291: integrity constraint (TEST.FK_ITE_REF_PSR) violated parent key not found ...
ORA-31693: Table data object "SCOTT"."EMP" failed to load/unload and is being skipped due to error: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-00001: unique constraint (SCOTT.EMP_ENAME) violated Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX ...