ORA-31693: Table data object "MAP"."PARCELS" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-00600: internal error code, arguments: [kpudpxcs_ctxConvertStream_ref_1], [SYS_TYPEID("SHAPE")], [], [], [], [], [], [], ...
一、问题描述 在对三张具有触发器的表进行导入数据时,一直提示ORA-31693 ORA-04098报错,表被跳过无法导入。后尝试过truncate表,disable和drop触发器,导入均提示ORA-31693 ORA-04098,表的数据无法导入。最后,使用参数table_exists_action=REPLACE,数据成功导入。 二、问题现象 因为目标数据库表已经存在,导入时使用参数t...
ORA-31693: Table data object "MAP"."PARCELS" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-00600: internal error code, arguments: [kpudpxcs_ctxConvertStream_ref_1], [SYS_TYPEID("SHAPE")], [], [], [], [], [], [], ...
ORA-31693: Table data object "SDE"."GDB_ITEMS" failed to load/unload and is being skipped due to error: ORA-02354: error in exporting/importing data ORA-00600: internal error code, arguments: [kpudpxcs_ctxConvertStream_ref_1], [SYS_TYPEID("SHAPE")], [], [], [], [], [], []...
ORA-31693: Table data object "<schema>"."" failed to load/unload and is being skipped due to error:ORA-20001: 43ORA-04092: cannot ROLLBACK in a triggerORA-00001: unique constraint (<schema>.<constraint_name>) violated--- PL/SQL Call Stack --- object line object handle number name3...
impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 在impdp时遇到报错: Additional information: 3 . . 导入了 "HQ_X1"."T_XX130901":"SP15" 13.99 KB 0 行 . . 导入了 "HQ_X1"."T_XX130901":"SP2" 13.99 KB 0 行 ORA-31693: 表数据对象 "HQ_X1"."TEMP_YEAR_MONTH" 无法加载/卸载并且被...
ORA-31693: Table data object "MAP"."PARCELS" failed to load/unload and is being skipped due to error:ORA-02354: error in exporting/importing data ORA-00600: internal error code, arguments: [kpudpxcs_ctxConvertStream_ref_1], [SYS_TYPEID("SHAPE")], [], [], [], [], []...
ORA-31693: Table data object "<SCHEMA_NAME>"."<TABLE_NAME1>":"<PARTITION_NAME3>" failed to load/unload and is being skipped due to error: ORA-14400: inserted partition key does not map to any partition . . imported "<SCHEMA_NAME>"."<TABLE_NAME1>":"<PARTITION_NAME4>" 12.77 GB ...
外键约束导致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...
简介:今天,安装完了衡阳ORACLE 11.2.0.4 rac for RHEL6.8集群后,做数据迁移的时候,碰到了expdp报错: ORA-31693&ORA-31640&ORA-19505&ORA-27037。 今天,安装完了衡阳ORACLE 11.2.0.4 rac for RHEL6.8集群后,做数据迁移的时候,碰到了expdp报错: ORA-31693&ORA-31640&ORA-19505&ORA-27037。具体的报错信息如下: ...