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 fai...
ORA-31693 是Oracle 数据库中的一个错误代码,它通常与数据泵(Data Pump)操作相关。这个错误表明在尝试使用数据泵导入(impdp)或导出(expdp)数据时遇到了问题,具体是因为无法找到指定的日志文件或目录对象。 1. 错误代码确认 ORA-31693 是一个特定的 Oracle 错误代码,用于指示与数据泵操作相关的日志文件或目录对象问题...
把table_exists_action参数值改成replace参数后,不用disable也不用drop触发器,就能成功 impdp \"/ as sysdba\" directory=dir_dump dumpfile=u_tables_03_jdedb_202206_%U.dump parallel=6 tables= PROD.TAB1001, PROD.TAB1002, PROD.TAB1003 logfile=impdp_tables_03_202206.log CLUSTER=n table_exists_actio...
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 fai...
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 ...
加上cluster=N解决: nohup impdp HQ_X1/HQ_X1 DUMPFILE=HQ_X1%u.DMP transform=oid:n DIRECTORY=dir1 parallel=8 cluster=n& 相比于exp/imp来,expdp/impdp的BUG似乎有点多。
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
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"...
总结:可能是底层存储比较差,集群光纤卡性能差,导致oracle的dmp文件在expdp或impdp时(适用dblink远程expdp时,该集群也是报ORA-31693&ORA-31640&ORA-19505&ORA-27037) 出现无法正确写或读取到dmp文件。以后再做类似工作的时候,要考虑并行是否适用。
impdp导入数据过程报错ORA-31693 经过高级工程师确认该表是外部表expdp未能导出来,impdp导入时自然也就报错了。 参考:http://blog.sina.com.cn/s/blog_61c44d780102w343.html exp user/passwd@IP:1521/testdb parfile=/path/par.file