IMPDP system/system directory=IMPDP_DIR dumpfile=IMPDP_DIR:EXPDP_FULL.dmp schemas=MAP logfile=IMPDP_DIR:IMPDP_MAP.log job_name=IMPDP_MAP The import fails and reports the following error message: "Processing object type TABLE_EXPORT/TABLE/TABLE_DATA ORA-31693: Table data object "MAP"."PARCELS"...
ORA-31693 是Oracle 数据库中的一个错误代码,它通常与数据泵(Data Pump)操作相关。这个错误表明在尝试使用数据泵导入(impdp)或导出(expdp)数据时遇到了问题,具体是因为无法找到指定的日志文件或目录对象。 1. 错误代码确认 ORA-31693 是一个特定的 Oracle 错误代码,用于指示与数据泵操作相关的日志文件或目录对象问题...
ORA-31693: Table data object " PROD"."TAB1003" failed to load/unload and is being skipped due to error: ORA-04098: trigger ' PROD.F58C0210 _CFRA_RIA' is invalid and failed re-validation ORA-31693: Table data object " PROD"."TAB1001" failed to load/unload and is being skipped due...
IMPDP system/system directory=IMPDP_DIR dumpfile=IMPDP_DIR:EXPDP_FULL.dmp schemas=MAP logfile=IMPDP_DIR:IMPDP_MAP.log job_name=IMPDP_MAP The import fails and reports the following error message: "Processing object type TABLE_EXPORT/TABLE/TABLE_DATA ORA-31693: Table data object "MAP"."PARCELS"...
impdp报错:ORA-31693, ORA-02354, ORA-00600 Problem: Importing an Oracle 11g R2 Data Pump file containing an ArcSDE 10.x geodatabase encounters Oracle errors ORA-31693, ORA-02354, ORA-00600 Description Importing an Oracle 11g R2 Data Pump export file containing a ArcSDE 10.x geodatabase ...
外键约束导致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...
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" 无法加载/卸载并且被...
Oracle Database - Enterprise Edition - Version 10.2.0.5 and later: Impdp Fails ORA-31693: Table Data Object Failed To Load/unload And Is Being Skip
简介:今天,安装完了衡阳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。具体的报错信息如下: ...
IMPDP system/system directory=IMPDP_DIR dumpfile=IMPDP_DIR:EXPDP_FULL.dmp schemas=MAP logfile=IMPDP_DIR:IMPDP_MAP.log job_name=IMPDP_MAP The import fails and reports the following error message:"Processing object type TABLE_EXPORT/TABLE/TABLE_DATA ORA-31693: Table data object "MAP"...