OraFAQ Forum: Server Utilities » IMP-00019: row rejected due to ORACLE error 1401

Home » RDBMS Server » Server Utilities » IMP-00019: row rejected due to ORACLE error 1401

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

IMP-00019: row rejected due to ORACLE error 1401 [message #272321]

Thu, 04 October 2007 10:05

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

Michel Cadot
Messages: 68664
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

Report message to a moderator

Re: IMP-00019: row rejected due to ORACLE error 1401 [message #272342 is a reply to message #272330]

Thu, 04 October 2007 11:37

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

Report message to a moderator

Re: IMP-00019: row rejected due to ORACLE error 1401 [message #272346 is a reply to message #272342]

Thu, 04 October 2007 11:46

Michel Cadot
Messages: 68664
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes.

Regards
Michel

Report message to a moderator

Previous Topic:	Export/Import Data Pump
Next Topic:	full import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jun 24 07:53:55 CDT 2024