- Import Utility (IMP)
IMP-00032: SQL statement exceeded buffer length
IMP-00008: unrecognized statement in the export file

cause: The insert statement run when importing exceeds the default or specified buffer size.

For import of tables containing LONG, LOB, BFILE, REF, ROWID, LOGICALROWID or type columns, rows are inserted individually. If the sql statement on the .dmp file exceeds the default buffer size, the buffer size needs to be increased to accomodate this, otherwise the imp utility won’t be able to load the full sql statement into the buffer, spooling the IMP-00032,IMP-00008 error.

How to fix:

Increase the buffer size, and make sure that it is big enough to contain the biggest row in the table(s) imported. Import uses default buffer size of 30720.
For example: imp system/manager file=test.dmp full=y log=test.log buffer=1000000