合 IMP-00051: Direct path exported dump file contains illegal column length和IMP-00008: unrecognized statement in the export file
Tags： OracleIMP-00051IMP-00008
👉 本文共约424个字，系统预计阅读时间或需2分钟。
故障分析及解决过程
imp导入报错：
IMP-00051: Direct path exported dump file contains illegal column length
IMP-00008: unrecognized statement in the export file
IMP-00009: abnormal end of export file
1 2 3 4 5 6 7 8 9 | [oracle@lhrdb ~]$ oerr imp 51 00051, 00000, "Direct path exported dump file contains illegal column length" // *Cause: An invalid column length was encountered while processing column // pieces." // *Action: Check to make sure the export file is not corrupted, or else // report this to Oracle Worldwide Support as an Import/Export // internal bug and submit the // export file. |
由于使用了direct=y的方式导出，所以导入的时候报错。MOS上是针对分区表的某一个空的分区导入的时候会报该错，但是客户这边的表不是分区表，dmp文件太大，不能做具体原因分析。给出的解决方案为：针对报错的表单独导出，并采用parfile参数。
1 2 3 4 | [ZFZHLHRDB1:oracle]:/oracle>more /tmp/scottfile.par tables=scott.emp,scott.dept exp \'/ AS SYSDBA\' file=/tmp/test_query_lhr_scott_01.dmp parfile=/tmp/scottfile.par log=/tmp/test_query_lhr_scott_01.log |
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信dbaup66，谢谢！
