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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s