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
|
|
|
|
|
|