You may need to use CLOB instead of VARCHAR2 to convert LONG data type values. Some of your existing values may be too large to be contained in a VARCHAR2 in Oracle database.

DSupp2008