合 imp-00051,imp-00008
Tags: Oracle
- 1.2 故障分析及解决过程
- 1.3 MOS
- 1.3.1 ALERT Direct Path Export (EXP) Corrupts The Dump If An Empty Table Partition Exists (文档 ID 1604983.1)
- APPLIES TO:
- DESCRIPTION
- OCCURRENCE
- SYMPTOMS
- WORKAROUND
- HISTORY
- REFERENCES
- 1.3.2 Traditional Import (IMP) Raises Error IMP-51 Direct Path Exported Dump File Contains Illegal Column Length (文档 ID 1403865.1)
- APPLIES TO:
- SYMPTOMS
- CAUSE
- SOLUTION
1.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
[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参数。