Export Error
Oracle Version- 10.2.0.4
I Have taken an export of a particular user which dump size is nearly to 14 gb.
While I am importing it , i got an import error which says ,
illegal lob length marker 65279
bytesread = 00000000000
TABLE =cm_test
IMP-00098: INTERNAL ERROR: impgst2
IMP-00018: partial import of previous table completed: 2031183 rows imported
IMP-00008: unrecognized statement in the export file:
ÿþÿþÿþÿ
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
IMP-00008: unrecognized statement in the export file:
All the googles and forums mentioned that the export dump file is corrupted .
So later i have taken an export once again with the large buffer size (buffer=300000000)
And then the export has been taken successfully ,
Later i try to import it by setting the same buffer parameter (buffer=300000000) and the import error message seems to be vanished .
This same issue is been reported as a Bug by oracle support in 10.1.0.3, But this bug has been fixed in 10.1.0.4 and Later.
Bug no: 3890213 IMP-98 possible importing zero length Lobs with CHUNKSIZE > 32767