import where char set is different - ORA-01461

From: Luch <>
Date: Tue, 26 Feb 2008 18:16:32 -0800 (PST)
Message-ID: <>

One of our customers sent us an export dmp which we're trying to import. Their database uses a character set that is West European or MSWIN, whereas ours is Unicode. During the import, we get this error:

. . importing table                "DEFECT_REPORT"
IMP-00058: ORACLE error 1461 encountered
ORA-01461: can bind a LONG value only for insert into a LONG column IMP-00018: partial import of previous table completed: 614870 rows imported

The table contains two columns that are varchar2(4000). We believe this, along with the difference in character set, is the source of the problem. We think there are certain records that have data, that in a certain char set, are "too big" to fit into the same column once the database is in another character set.

The question is, is this assessment correct? And if so, what are the right steps to correct this, if I want to keep my database as Unicode? Should I try to look for the records that are causing this problem, and "truncate" them prior to the customer doing the export, etc? Received on Tue Feb 26 2008 - 20:16:32 CST

Original text of this message