Re: character set problem while importing?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 15 Apr 2002 18:40:25 +0200
Message-ID: <oi0mbuk1de0ejv0dh0da1sho6e00vl2jnf@4ax.com>

On 15 Apr 2002 06:55:46 -0700, ht_news_at_hotmail.com (ht) wrote:

>This is an error while importing a database.
>How do I import this database correctly without that one table being rolled back.
>
>Greetings ht
>
>***********
>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: 19892 rows rolled back
>
>import done in WE8ISO8859P1 character set and UTF8 NCHAR character set
>import server uses UTF8 character set (possible charset conversion)
>export server uses WE8ISO8859P1 NCHAR character set (possible ncharset conversion)
>***********

Make sure the table definitions in both databases are identical.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Apr 15 2002 - 11:40:25 CDT