How to fix the Oracle error IMP-00020: long column too large for column buffer size (number)?

In this post, you’ll learn more about the Oracle ErrorIMP-00020: long column too large for column buffer size (number) with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

IMP-00020: long column too large for column buffer size (number)

Reason for the Error IMP-00020: long column too large for column buffer size (number)

The column buffer is too small. This usually occurs when importing LONG data.

How to fix the Error IMP-00020: long column too large for column buffer size (number) ?

You can fix this error in Oracle by following the below steps

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.