Import Error

[Tuma]

All,
I run an import and get

IMP-00058: ORACLE error 1461 encountered
ORA-01461: can bind a LONG value only for insert into a LONG column
IMP-00028: partial import of previous table rolled back: 40443 rows rolled back

The export client is oracle 8i and import client is 11g.
I know I could set NLS_LANG but I tried and it doesn't work yet.
===the 8i exporting database--
SQL> select * from nls_database_parameters where parameter = 'NLS_CHARACTERSET';

PARAMETER VALUE
---------------------- -------- ----------------------------NLS_CHARACTERSET US7ASCII

========the 11g importing database===

PARAMETER VALUE

--------------------- ---------------------
NLS_CHARACTERSET AL32UTF8

here is my NLS_LANG setting before running the import which failed..
set NLS_LANG=AMERICAN_AMERICA.US7ASCII
export NLS_LANG

thanks...

[stecal]

How did you make the connection between that error result (inserting a LONG into a column that doesn't support LONG) and the character sets?

[Tuma]

How did you make the connection between that error result (inserting a LONG into a column that doesn't support LONG) and the character sets?

because there is no LONG field on the table, the table is exported and imported as is...and some googling suggests is a client character set issue.

[PAVB]

please post full import command.