Home » RDBMS Server » Server Utilities » IMP-00019: row rejected due to ORACLE error 1401
IMP-00019: row rejected due to ORACLE error 1401 [message #272321] Thu, 04 October 2007 10:05 Go to next message
meggens
Messages: 57
Registered: February 2007
Location: Netherlands
Member
Hi,

I'm facing following problem:
IMP-00019: row rejected due to ORACLE error 1401

database 1, oracle 10.1 on Linux
database 2, oracle 9 on windows.

I'm trying to import an schema from the oracle 10 database into the oracle 9 database. i'm using exp utility from the oracle 9 database to export the data and also to import the data in the oracle 9 database.

database 1 uses NLS_LANG=AMERICAN_THE NETHERLANDS.WE8MSWIN125 so I set this before export and import.

This is what i see in the import log, should i define another NLS_LANG before import?

Export file created by EXPORT:V09.02.00 via conventional path

import done in WE8MSWIN1252 character set and UTF8 NCHAR character set

import server uses AL32UTF8 character set (possible charset conversion)

export server uses AL16UTF16 NCHAR character set (possible ncharset conversion)

thanks in advance.

regards,
Martin Eggens







[Updated on: Thu, 04 October 2007 10:06]

Report message to a moderator

Re: IMP-00019: row rejected due to ORACLE error 1401 [message #272330 is a reply to message #272321] Thu, 04 October 2007 10:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Some characters take more bytes in UTF8:
SQL> select lengthb('') "1252", lengthb(convert('','AL32UTF8')) "UTF8" from dual;
      1252       UTF8
---------- ----------
         1          2

1 row selected.

You have to change the definition of columns of %CHAR% datatypes.
If you have a column T.COL of type VARCHAR2(10) then execute:
alter table t modify (col varchar2(10 CHAR));

Regards
Michel
Re: IMP-00019: row rejected due to ORACLE error 1401 [message #272342 is a reply to message #272330] Thu, 04 October 2007 11:37 Go to previous messageGo to next message
meggens
Messages: 57
Registered: February 2007
Location: Netherlands
Member
Hi,

Thanks for your reply, does this mean I should first import all the table structure, change the columns and then import the data?

Regards,
Martin
Re: IMP-00019: row rejected due to ORACLE error 1401 [message #272346 is a reply to message #272342] Thu, 04 October 2007 11:46 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
Previous Topic: Export/Import Data Pump
Next Topic: full import
Goto Forum:
  


Current Time: Fri Dec 09 02:03:30 CST 2016

Total time taken to generate the page: 0.13601 seconds