Error IMP-20 Occurs During Import
Last updated on JULY 02, 2015
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 7.3.3 to 8.0.4]
***Checked for relevance on 20-Sep-2013***
During an import into either a 7.3.x or 8.0.x (up to release 8.0.4) database you encounter the following error:
*Cause: The column buffer is too small. This usually occurs when importing LONG data.
*Action: Increase the insert buffer size 10,000 bytes at a time (for example). Use this step-by-step approach because a buffer size that is too large may cause a similar problem.
This can occur both when the tables you are importing contain LONG fields and also when they do not.
The export is successful and you have tried FULL, USER and TABLE level export/import. Each fail with the same error.
This problem has been send when using either DIRECT or CONVENTIONAL export.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms